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

what is the syntax of ALTER command?

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

How do you bind variables in oracle?

969

What is open database communication (odbc) in oracle?

996

How to check the server version in oracle?

1086

what are bitmap indexes? How does they work?

2232

How to get last row id?

981

How to do a full database export?

1093

How to count duplicated values in a column in oracle?

1031

What do you understand by a database object?

1048

What are advantages of dateset in datastage?

2257

what is Single Byte Overhead...?

2548

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2546

What is dual table oracle?

978

Is the After report trigger fired if the report execution fails ?

2906

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1012

What is system global area (sga) in oracle?

983