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.

What is difference between sql and mysql?

1137

---

How subquery works in sql?

1075

---

Explain constraints in sql?

1052

---

How do you create an update query?

966

---

What are analytical functions in sql?

1037

---

How do I tune a sql query?

981

---

What is the difference between mdf and ndf files?

1128

---

Define the select into statement.

1063

---

Explain polymorphism in pl/sql.

1125

---

what are date and time intervals? : Sql dba

1062

---

what are the advantages of sql ? : Sql dba

1063

---

Can we perform dml in function?

1072

---

Is sql open source?

979

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1643

---

What is raw datatype in sql?

1050

---