Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dynamic SQL question
I have done a similar dynamic sql procedure, but it was at my last job, so I don't have the script anymore. I found most of what I needed in the book Oracle PL/SQL Programming by Steven Feuerstein, O'reilly & Associates, Inc. It is a good book for PL/SQL at built-in packages, such as dynamic SQL.
Frank Abney Email: abneyf_at_osshe.eduOregon State System of Higher Education Phone: (541) 737-6269
On Fri, 10 Jan 1997, Nedee & Co wrote:
> Do u need to work in Pro*C ?
> The dbms_pipe package is a very good tool for dynamic SQL, so u can
> write your programs in PL/SQL. Just an idea...
>
> Pete.
>
> Marty Frongillo <mfrongillo_at_onwardtech.com> wrote:
>
> >I'm trying to use dynamic sql for the first time. I want to have a
> >general
> >purpose routine, where I pass in the table-name and field-name and it
> >will query the database. I can't seem to get this to work.
>
>
>
>
>
Received on Fri Jan 10 1997 - 00:00:00 CST