alter table <table_name> add column <Data type of the column>;

what is the syntax of ALTER command?

Question Posted / sandeep

Answer Posted / sandeep

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What do you mean by cdb and pdb in oracle 12c?

1059

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

Can the query output be sorted by multiple columns in oracle?

992

What is SQL Tuning Advisor in Oracle?

1177

Explain drop constraint oracle?

1067

What is save point in oracle database?

1291

Does oracle partitioning improve performance?

992

What do database buffers contain?

1028

How to get last row id?

991

What are the differences between blob and clob in oracle?

1089

is there a tool to trace queries, like profiler for sql server?

1141

material view and view disadvantages?

1073

Explain overloading. Can functions be overloaded?

986

Explain compound trigger in oracle?

1037

How to do a full database export?

1106