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
- 7662 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
What is background process in Oracle?
How to use attributes of the implicit cursor in oracle?
How to use fetch statement in a loop?
What is a package ? What are the advantages of package ?
What are the various constraints used in oracle?
How do I reset a sequence in oracle?
How to estimate disk space needed for an export job?
How to define a record variable to store a table row?
List the various oracle database objects?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the simplest tool to run commands on oracle servers?
How to find out what oracle odbc drivers are installed?
What is a data dictionary and how can it be created?
How to loop through a cursor variable?
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.
