what is the syntax of ALTER command?

Answer Posted / suri

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the five query types available in oracle?

536


Can we protect our pl/sql source code?

588


Will you be able to store pictures in the database?explain.

546


Explain about achiever in sql?

592


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1665






What is the difference between substr and instr?

529


Differentiate between translate and replace?

637


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1495


Explain constraining triggers.

612


What are the uses of a database trigger?

530


What is transaction control statement and how many types of transaction control statement in Oracle?

578


Explain mutating triggers.

582


what is insert all statement in sql

5536


What is a nested table and how is it different from a normal table?

589


What is oracle sid?

515