Re: Newbie ? - Howto find nbr records in a table

Hi,

>I want to find out how many records (total) are in a table. I'm writing
>some
>PL/SQL to allow a user to interact with an Oracle database from a
>pc-based
>browser.

This will do:

declare
  v_count NUMBER;
begin
  select count(*)
  into v_count
  from my_table;
end;

That will be all folks!   

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---