Answer Posted / devendar
A view can be created even if the defining query of the
view cannot be executed, as long as the CREATE VIEW command
has no syntax errors. We call such a view a view with
errors. For example, if a view refers to a non-existent
table or an invalid column of an existing table, or if the
owner of the view does not have the required privileges,
then the view can still be created and entered into the
data dictionary.
You can only create a view with errors by using the FORCE
option of the CREATE VIEW command:
CREATE FORCE VIEW AS ...;
When a view is created with errors, Oracle returns a
message and leaves the status of the view as INVALID. If
conditions later change so that the query of an invalid
view can be executed, then the view can be recompiled and
become valid. Oracle dynamically compiles the invalid view
if you attempt to use it.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a database and a relational database?
What is the difference between syntax error and runtime error?
what is the use of double ampersand (&&) in sql queries?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how to convert dates to character strings? : Sql dba
define data blocks ? : Sql dba
Can we use commit inside a trigger?
List the ways to get the count of records in a table?
Why triggers are used?
What makes a good primary key?
what are the differences among rownum, rank and dense_rank? : Sql dba
Describe sql comments?
What are the most important characteristics of pl/sql?
What is sap sql?
