Posted on Wednesday, 2nd September 2009 by kwatog
SYNTAX
alter table
table_name
rename to
new_table_name;
Example
alter table
employee
rename to
employee_bak;
Tags: Oracle, rename table
Posted in Basic, Oracle | Comments (0)
Posted on Sunday, 12th April 2009 by kwatog
TOAD for Oracle and PL/SQL Developer are two indespensable developer tools. They have built-in tools to check the query plan of your SQL scripts. But in case you only have SQL*Plus as your editor, you ultimately need to know how it is done manually.
First Step : create plan
EXPLAIN PLAN FOR
your_query_to_optimize
a sample of which [...]
Tags: Explain Plan, Oracle, Query Plan, SQL*Plus
Posted in Intermediate, Oracle, Performance Tuning | Comments (0)
