Toad World® Forums

Views with "with" clause


#1

Hi

I will present this with an example (maybe is an intended feature,…)
A) Create a view:

CREATE VIEW d (
dummy )
AS
(select dummy from dual)
/

B) open it for edition
C) in the “sql clause” add
WITH READ ONLY

D) Apply changes to DB
E) the WITH READ ONLY will disapear

Workarounds
1)
CREATE or replace VIEW d (
dummy )
AS
(select dummy from dual)
WITH READ ONLY

  1. in the option tab in the view editor select “Use With Clause” :slight_smile:

I find it kind of a strange behaviour

Thanks
Filipe


#2

Hi Filipe,

This is an existing bug in 5.5 as well. I will raise a CR to have it fixed after 6.2. Thanks.

Gwen


#3

Hi Filipe,

After investigating, it turns out that this is not a bug. It may seem a bit odd but the ‘As’ field is only for the sql clause. ‘Use with clause’ has to be set on the options tab.

Gwen