Dynamic SQL
From: Joseph Chia <blackeye_at_singnet.com.sg>
Date: 2000/02/19
Message-ID: <88m06f$m65$1_at_mawar.singnet.com.sg>#1/1
Date: 2000/02/19
Message-ID: <88m06f$m65$1_at_mawar.singnet.com.sg>#1/1
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, JoeReceived on Sat Feb 19 2000 - 00:00:00 CET