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

What is the difference between pre-select and pre-query?

1303

Explain do view contain data?

1052

List the various oracle database objects?

1111

How can we find out the current date and time in oracle?

1132

Explain enable novalidate constraint.

1132

How to pass parameters to procedures?

1089

What is a snapshot log?

1051

How to use subqueries with the in operator using oracle?

1139

What is the difference between primary key and unique key and foreign key in oracle?

1037

Is there a function to split a string in plsql?

1109

What is a table index?

1170

State the various uses of dbcc command?

1110

Can select statements be used on views in oracle?

1084

Explain the characteristics of oracle dba?

1176

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1121