Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7701 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / raghavendra
create or replace view <view_name> as select * from emp;
or you can provide the columns in select command
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How remove data files before opening a database?
How do I escape a reserved word in oracle?
What is integrity and what is constraint??Explain with example
How to delete all rows a table in oracle?
How to establish administrator authentication to the server?
What are the uses of synonyms?
How do you find current date and time in oracle?
Can you have more than one content canvas view attached with a window ?
What is a cognitive schema?
How many anonymous blocks can be defined?
How do we represent comments in oracle?
What are the differences between char and nchar in oracle?
Where are the settings stored for each instance in oracle?
How do I uninstall oracle client from windows?
