From oracle-l-bounce@freelists.org Tue Nov 8 05:56:37 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jA8Bub3u023907 for ; Tue, 8 Nov 2005 05:56:37 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jA8BuWvX023881 for ; Tue, 8 Nov 2005 05:56:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3323B21CC3A; Tue, 8 Nov 2005 06:56:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18228-08; Tue, 8 Nov 2005 06:56:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A3B8A21C7AC; Tue, 8 Nov 2005 06:56:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Nov 2005 06:54:33 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 181E921CCF9 for ; Tue, 8 Nov 2005 06:54:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17916-06 for ; Tue, 8 Nov 2005 06:54:33 -0500 (EST) Received: from proxy.HNIT.is (proxy.hnit.is [193.4.243.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53FF721CE54 for ; Tue, 8 Nov 2005 06:54:32 -0500 (EST) Received: from HNIT-SEIFUR.HNIT.is ([193.4.243.94]) by proxy.HNIT.is with InterScan Messaging Security Suite; Tue, 08 Nov 2005 11:53:23 -0000 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5E45B.0551945A" Subject: RE: Re: Select from dual return 3 rows ! Date: Tue, 8 Nov 2005 11:53:23 -0000 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Re: Select from dual return 3 rows ! Thread-Index: AcXkVe54eKjsD7ABTGu4gIyrt+raFAABOWYA From: "Laimutis Nedzinskas" To: X-archive-position: 28115 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lnd@HNIT.is Precedence: normal Reply-To: lnd@HNIT.is X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5E45B.0551945A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Has someone created/granted view or table/synonym for system.dual ? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Frank B Hansen =09 Hi David =20 OK. Next question and some additional info: =20 It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned. =20 =20 ------_=_NextPart_001_01C5E45B.0551945A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Has=20 someone created/granted view or table/synonym for system.dual=20 ?
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On=20 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=20 connect as SYS og SCOTT, only 1 row is returned.
 
 
------_=_NextPart_001_01C5E45B.0551945A-- -- http://www.freelists.org/webpage/oracle-l