scott stephens

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Learn about SQL*Plus 10g's new features

Get a rundown of the new features in the Oracle SQL*Plus product. For instance, one useful feature is the DBMS_OUTPUT enhancement, which helps you debug functions used in SELECT statements. The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility ...

Tags: Oracle Corp., SQL, Databases, Scott Stephens, Programming languages, Oracle SQL*Plus product, Oracle Flashback Drop feature, SQL*Plus 10g, Oracle Tips Newsletter, Default Option, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-07-28

Understand Oracle COM Automation for Windows

An Oracle database on Windows can act as a COM Automation client by referencing orawpcom.dll through an external procedure callout. Get more details about Oracle COM Automation for Windows. An Oracle database server running on a Windows machine can manipulate COM Automation server objects from PL/SQL...

Tags: Oracle Corp., SQL, Microsoft Windows, COM, ActiveX/COM/COM+/DCOM, Databases, Middleware, Scott Stephens, Programming languages, COM Automation, Oracle Tips Newsletter, TechRepublic Inc., PL/SQL, Automation, Object, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-07-27

Query data faster using sorted hash clusters

When you have a large number of keys, you'll start to see performance problems because now you have many cluster blocks. One way to get around this is by providing a hash function to restrict the number of cluster blocks. When data is stored in a normal table,...

Tags: Scott Stephens, Financial services, hash function, Oracle Tips Newsletter, Database, Credit Card, Oracle Application Server 10g, Table, Sales Channel, Storage, Databases, Sales, Hardware, Enterprise Software, Software, Data Management

Technical articles 2005-07-27

Export or import with Oracle Data Pump

In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump, which is much faster than these old client commands. Check out Data Pump to learn about its great new features. In Oracle 10g, exp and imp have been redesigned as the Oracle Data...

Tags: Oracle Corp., Data Pump, Recruitment & Selection, Databases, Scott Stephens, job, database, Oracle Tips Newsletter, TechRepublic Inc., Storage, Human Resources, Workforce Management, Hardware, Enterprise Software, Software, Data Management

Technical articles 2005-07-27

Understand Oracle 10g's new Hierarchical Query options

Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. Read about the new features in Oracle 10g that help with Hierarchical Queries. Oracle 10g adds new pseudo columns to the SQL Hierarchical...

Tags: Oracle Corp., Oracle Application Server 10g, Scott Stephens, Application servers, Oracle Tips Newsletter, Enterprise Software, Software

Technical articles 2005-07-27

Choose a method for passing arrays to the Oracle Provider for OLEDB

If you're looking for a way to pass an array of values to a PL/SQL stored procedure, you must use a technique to wrap an array into the proper PL/SQL structure on the server at runtime. Scott Stephens provides you with the necessary code. The Oracle Provider for OLEDB...

Tags: Oracle Corp., PL/SQL, SQL, Databases, Scott Stephens, Programming languages, Oracle Tips Newsletter, Procedure, Table, CreateObject, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-07-26

Use matrix operations to transform Spatial geometries

Oracle Spatial is a powerful set of Oracle objects for storing, manipulating, and querying graphical shapes. Scott Stephens demonstrates a simple matrix object that supports multiplication, as well as several graphic operations that you can derive from the matrix. Oracle Spatial is a powerful set of Oracle...

Tags: Oracle Spatial, Scott Stephens, integer, member function, Oracle Tips Newsletter, Function, TechRepublic Inc., Shape, Operation, Oracle Corp., Matrix, Listing B, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Technical articles 2005-07-26

Understand Oracle 10g's new multiset operators

Scott Stephens discusses Oracle 10g's new set of Advanced Multiset support operators for SQL Server 2003, which you can use with nested tables in an Oracle database. The Oracle 10g database release has a new set of Advanced Multiset support operators for SQL Server 2003, which ...

Tags: Oracle Corp., Oracle Application Server 10g, Scott Stephens, Databases, Application servers, Enterprise software, Num, nested table, Oracle Tips Newsletter, Value, Table, NUM_TAB_TYP, Storage, Programming Languages, Software, Data Management, Hardware, Software Development, Software/Web Development

Technical articles 2005-07-27

Passing SQL to Heterogeneous Services with DBMS_HS_PASSTHROUGH

There are some functions that cannot be mapped from Oracle SQL to the remote database SQL. In those cases, you should consider passing SQL directly to the remote host. Learn how to use the DBMS_HS_PASSTHROUGH "package" to pass SQL through to the remote database. Oracle's Heterogeneous Services layer...

Tags: Oracle Corp., SQL, DBMS_HS_PASSTHROUGH, Databases, Storage, Scott Stephens, Programming languages, database, Heterogeneous Services, remote database, Oracle Tips Newsletter, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Technical articles 2005-07-19

Use profiles in Oracle to create a password management policy

A great way to tighten database security is to set up profiles to implement password management policies. Scott Stephens suggests various profiles you might want to consider, which include restricting a password's format and placing a limit on a password's lifetime. Most Oracle database users create user accounts with...

Tags: Oracle Corp., Scott Stephens, password management, password, Oracle Tips Newsletter

Technical articles 2005-07-12

Use Oracle's Expression Filters to build a Business Rule Management System

Expression Filters, which were introduced with Oracle 10g, allow you to create a column that contains the conditions that must be met for a single row. Here's the code you need to use Expression Filters to build an extremely simple Business Rule Management System. Expression Filters are a new...

Tags: Oracle Corp., Databases, Scott Stephens, Programming languages, Expression Filter, business rule, Oracle Tips Newsletter, TechRepublic Inc., SQL, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Technical articles 2005-07-01

Clone database objects with dynamic SQL

It's possible to take a copy of one table and make a copy of it in another schema. However, if you want to do the same thing with any other database object, such as packages or functions, there is no simple command. Scott Stephens creates a package that allows you...

Tags: SQL, Databases, Scott Stephens, Programming languages, database, SQL*Plus COPY, source code, schema, Oracle Tips Newsletter, TechRepublic Inc., Procedure, Object, Object Owner, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Technical articles 2005-06-28

Understand how .NET can talk to OCI

If you want to fine-tune performance, it's useful to understand how .NET can talk directly to the Oracle Call Interface OCI. Learn how a .NET application can make an OCI call, as well as how you can create an OCI environment handle. .NET Framework applications are rapidly gaining popularity,...

Tags: Microsoft .NET, Oracle Corp., Oracle Call Interface, Storage, Databases, Middleware, Scott Stephens, .NET, database, Oracle Tips Newsletter, TechRepublic Inc., Microsoft .NET Framework, Performance, Application Servers, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management

Technical articles 2005-06-21

The Blog

The Blogblog rootPrevent Excel users from scrolling outside data areaIn Excel, you can create a macro to prevent users from moving outside the used range on a worksheet. Here's how.This post originally appeared on an external websiteChange computer account passwords in Windows NTLearn three ways you can disable the automatic...

Tags: Web site development, Web technology, .NET, Middleware, Microsoft development tools, Microsoft J#, Microsoft ASP.NET, frankki, Scott Stephens, System.Threading namespace, blog, external Website, Web site, Microsoft .NET

Discussion threads 2005-06-28

Simulate variable arguments in PL/SQL

There are different approaches that try to simulate variable arguments. However, since Oracle 8, there is a better method that developers often don't consider: using a simple VARRAY to wrap the variable portion of code. If you know lots of programming languages, then you're already accustomed to the...

Tags: Oracle Corp., PL/SQL, C/C++, Databases, Scott Stephens, Programming languages, Oracle Tips Newsletter, Argument, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-06-14

Using SQL*Loader to load objects

SQL*Loader is a fast way to get data into a database without writing complicated scripts. However, when it comes to Oracle objects that are related to each other, the documentation is a little vague. Here are two examples that will help you understand how to use SQL*Loader to load objects....

Tags: SQL*Loader, Listing D, Databases, Scott Stephens, Programming languages, Oracle Internet Directory, Oracle Internet, Oracle Corp., user-defined Oracle Internet Directory, Oracle Tips Newsletter, TechRepublic Inc., Database, Column, Object, Listing E, Storage, Hardware, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Technical articles 2005-06-07

Use Heterogeneous Services to access non-Oracle data

Oracle's Heterogeneous Services HS allows users to access data stored outside Oracle as if the data were in a local Oracle table. It can be intimidating setting up HS in Oracle SQL*Net, so check out these simple examples. Oracle's Heterogeneous Services HS allows users to access data stored...

Tags: Oracle Corp., MySQL, UDL, Databases, Scott Stephens, data source, Heterogeneous Services, UDL file, System DSN, Oracle Tips Newsletter, TechRepublic Inc., ODBC, Database, Data, SQL, ORACLE_HOME Directory, Microsoft Text Driver ODBC Driver, Enterprise Software, Software, Data Management

Technical articles 2005-05-31

Consider algorithms other than Soundex

Soundex is a phonetic normalization function that gets around the problem of sorting information by last names with different spellings but similar or identical sounds. Find out how alternate algorithms, such as Metaphone, have overcome some of Soundex's weaknesses. Oracle SQL string functions have included the Soundex function for...

Tags: Soundex, Metaphone, Engineering, Scott Stephens, algorithm, Oracle Tips Newsletter, TechRepublic Inc., Listing B

Technical articles 2005-05-24

Handle select exceptions efficiently

Programmers often use the same technique for handling SELECT statement exceptions, so it's wise to pick a technique that is efficient and readable. Scott Stephens takes the four most commonly seen techniques for handling the exception no data found and compares their performance. TechRepublic's Oracle newsletter covers automating Oracle...

Tags: Scott Stephens, PRODUCTIVITY, cursor, implicit cursor, Oracle Tips Newsletter, Method, TechRepublic Inc., Exception

Technical articles 2005-05-17

Call multiple trigger bodies with a single trigger

Within a single schema, a table or view can only have triggers of each of the four main types defined: before row, after row, before statement, and after statement. See how you can avoid that kind of conflict. TechRepublic's Oracle newsletter covers automating Oracle utilities, generating database alerts, solving...

Tags: Databases, Scott Stephens, Programming languages, trigger, ROWTYPE, PL/SQL, stored procedure, Oracle Tips Newsletter, TechRepublic Inc., Problem, Table, Listing C, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-05-10