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
- 11119 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 do I install microsoft sql?
Explain the the delete statements in sql?
what is the difference difference between procedure and packages
What is pivot table in sql?
what are the advantages of using stored procedures? : Sql dba
What is dml statement?
how to create a table index in mysql? : Sql dba
What is file based approach?
How can I make sql query run faster?
How do I partition in sql?
What is sql profiling in oracle?
Why do we use procedures in sql?
Can you join a table to itself?
What is a table partition?
what is the different between now() and current_date()? : Sql dba
