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
- 12714 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
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 the difference between having clause and where clause?
What are %type and %rowtype for?
How do I add a primary key to a table?
What does fetching a cursor do?
how can we know the number of days between two given dates using mysql? : Sql dba
Is postgresql a server?
What is triggering circuit?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How do I pipe the output of one isql to another?
What are the uses of sysdate and user keywords?
How are sql commands classified?
Describe sql comments?
what are ddl statements in mysql? : Sql dba
What is the least restrictive isolation level? : Transact sql
what is single byte over head in oracle..?
