scottstephens, Author at TechRepublic

Search Close

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

scottstephens

Latest from scottstephens

Data Management

Recover from import errors in Oracle

When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus.

Enterprise Software

Exporting databases larger than 2 GB on UNIX

Many UNIX variants used system calls that operated on files with 32-bit unsigned integers to indicate file offset; these integers are limited to a range of 0 to 2 gigabytes. See how you can use Oracle's split trick to export a file up to around 10 GB and still stay under the 2 GB limit.

Developer

Improve dynamic SQL performance with binds

Don't be too quick to dismiss dynamic SQL used in PL/SQL programs. Scott Stephens provides code samples that demonstrate how using binds can help boost dynamic SQL performance.

Data Management

Implement search paging queries

When building custom search engines, developers often have problems implementing some kind of paging functionality. Learn how you can implement search paging queries using the pseudocolumn ROWNUM.

Developer

Create ActiveX servers for PL/SQL packages

When you're tuning database applications, your first impulse may be to follow the manuals' examples and start coding database logic directly into your code. Find out why a better approach is to treat the database server as a real server.

Data Management

Visualize your database with treemaps

This author demonstrates how to generate a simple treemap that uses shades between green, yellow, and red to show which tablespaces have low percentages of free space. Then, he offers a sample PHP script that could generate that graph.

Developer

Oracle Tip: Create linguistic helper functions in SQL

You can generalize simple tasks in a globalized environment by breaking down a particular language into a set of grammar rules and exceptions to those rules. Scott Stephens demonstrates how you can you do just that in SQL.

Enterprise Software

Oracle Tip: Create accented characters with COMPOSE and UNISTR

Oracle9i introduced the COMPOSE function, which allows you to take a sequence of Unicode characters and normalize the text. Find out how you can enter the Unicode sequence in pure ASCII text with the help of the UNISTR function.

Data Management

Oracle Tip: Understand the difference between IN and EXISTS in subqueries

When using rule-based optimization, you can determine the performance of a rule-based query by understanding which table is the driving table and how many rows each part returns. Find out how with this hands-on solution.

Data Management

Oracle Tip: Use DBCA to clone a database

Scott Stephens explains that, once the DBCA utility starts, you can create a new database, configure database INIT.ORA options, delete an existing database, or manage database templates.

Recruiting a Scrum Master with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit provides a customizable framework your business can use to find, recruit and ultimately hire the right person for the job. This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

Knowing the terminology associated with Web 3.0 is going to be vital to every IT administrator, developer, network engineer, manager and decision maker in business. This quick glossary will introduce and explain concepts and terms vital to understanding Web 3.0 and the technology that drives and supports it.

While the perfect color palette or the most sublime button shading or myriad of other design features play an important role in any product’s success, user interface design is not enough. Customer engagement and retention requires a strategic plan that attempts to measure, quantify and ultimately create a complete satisfying user experience on both an ...

scottstephens

Recover from import errors in Oracle

Exporting databases larger than 2 GB on UNIX

Improve dynamic SQL performance with binds

Implement search paging queries

Create ActiveX servers for PL/SQL packages

Visualize your database with treemaps

Oracle Tip: Create linguistic helper functions in SQL

Oracle Tip: Create accented characters with COMPOSE and UNISTR

Oracle Tip: Understand the difference between IN and EXISTS in subqueries

Oracle Tip: Use DBCA to clone a database

How to recruit and hire a Scrum Master

Web 3.0 quick glossary

How to recruit and hire a User Experience Designer

Industrial Internet of Things: Software comparison tool