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
- 12546 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 the advantages of sql? Explain
What is oracle sql called?
What is column?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What does t sql mean?
Can there be more than one function with a similar name in a pl/sql block?
How does a trigger work?
Why do we need sharding?
Can we join two tables without common column?
What are all the common sql functions?
what is a join? : Sql dba
what is the difference between sql and t-sql? : Transact sql
what is the difference between truncate and drop statements? : Sql dba
What are tables and fields in the database?
How do I create a sql script?
