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


Please Help Members By Posting Answers For Below Questions

What is primefaces used for?

782


How to start an oracle instance?

775


What are the differences between number and binary_float in oracle?

827


What is meant by joins? List out the types of joins.

714


What is tns name?

732


Explain parameter file in oracle.

778


Give syntax for SQL and ORACLE joins.

852


How can we find out the current date and time in oracle?

829


What is oracle instant client?

752


How to create a new tablespace in oracle?

740


can anyody please send me the dump for Oracle 10g certifications for DBA path?

1915


What is the usage of analyze command in oracle?

838


How to load data from external tables to regular tables?

799


What is index-organized table in Oracle?

786


What privilege is needed for a user to delete rows from tables in another schema?

777