i can create a view with two columns from emp table,, later
i need to add one more emp column to existing view.. what is
query
similarly add one more column to existing primary key
constraint.. please give me the solutions
Answer Posted / deepu
ALTER VIEW = CREATE OR REPLACE VIEW
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How many types of tables supported by oracle?
How can we find out the current date and time in oracle?
What happens to the current transaction if the session is ended?
Is primary key indexed by default in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to create a single index for multiple columns?
When do I need to use a semicolon vs a slash in oracle sql?
What is the quickest way to fetch the data from a table?
State the difference between a primary key and foreign key?
What is a read only transaction in oracle?
Explain the function of optimizer in oracle?
How to assign a table row to a record variable?
What is columnar storage what is the advantage?
How to define a cusotmer as a supplier in ORACLE R12
What is oracle sid?