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
- 11120 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / monika
Yes, we can create a view on a table that really doesn't
exist yet.We can do this by putting a word (Force) in
create view command-
create force view v1 as
select * from emp;
here view gets created but its staus is invalid,its become
valid when we create table emp(table on which view is
defined).
| Is This Answer Correct ? | 44 Yes | 2 No |
Post New Answer View All Answers
What is the difference between subquery and correlated query?
How do I remove sql plus from windows 10?
How do you modify a trigger?
Is primary key a clustered index?
What is a constraint? Tell me about its various levels.
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
what is a trigger in mysql? : Sql dba
What are % type and % rowtype?
What is sql trigger example?
how to run 'mysql' commands from a batch file? : Sql dba
What does select * from mean in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
How to create your own reports in sql developer?
Which one is better subquery or joins?
What is a table partition?
