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 |
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
difference between truncate and delete ,drop?
What is the maximum number of CHECK constraints that can be defined on a column ?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Calculate difference between 2 date / times in oracle sql?
how the indexes are stored in the Oracle Database?
What is Undo Management Advisor in Oracle?
How do you rate yourself in oracle and sql server ?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
How to experiment a data lock in oracle?