Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?
- 4 Answers
- 12545 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / anitha
It is true that the force option can be used to create the
view. But, this view will remain invalid even after the
creation the the Table. It needs to be recompiled again.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How many functions are there in sql?
How do I edit a trigger in sql developer?
Which data dictionary views have the information on the triggers that are available in the database?
Explain the difference between sql and mysql.
What is a composite primary key?
What are sql functions? Describe in brief different types of sql functions?
how to fetch alternate records from a table? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
Explain cursor types?
What are the types of queries in sql?
What are the indexing methods?
How to sort the rows in sql.
how to check server status with 'mysqladmin'? : Sql dba
Can we create clustered index without primary key?
How to convert comma separated string to array in pl/sql?
