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
- 12941 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 uncommittable transactions? : Transact sql
How can you fetch common records from two tables?
How many triggers can be applied to a table?
Why do we use procedures in pl sql?
What is the difference between partitioning and sharding?
What is the difference between pl and sql?
Which is better join or subquery?
what are date and time functions in mysql? : Sql dba
Can we commit inside a trigger?
What are the different parts of a package?
What is the life of an sql statement?
What is serial sql?
when is the use of update_statistics command? : Sql dba
Does db2 use sql?
What is sql engine in oracle?
