Answer / kalyan kumar

We can create a view with out table is known as forced view

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.

Answer / venkat

forced view a view which we can create regardless of Table
,for this status is view created with comilation errors

Answer / lakshmi

creates a view whether or not base table exists

Answer / sunny

Without creating a table we can create a view by using forced view.

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.

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

What is cursor explain with example?

0 Answers  

What are the parts of a basic sql query?

0 Answers  

Explain what is table in a database?

0 Answers  

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

Is sql the best database?

0 Answers  

What is use of trigger?

0 Answers  

how would concatenate strings in mysql? : Sql dba

0 Answers  

Is primary key clustered index?

0 Answers  

How do I trace sql profiler?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers