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 to run the anonymous block again?

1072

How to revoke create session privilege from a user in oracle?

969

What is the difference between "as" and "is" in an oracle stored procedure?

951

What is the disadvantage of User defind function?

2250

How to use "in" parameter properly?

1010

What is the difference between $oracle_base and $oracle_home?

1045

How to use group functions in the select clause using oracle?

1033

What is primefaces used for?

1015

Which is better Oracle or MS SQL? Why?

6274

How to see the table columns used in an index?

974

How to connect to a local oracle 10g xe server?

948

What is oracle database client?

982

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4499

why dont we assign not null constraint as table level constraint.

2691

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

969