Re: Dynamic SQL
From: Dan Rippel <jford_at_mail.erols.com>
Date: 1996/05/16
Message-ID: <4ncek7$vnb_at_news6.erols.com>#1/1
Date: 1996/05/16
Message-ID: <4ncek7$vnb_at_news6.erols.com>#1/1
Yes.
There are two ways of doing this.
If you have PL/SQL 2.1, there is a package called dbms_sql. This has
some functions and procedures which shuold help you.
If you dont have PL/SQL 2.3 then it gets fun. You basically have to program a UNIX daemon to execute the statement using EXEC SQL embedded SQL. Oracle will send you the code for the daemon as well as code for a PL/SQL package to call the daemon.
"Aravind,B.R." <aravindbr_at_calsoft-mas_at_chemoil.com> wrote:
>-How to use dynamic SQL in oracle?
> -Is it possible to create SQL query from a string with proper
>SQL syntax?
Received on Thu May 16 1996 - 00:00:00 CEST