Hi,

select count(*) from all_objects
return 22410
while
select count(*) into cnt from all_objects
within PL/SQL
return 21274

And if I enclosed
create table test
as
select * from all_objects;

into PL/SQL and late to do:

select count(*) from test
it return 22410.

Why did I get different results?

Thanks,

Note: I logg into database as the same user with DBA privilege.


[Edited by sysdba on 02-19-2001 at 02:09 PM]