alter table tablename add(col1 datatype,col2 datatype...); alter table tab

what is the syntax of ALTER command?

Question Posted / guest

Answer Posted / guest

alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List the various oracle database objects?

1053

How to define an oracle sub procedure?

1136

What is the difference between a primary key & a unique key?

1086

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

2911

When do you get a .pll extension in oracle?

1144

What are the uses of linked server and explain it in detail?

1055

Explain the use of online redo log files in oracle.

1036

How to generate query output in html format?

1111

Explain the use of full option in exp command.

1110

What is oracle instant client?

1022

What are the arithmetic operations?

1079

How to run queries on external tables?

1039

Name the various constraints used in oracle?

1011

Can sub procedure/function be called recursively?

991

How to write numeric literals in oracle?

1178