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
- 11117 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 pl sql commands?
what are the differences between binary and varbinary? : Sql dba
how to create a new table by selecting rows from another table in mysql? : Sql dba
what are the differences between char and nchar? : Sql dba
how to do backup entire database? : Transact sql
What are pl/sql cursors?
Can a select statement fire a trigger?
what are set operators in sql? : Sql dba
How do you truncate?
How do I view tables in sql developer?
What does select * from mean in sql?
Does inner join remove duplicates?
What is insert command in sql?
Is pl sql better than sql?
What is meaning of <> in sql?
