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?
Answer Posted / neo
Synonym can be created on non-existing table without using
Force keyword. It automatically become valid once table is
created.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data control language?
how to use like conditions? : Sql dba
how to enter characters as hex numbers? : Sql dba
What is output spooling in sql*plus?
Which is faster truncate or drop?
Why do we need a foreign key?
When is the explicit cursor used ?
What are procedures used for?
Why do we use procedures?
Can we join 3 tables in sql?
What is dcl in sql?
What is offset and limit in sql?
What is recursive stored procedure?
How do I pipe the output of one isql to another?
How do I edit a trigger in sql developer?