Re: Comparing pl/sql

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Thu, 28 Jun 2001 11:38:01 -0700
Message-ID: <F001.0033C641.20010628113036@fatcity.com>

Roland,

I just love your posts. I would guess that the procedure is doing something to further refine the select returned from the "pure" sql query.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    Roland.Skoldb                                                      
                       
                    lom_at_ica.se           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    Sent by:             cc:                                           
                       
                    root_at_fatcity.        Subject:     Comparing pl/sql - sql           
                       
                    com                                                                
                       
                                                                                       
                       
                                                                                       
                       
                    06/28/2001                                                         
                       
                    12:01 PM                                                           
                       
                    Please                                                             
                       
                    respond to                                                         
                       
                    ORACLE-L

Hallo,

I have a pl/sql code and when i run the procedure I get the result of 20 records(20 rows) but when I copy the sql query into the sql window and run only the query it gives me the result of 30 records(30 rows). What does this depend on? How can I
solve this problem?

Sincerely

Roland Sköldblom

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

Re: Comparing pl/sql - sql