alter table <tablename> add column(col.name(size))

what is the syntax of ALTER command?

Question Posted / sridevi

Answer Posted / sridevi

Is This Answer Correct ?

17 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to add another datafile to a tablespace?

1047

How to convert raw data type into text in oracle? Explain

998

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2361

Query to retrieve record for a many to many relationship ?

2528

How translate command is different from replace?

1095

How to create a table index in oracle?

1139

What is Segment Advisor in Oracle?

1109

How to use existing values in update statements using oracle?

1074

What is a trigger and what are its types?

1239

How to define a data source name (dsn) in odbc manager?

1040

Explain integrity constraints?

1109

What are set operators?

1090

What happens in oracle commit?

1033

How to loop through data rows in the implicit cursor?

1082

how can we store any pdf file in oracle

2166