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
- 12707 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
Explain the advantages and disadvantages of stored procedure?
How do I find duplicates in sql?
How much does sql cost?
What information is needed to connect sql*plus an oracle server?
what is sql? : Sql dba
Why is a primary key important?
What is microsoft t sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is sap sql anywhere?
Is it possible to read/write files to-and-from PL/SQL?
Does truncate remove indexes?
Explain the uses of a database trigger?
Is left join same as inner join?
How to get unique records from a table?
What are different functions in sql?
