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
What is primefaces used for?
How to start an oracle instance?
What are the differences between number and binary_float in oracle?
What is meant by joins? List out the types of joins.
What is tns name?
Explain parameter file in oracle.
Give syntax for SQL and ORACLE joins.
How can we find out the current date and time in oracle?
What is oracle instant client?
How to create a new tablespace in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the usage of analyze command in oracle?
How to load data from external tables to regular tables?
What is index-organized table in Oracle?
What privilege is needed for a user to delete rows from tables in another schema?