Archives
-
PL/SQL quick reference
Oracle PL/SQL Quick Reference PL/SQL Block Structure DECLARE –Optional –Variables, Cursors, User-defined exceptions BEGIN –Mandatory –SQL statements –PL/SQL statements EXCEPTION –Optional –Actions to perform when errors occur END; –Mandatory
Jun 24th, 2009 | Filed under Database programming, Oracle, Oracle Database, Oracle developers, Oracle PL/SQL -
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