REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	c_count_rec_2.sql
REM
REM <SQLDIR_GRP>UTIL</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	   ** DO NOT RUN THIS SCRIPT BY IT SELF **
REM	** This file is called by c_count_rec_1.sql **
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	c_count_rec_2.sql
REM 
REM Example:
REM	c_count_rec_2.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

set feedback off
set verify off
set term off
set lines 90
set pages 0
clear col
clear breaks


declare
record_cnt   NUMBER(38);
begin
  --
  -- Select count of records into var RECORD_CNR (1 is a passing owner.table_name)
  --
  select count(*)
  into   record_cnt
  from   &&1;
  --
  -- Insert owner.table_name and count values into table RECORD_CNT
  --
  insert into RECORD_CNT_TABLE values
  ('&&1',record_cnt);
  commit;
end;
/

undefine 1