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
- 7536 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 |
Explain the use of analyse option in exp command.
How to use an explicit cursor without open statements?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is meant by raw datatype?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How oracle handles dead locks?
Explain oracle left join with an example?
What is a data lock in oracle?
How to connect to the server with user account: sys?
What is materialized view in Oracle?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
What is the disadvantage of User defind function?
Oracle General 
