Archives
-
SQL*Plus Basic commands
Using SQL*Plus SQL*Plus is a command-line tool that provides access to the Oracle RDBMS. SQL*Plus enables you to: Enter SQL*Plus commands to configure the SQL*Plus environment Startup and shutdown an Oracle database Connect to an Oracle database Enter and execute SQL commands and PL/SQL blocks Format and print query results SQL*Plus is available on several […]
Jun 24th, 2009 | Filed under Database programming, Oracle, Oracle Database, Oracle DBA, Oracle developers, Oracle PL/SQL -
SQL*Loader – complete reference
SQL*Loader SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session. SQL*Loader is an integral feature of Oracle databases and […]
-
Oracle SQL hints
/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if […]
Apr 2nd, 2009 | Filed under Applications Performance Tuning, Database Performance Tuning, Oracle, Oracle DBA
Recent Comments