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
Which are the five query types available in oracle?
Can we protect our pl/sql source code?
Will you be able to store pictures in the database?explain.
Explain about achiever in sql?
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?
What is the difference between substr and instr?
Differentiate between translate and replace?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain constraining triggers.
What are the uses of a database trigger?
What is transaction control statement and how many types of transaction control statement in Oracle?
Explain mutating triggers.
what is insert all statement in sql
What is a nested table and how is it different from a normal table?
What is oracle sid?