Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Image of scottstephens

scottstephens

Send scottstephens an email

Latest from scottstephens

  • Learn about SQL*Plus 10g’s new features
    Data Management

    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.

    scottstephens
    Published:  July 28, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Data Management
  • Export or import with Oracle Data Pump
    Tech & Work

    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.

    scottstephens
    Published:  July 27, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Tech & Work
  • Understand Oracle 10g’s new Hierarchical Query options
    Developer

    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.

    scottstephens
    Published:  July 27, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Developer
  • Understand Oracle 10g’s new multiset operators
    Data Management

    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.

    scottstephens
    Published:  July 27, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Data Management
  • Understand Oracle COM Automation for Windows
    Data Management

    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.

    scottstephens
    Published:  July 27, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Data Management
  • Query data faster using sorted hash clusters
    Banking

    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.

    scottstephens
    Published:  July 27, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Banking
  • Use matrix operations to transform Spatial geometries
    Enterprise Software

    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.

    scottstephens
    Published:  July 26, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Enterprise Software
  • Choose a method for passing arrays to the Oracle Provider for OLEDB
    Developer

    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.

    scottstephens
    Published:  July 26, 2005, 12:00 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Developer
  • Passing SQL to Heterogeneous Services with DBMS_HS_PASSTHROUGH
    Data Management

    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.

    scottstephens
    Published:  July 19, 2005, 8:32 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Data Management
  • Use profiles in Oracle to create a password management policy
    Data Management

    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.

    scottstephens
    Published:  July 12, 2005, 8:25 AM PDT Modified:  June 8, 2007, 9:58 AM PDT Read More See more Data Management
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next
56 results

TechRepublic Premium

  • TechRepublic Premium

    Guidelines for building security policies

    PURPOSE These guidelines from TechRepublic Premium will help you define the necessary ingredients of a security policy and assist in its proper construction. They’re designed to work hand in hand with the subjective knowledge you have of your company, environment and employees. Using this information, your business can establish new policies or elaborate on those ...

    Published:  March 23, 2023, 12:00 PM EDT Modified:  March 24, 2023, 1:00 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Artificial intelligence architect

    PURPOSE Recruiting an Artificial Intelligence Architect with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

    Published:  March 23, 2023, 12:00 PM EDT Modified:  March 24, 2023, 1:00 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Autonomous systems engineer

    PURPOSE Hiring the right Autonomous Systems Engineer requires a specific and precise recruitment process, supported by a thorough understanding of the project requirements. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, ...

    Published:  March 23, 2023, 12:00 PM EDT Modified:  March 24, 2023, 3:00 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Application support engineer

    PURPOSE This Hiring Kit: Application Support Engineer from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS AND SKILLSETS The skillset of successful Application Support Engineers is marked by balancing the technical expertise ...

    Published:  March 23, 2023, 12:00 PM EDT Modified:  March 24, 2023, 5:00 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice