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
- 7674 Views
- CGI, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venki
CREATE OR REPLACE VIEW VIEW_NAME AS SELECT COL1,COL2,REQ_COL
FROM EMP;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / prasad_dwh09
dropping and recreating of view is not i am expecting..
| Is This Answer Correct ? | 2 Yes | 2 No |
What language does oracle use?
What is data block in Oracle?
Define Normalization with example?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
Explain oracle’s server parameter file.
What is an oracle function?
How to run create database statement again?
How to resolve the ORA-39133 error in Oracle?
What is the difference between normal and corelated subqueries?
How to open a cursor variable?
How to use subqueries with the exists operator in oracle?
How to store pictures on to the database?
Oracle General 
