Creating a View Without Table in SQL

Hi Friends,

We can create a View without Table.

Solution is using FORCE key word in syntax.

Example : 

                CREATE OR REPLACE FORCE VIEW SAM_VIEW AS SELECT * FROM SAM_TAB;

While running this in Toad it will through an Error like ORA-00942: table or view does not exist.

But when you run below query you will come to know View created or Not.

                  DESC SAM_VIEW;

Now you can create you own table..

But still view is in invalid state.You need alter view.

                 ALTER VIEW SAM_VIEW COMPILE;

"Team Work" More We Less Me.

             Sameer Patil