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 to delete all rows a table in oracle?

1068

What are the different types of modules in oracle forms?

1001

How many types of synonyms in Oracle?

1124

What is background process in Oracle?

1101

What are the differences between interval year to month and interval day to second?

1027

How to do paging with oracle?

999

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

What is data block in Oracle?

1116

What is the Tune Query

2291

What are the ways tablespaces can be managed and how do they differ?

2367

what are archived logs?

2199

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1033

How to change user password in oracle?

1029

How to get execution path reports on query statements?

987

Is oracle a programming language?

986