Using FORCE Command we can create a view without base table.

How to create a view on a table which does not exists

Question Posted / vijayakumar

Answer Posted / vijayakumar

Is This Answer Correct ?

40 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are types of indexes in sql?

1065

What are the main features of cursor?

1066

What are the types of triggers in sql?

1067

Explain the update statement in sql

971

What is meant by cursor in sql?

972

What are the triggers associated with image items?

1031

What is the benefit of foreign key?

1009

What is a sql profiler?

1002

Is progress software supports to ( pl/sql )?

1022

Explain the working of primary key?

1074

What are the differences between implicit and explicit cursors?

1049

How to change the order of columns in Oracle SQL Plus ?

1041

how do you tune the slow running queries in oracle db , explain the methodology

2582

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

985

What does stand for in sql?

952