Archives
-
Oracle SQL tuning tips
Oracle SQL Tuning Tips consideration when writing an SQL statement is that it returns a correct result. The second is that it be the most efficient for a given situation. You can use many different SQL statements to achieve the same result. It is often the case that only one statement will be the most […]
Jun 24th, 2009 | Filed under Database Performance Tuning, Database programming, Oracle, Oracle Database, Oracle DBA, Oracle developers, Oracle PL/SQL -
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
Recent Comments