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
- 7562 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 |
17. Display the order number and average item cost for each order.
How to update a table row with a record?
What is difference between Rename and Alias?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
how to find the second highest salary in a given table????
What do you mean by a tablespace?
How to open and close an explicit cursor in oracle?
Point out the difference between user tables and data dictionary?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is clustered table in Oracle?
Oracle General 
