Re: PLSQL and variable TABLE Name

From: Walter Stucki <wstucki_at_oekosoft.ch>
Date: Sat, 21 Jul 2001 21:53:16 GMT
Message-ID: <3b2a33d3_1_at_news.bluewin.ch>

You could use dynamic sql by the
built-in package dbms_sql.

Best regards
Walter Stucki, Oekosoft

---

www.oekosoft.ch | www.web-home.ch | www.linkex.ch

"Annett Tempel" <annett.tempel_at_gmx.de> wrote in message news:9gd51p$ngk$1_at_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 Sat Jul 21 2001 - 23:53:16 CEST