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
- 12746 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
What is input buffer in sql*plus?
which operator is used in query for pattern matching? : Sql dba
What is clustered index sql?
What is pl sql commands?
how to write date and time literals? : Sql dba
Can a procedure in a package be overloaded?
What is mutating table error?
does sql support programming? : Sql dba
How do I view tables in sql developer?
What is sql character function?
Is sqlite good enough for production?
What are tuples in sql?
what is oltp (online transaction processing)? : Sql dba
What is difference between inner join and self join?
What has stored procedures in sql?
