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
- 12716 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / anitha
It is true that the force option can be used to create the
view. But, this view will remain invalid even after the
creation the the Table. It needs to be recompiled again.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do you declare a variable in pl sql?
What is java sql package?
Can we use ddl commands in pl sql?
Can we group by two columns in sql?
What is embedded sql what are its advantages?
Can we create a trigger on view?
What is $$ in sql?
What is cursor and its types?
what is isam? : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what are all the different types of indexes? : Sql dba
How many parts of a pl sql block are optional?
does sql support programming? : Sql dba
How do I make my sql query run faster?
