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
- 12756 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
how can you create an empty table from an existing table? : Sql dba
Explain dml and ddl?
How many types of triggers are there in pl sql?
Can we use view in stored procedure?
Mention what are different methods to trace the pl/sql code?
Which are the different case manipulation functions in sql?
How do you clear the screen in sql?
Does postgresql run on the cloud?
What is a procedure in pl sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Is sql a case sensitive language?
how to escape special characters in sql statements? : Sql dba
What is difference between joins and union?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Is record in oracle pl sql?
