Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help on Dynamic PL/SQL

Re: Need help on Dynamic PL/SQL

From: Jomarlen <jomarlen_at_aol.com>
Date: 1998/01/20
Message-ID: <19980120191901.OAA15509@ladder01.news.aol.com>#1/1

Hi

One of the *goodies* you can find in the PL/SQL library on the Oracle Utilities page of my web site is a funtion *in_quotes*. (http://members.aol/jomarlen/

This saves working out how many quotes you need to achieve your value enclosed in quotes.

Ramesh's string assign would be simply

sel_store := 'SELECT * FROM STUDENT_TABLE WHERE ' || NAME
>|| '=' || in_quotes('RAMESH');

John Received on Tue Jan 20 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US