what is the syntax of ALTER command?

Answer Posted / guest

alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of Database Trigger ?

1100


What is Redo Log Buffer in Oracle?

627


Is insert autocommit in oracle?

601


What is a oracle database?

605


How to create a new table in your schema?

605






What is set verify off in oracle?

576


What are the advantages of oracle?

546


How to rename an existing table?

606


ABOUT IDENTITY?

1554


IS it possible to built the oracle database without setting the kernal parameters?

1759


Oracle

1849


if you ctreate table identity

1845


How to start your 10g xe server from command line?

544


How to view the data files in the current database?

592


How to sort output in descending order in oracle?

574