ALL_TABLES is different in PL/SQL ?

From: Luca Minudel <luca.minudel_at_nline.it>
Date: 16 Jun 1998 19:55:24 GMT
Message-ID: <01bd9957$bc9619c0$0100007f@w95luca>

When I execute this SQL:

 SELECT ROWNUM, OWNER, TABLE_NAME
 FROM ALL_TABLES; from SYSTEM user I get 83 rows.

When I execute the same selection from PL/SQL:

  create or replace procedure testproc as     cursor curtables is

       select owner, table_name, rownum
       from all_tables;

  begin
   for curtablesrec in curtables loop

     dbms_output.put_line(curtablesrec.rownum|| ' - ' || 
                          curtablesrec.owner || ' - ' || 
                          curtablesrec.table_name);

   end loop;
  end;
.
.
.

  SET OUTPUTSERVER ON;
  EXECUTE testproc;

I just get 18 rows. WHY???

---

 Luca Minudel                    software designer
 Italy                             Conegliano (TV)
 voice & fax                     +39 (0)438 412280
 e-mail                      luca.minudel_at_nline.it
 WWW                       (italian language used)

 http://www.geocities.com/SiliconValley/Vista/4041 Received on Tue Jun 16 1998 - 14:55:24 CDT