Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Row-Count in PL/SQL

Row-Count in PL/SQL

From: Oliver Braun <oliverb_at_online.de>
Date: Thu, 15 Jan 2004 18:57:24 +0100
Message-ID: <bu6jpu$5es$1@online.de>


Hi,

IŽd like to count table-rows in PL/SQL.
The tablename comes from a variable. Something like:

SELECT COUNT(*) INTO V_ROWS
FROM V_TABLE_NAME; I still get the same error message:
"V_TABLE_NAME must be declared"

But V_TABLE_NAME is declared in my
CURSOR-SELECT-Statement.

Thanks for all suggestions.

O.Braun Received on Thu Jan 15 2004 - 11:57:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US