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

How do we represent comments in oracle?

1044

What is the dynamic sql in oracle?

1068

Can you drop an index associated with a unique or primary key constraint?

1015

Explain joins in oracle?

1031

What is the max number of columns in an oracle table?

994

How to use fetch statement in a loop?

1019

What do you mean by merge in oracle?

993

How to create a new user account in oracle?

1012

Explain integrity constraints?

1102

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2551

Explain what are the type of synonyms?

1103

What are the data types in oracle?

1035

How to convert characters to dates in oracle?

1091

Explain oracle data types with examples?

1025

Explain how you would restore a database using RMAN to Point in Time?

2139