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
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 |
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
Can sub procedure/function be called recursively?
What is a view and how is it different from a table?
Can you use a commit statement within a database trigger?
Explain the difference between a procedure and a function?
Is oracle an operator?
what is normalisation?what are its uses?
State any two functions of oracle?
what is the uses of cusor
What are various joins used while writing SUBQUERIES?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
how to retrieve daily sal from emp table in oracle 10g