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
- 12729 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
Is vs as in pl sql?
How do I start sql from command line?
What is the difference between sql, mysql and sql server?
Difference between global and parameter variables?
What is the sql case statement?
How do you delete duplicates in sql query using rowid?
how to enter characters as hex numbers? : Sql dba
What is use of term?
What is the difference between an inner join and an outer join?
Name the different types of indexes in sql and define them.
Is sql similar to python?
How do I trace sql profiler?
What is the non-clustered index in sql?
How many primary keys can a table have?
What is posting?
