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 a sql schema used for?
How do I run a pl sql procedure in sql developer?
Why stored procedure is faster than query?
What is over () in sql?
How can you tell the difference between an index and a view?
What is the largest value that can be stored in a byte data field?
What does count (*) mean?
what are the advantages of mysql in comparison to oracle? : Sql dba
what are the types of join and explain each? : Sql dba
Can a primary key be a foreign key?
How to start oracle sql developer?
Write a query to display the current date in sql?
how is exception handling handled in mysql? : Sql dba
Can we create table in function?
What is the difference between mdf and ndf files?