Re: SQL syntax?

Hi Robert
  I'm studying SQL using Oracle 8i. From a command line using SQL:

Question I:

ALTER TABLE table_name ADD column_name(datatype);

Question II:

• Mean: delete all the rows ?
  1. TRUNCATE TABLE table_name; this is fast, but is not a DML, so it cannot be rollbacked.
  2. DELETE FROM table_name; this is slower, but can be rollbacked.
• Mean: "delete" the table itself ? 3. DROP TABLE table_name;

Recommand this book:

Sams Teach Yourself SQL in 21 Days (3rd Edition), Ryan K. Stephens, Ronald R. Plew

regards

N. Stern Received on Fri Nov 16 2001 - 09:31:50 CET