If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select ...

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which ...