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

Home -> Community -> Usenet -> c.d.o.tools -> PLSQL and variable Table Names

PLSQL and variable Table Names

From: Annett Tempel <annett.tempel_at_gmx.de>
Date: Fri, 15 Jun 2001 16:47:50 +0100
Message-ID: <9gd72i$ta0$1@news.nrw.net>

Hi,

I have a short question.
I have to write a SQL-Statement where I count the records. thats no problem.

Code:
  CURSOR zaehler_cursor (tab_xx VARCHAR2:=tabelle) IS

      SELECT COUNT(*)
      FROM tab_xx;

you see that I'll give the tablename with a parameter. But there is a mistake and I dont know where? Can you help me?

Thanks and sorry for my english
Annett Received on Fri Jun 15 2001 - 10:47:50 CDT

Original text of this message

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