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
- 7819 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 is instant client oracle?
How to write a left outer join with the where clause in oracle?
Who i will insert 1 lacks record in a Database table
What are oracle functions?
Why we use bulk collect in oracle?
How to insert a new row into a table in oracle?
In Oracle 10g, "g" Stands for what?
how to tune oracle sql queries pls tell me step by step. urgent pls
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What exactly do quotation marks around the table name do?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Oracle General 
