SELECT order

From: <david.largeteau_at_sage.com>
Date: 10 May 2001 14:28:05 GMT
Message-ID: <9de8hl$ca5$1@news.netmar.com>

Hi,
How can i use variable table name in the FROM clause of a select statement ? In a PL/SQL bloc :
..

Begin
..

         SELECT COUNT (*)
           INTO w_count
           FROM name_of_table
           WHERE cod_clt = enr_orig.cod_clt;

..

End;

Thanks

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Thu May 10 2001 - 09:28:05 CDT