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
- 11184 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 are sql functions? Describe in brief different types of sql functions?
what is try_catch block in procedure
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What do you mean by dbms? What are its different types?
how to fetch alternate records from a table? : Sql dba
What is a natural join sql?
Can we perform dml in function?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How much does sql certification cost?
Can triggers stop a dml statement from executing on a table?
Is sql a case sensitive language?
What is faster join or subquery?
What's the procedure?
How can we make an if statement within a select statement?
Is sql procedural language?
