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
- 7675 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
What is the relation of a user account and a schema?
How to shutdown your 10g xe server?
How to connect to a local oracle 10g xe server?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to estimate disk space needed for an export job?
Explain oracle’s system global area (sga).
Is oracle a relational database?
How remove data files before opening a database?
When system tablespace is created?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Explain the types of exception?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
