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
- 6963 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / venki
CREATE OR REPLACE VIEW VIEW_NAME AS SELECT COL1,COL2,REQ_COL
FROM EMP;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to export your own schema?
How to export your connection information to a file?
How a tablespace is related to data files?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What are the common oracle dba tasks?
What is the quickest way to fetch the data from a table?
How to store pictures on to the database?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is the difference between sharding and partitioning?
Is truncate autocommit in oracle?
Difference between the “verify” and “feedback” command?
Can group functions be mixed with non-group selection fields?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to assign values to variables?
What is the order of defining local variables and sub procedures/functions?
