what are the forced views
Answers were Sorted based on User's Feedback
Answer / kalyan kumar
We can create a view with out table is known as forced view
Is This Answer Correct ? | 36 Yes | 2 No |
Answer / 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 |
Answer / venkat
forced view a view which we can create regardless of Table
,for this status is view created with comilation errors
Is This Answer Correct ? | 16 Yes | 3 No |
Answer / lakshmi
creates a view whether or not base table exists
Is This Answer Correct ? | 16 Yes | 3 No |
Answer / sunny
Without creating a table we can create a view by using forced view.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / manoranjan sethy
You can create a view without taking the assistance of base table but base table signature must be required while creating of force view.
Is This Answer Correct ? | 0 Yes | 2 No |
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
how to calcuate the second highest salary of he employee
What types of commands can be executed in sql*plus?
What is gpt format?
Is hadoop a nosql?
Which nosql database is best?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
what does the t-sql command ident_current does? : Transact sql
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Can procedure in a package be overloaded?
what is a unique key ? : Sql dba