Re: Need help on Dynamic PL/SQL

From: Steven Jelfs <S.Jelfs_at_btinternet.com>
Date: 1998/01/16
Message-ID: <69ogka$mtd$1@uranium.btinternet.com>#1/1

FIREWALL wrote in message <34bf99bb.2766872_at_news.pacific.net.sg>...
>I need to concentenate a string with the following syntax. Please
>advice. The output I desire is created dynamicall via PL/SQL
>
>This is the output I desire,
>
>SELECT * FROM STUDENT_TABLE WHERE NAME = 'RAMESH'
>
>My sring will be assigned.
>
>sel_store := 'SELECT * FROM STUDENT_TABLE WHERE ' || NAME
>|| '=' || 'RAMESH'
>
>
>I need RAMESH to be represented as 'RAMESH'
>

sel_store := 'SELECT * FROM STUDENT_TABLE WHERE '|| NAME||'='|| '''RAMESH'''; should do the trick

Sj Received on Fri Jan 16 1998 - 00:00:00 CST