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

What is a snapshot in oracle database?

1073

how to clone 9i Database on to 10g Database.

2388

Explain the use of grant option in exp command.

1111

What is oracle analytical function?

1233

What is an oracle database?

1111

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2104

What suggestions do you have to reduce the network traffic?

1020

Where do we use decode and case statements?

1063

How to delete a column in an existing table?

1132

How to start a new transaction in oracle?

1136

Is insert autocommit in oracle?

1134

What is an oracle wallet?

993

How to execute a stored procedure in oracle?

1148

Is it possible to insert comments into sql statements return in the data model editor ?

2638

What is oracle instant client?

1069