TheOracle documentation SQL Reference is quite handy for getting this info.
It is available on the CD you got from Oracle or at www.technet.oracle.com
(have to register for free).
alter table sales add mycolumn columntype;
get rid of the table or delete the rows?
drop table xyz;
delete from xyz;
commit;
or truncate table xyz; see documentation for difference between truncate and
delete BEFORE you use it.
Jim
"ROBERT WEST" <rob-west_at_worldnet.att.net> wrote in message
news:We0J7.171918$3d2.7138194_at_bgtnsc06-news.ops.worldnet.att.net...
> I'm studying SQL using Oracle 8i. From a command line using SQL:
>
> Question I:
>
> Once I have a table created, sales, and I now wish to add another field,
> column, what would be the syntax?
>
>
> Question II:
>
> What is the syntax to delete a whole table?
>
> Thank you,
> Rob-west_at_worldnet.att.net
>
>
>
Received on Thu Nov 15 2001 - 22:21:11 CST
