view syntax
I am trying to figure out how the below VIEW syntax works:
create or replace view v3 as select 1 n union all select 1 union all select 1;
It is taken from here
http://www.artfulsoftware.com/infotree/qrytip.php?id=95.
It tries to create dummy rows...
Can somebody help me a little on this? what exactly is selected with 1 n-to start with?
Subject
Written By
Posted
view syntax
April 14, 2015 03:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.