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

How is it different from a normal table?

579

How do we get field details of a table?

547

How many memory layers are in the oracle shared pool?

637

What is the difference between postgresql and oracle?

503

What are the different windows events activated at runtime ?

2408

definition of cluster and non-clustered index?

2475

What is save point in oracle database?

725

What is background process in Oracle?

624

Explain the use of constraints option in exp command.

558

How do I use unicode codesets with the weblogic jdriver for oracle driver?

549

When do you get a .pll extension in oracle? Explain its importance

572

Explain an exception and its types?

608

How to rename a column in an existing table?

615

How to drop an existing table in oracle?

589

What are the original export and import utilities?

569