Dynamic SQL from PL/SQL (Oracle 7.1)
From: SPRINT1234 <sprint1234_at_aol.com>
Date: 16 Jan 1995 17:50:58 -0500
Message-ID: <3fet8i$ads_at_newsbf02.news.aol.com>
Date: 16 Jan 1995 17:50:58 -0500
Message-ID: <3fet8i$ads_at_newsbf02.news.aol.com>
Is there any way to execute dynamically created SQL statements in a PL/SQL procedure? Example,
v_var := 'Select * from table_1';
Begin
execute sql statement contained in v_var
Thanks in advance, Received on Mon Jan 16 1995 - 23:50:58 CET