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
- 7820 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 are the various types of snapshots ?
What is PL/SQL ?
What is the sql query to concatenate column values from multiple rows in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Will you be able to store pictures in the database?explain.
What is a named program unit?
Can multiple columns be used in group by in oracle?
How to define a record variable to store a table row?
How to create an oracle testing table?
Please explain oracle left join with an example?
What is the difference between online and offline backups?
What is a partition in oracle?
What are a query and state the different types of queries and their uses?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to update values on multiple rows in oracle?
