Dynamic SQL

From: Joseph Chia <blackeye_at_singnet.com.sg>
Date: Sat, 19 Feb 2000 19:51:25 +0800
Message-ID: <88m06f$m65$1@mawar.singnet.com.sg>

Can someone kindly send me a sample of a PL/SQL procedure for Oracle 8i on Dynamic SQL.

Say I have 2 tables, Table1 and Table2 of equivalent declaration

        id number(3,0)
        name varchar2(50)

I have to select the name of id=50 but it all depends on the tablename as the input.

Can I do it with just one stored procedure with the tablename as input because now I have to differentiate the tablename in a Pro*C program prior to calling the appropriate stored procedure.

--
Regards,

Joe Received on Sat Feb 19 2000 - 05:51:25 CST