| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Manipulation
Robert H. Thompson (rthomp41_at_ford.com) wrote:
: create table temp (
: commit; - this will commit (create the table in the database)
Not needed. "Create table" is a DDL (Data Definition Language) command and these are automatically committed.
"Drop table" and "truncate" are also DDL commands, and so don't need a commit.
--
rgds
Stephen
Received on Thu Feb 25 1999 - 08:51:53 CST
 |
 |