);
end loop;
END;
/
Regds,
New Bee
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Thursday, October 17, 2002 4:12 PM
To: '[EMAIL PROTECTED]'
Subject:How to get the count of
.put_line( 'Count is:= ' || countval );
end loop;
END;
/
Regds,
New Bee
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Thursday, October 17, 2002 4:12 PM
To: '[EMAIL PROTECTED]'
ect: How to get the count of all tables using dbms_sql
>
>
> Hi,
>
> I need to insert the total number of records all the tables
> into the table,
> MIGRATION_TABLE. I want to use the
> How do I obtain the count(*) into a variable in
> "dbms_sql
"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi,
>
> I need to insert the total number of records all the tables into the table,
> MIGRATION_TABLE. I want to use the
> How do I obtain the count(*) into a variable in "dbms_sql.parse(cid, 'SELECT
> COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_
Hi,
I need to insert the total number of records all the tables into the table,
MIGRATION_TABLE. I want to use the
How do I obtain the count(*) into a variable in "dbms_sql.parse(cid, 'SELECT
COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7); " ?
TIA
Declare
cid INTEGER;
BEGIN