RE: Re: Select from dual return 3 rows !

From: Laimutis Nedzinskas <lnd_at_HNIT.is>
Date: Tue, 8 Nov 2005 11:53:23 -0000
Message-ID: <B201EF146906A446B13E38A111BD83791F5900@HNIT-SEIFUR>

Has someone created/granted view or table/synonym for system.dual ?

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frank B Hansen         

        Hi David          

        OK. Next question and some additional info:          

        It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned.                    

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 08 2005 - 05:56:37 CST