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
- 11886 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 clustered and nonclustered index in sql?
How do I make my sql query run faster?
What are the disadvantages of file system?
Does sap use sql?
How does stored procedure reduce network traffic?
Can a primary key be a foreign key?
Does a user_objects view have an entry for a trigger?
Why select is used in sql?
What is the execution plan in sql?
Can we create index on primary key?
Explain the select statement in sql?
What is pivot table in sql?
How do you write an inner join query?
How do you identify a primary key?
What is the usage of the distinct keyword?
