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
- 11887 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
Does postgresql run on the cloud?
what is acid property in database? : Sql dba
Name the different types of indexes in sql and define them.
How do you delete data from a table?
What are schema-level triggers?
What is the advantage of index in sql?
What is dml with example?
What is primary and foreign key?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Can we write dml inside a function in sql server?
What is the difference between sql and mysql?
What is sap sql anywhere?
How do I run a program in pl sql?
What is trigger in pl sql?
How do you declare a variable in pl sql?
