what is the syntax of ALTER command?

Answer Posted / sandeep

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

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

567


how do u setup a replication site?

1511


Explain how are indexes update?

634


what are archived logs?

1723


what are the advantages of running a database in archive log mode?

1743






Is the After report trigger fired if the report execution fails ?

2414


How to connect ms access to oracle servers?

558


What is integrity and what is constraint??Explain with example

1711


How can I combine multiple rows into a comma-delimited list in oracle?

589


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1592


How can I get column names from a table in oracle?

548


Explain the use of show option in imp command.

650


What is program global area (pga) in oracle?

613


 What are the oracle DML commands possible through an update strategy?

592


In what script is snap$ created? In what script is the scott/tiger schema created?

2257