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
- 12702 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
Can we use ddl statements in stored procedure sql server?
What is the use of triggers?
Explain the working of primary key?
What is the use of index in hive?
How does stored procedure reduce network traffic?
What are the indexing methods?
define data blocks ? : Sql dba
What are the parts of a basic sql query?
What are expressions?
What are the two different parts of the pl/sql packages?
How do you change a value in sql?
What are different joins used in sql?
What is the most common sql injection tool?
What is varray in pl sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
