OraFAQ Forum: SQL & PL/SQL » Use of Force View

Home » SQL & PL/SQL » SQL & PL/SQL » Use of Force View

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Use of Force View [message #154518]

Mon, 09 January 2006 04:02

ashok_nr23
Messages: 30
Registered: April 2005

Member

Hi all,

Can anyone tell me the uses of "force views" in Oracle.

TIA
Ashok.

Report message to a moderator

Use of Force view [message #154520 is a reply to message #154518]

Mon, 09 January 2006 04:09

ashok_nr23
Messages: 30
Registered: April 2005

Member

Hi all,

I want to know the exact use of force view in Oracle.
I know the logic behind force view but want to know the purpose of having a view without any base table for it.

Please help me in this.

TIA,
Ashok.

Report message to a moderator

Re: Use of Force View [message #154521 is a reply to message #154518]

Mon, 09 January 2006 04:10

Frank
Messages: 7901
Registered: March 2000

Senior Member

The object is a view. The keyword force refers to the create command.
Normally if there is an error in the viewdefinition, the view is not created.
If you add the keyword 'force', the view is created anyway (albeit with an error).

hth

Report message to a moderator