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
- 6947 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Briefly explain what is literal? Give an example where it can be used?
Please explain oracle data types with examples?
Explain about functional dependency and its relation with table design?
Can I create users through internet explorer in oracle 10g?
How to check database size in Oracle?
How to bring a tablespace offline?
How to use "while" statements in oracle?
How to convert characters to dates in oracle?
Explain joins in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to install oracle database 10g xe?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is Virtual Private Database in Oracle?
What do you mean by group by clause?
