[font="Verdana"]Dear Author,

if you consider the following ... it would be syntax error

CREATE VIEW A_TEMP AS

WITH RESULTSET AS (SELECT * FROM SYS.ALL_OBJECTS WHERE TYPE = 'U')

and if you consider the following

CREATE VIEW A_TEMP AS

WITH RESULTSET AS (SELECT * FROM SYS.ALL_OBJECTS WHERE TYPE = 'U')

SELECT * FROM RESULTSET

it means good you have done.

I conceived your quest statement as 'The Single Defining Select Statement of View Definition' as shown in code segment 1 above.

And i consider the 2nd code segment "SELECT * FROM RESULTSET" as 2nd select statment with in the view defintion.

So please let try to elaborate your quest further so ppl can get really enjoy these quests.

Thank you for next time elaboration.

[/font]