| Urgent help regd record group [message #83768] |
Tue, 09 December 2003 21:07  |
Taran
Messages: 21
Registered: December 2001
|
Junior Member |
|
|
Hi ,My problem is that I am retrieving values from record group in forms when button pressed trigger .Values are like DG or EX etc
I want to make a select statement by these values as select * from table_name where column_name in(retrieved values from record group like DG,EX etc)
I even concatenate string with retrieved values by concatenating single quotes and comma in between
string looks like
'DG','EX'
when I use this string in sql statement IN operator it retrieves zero rows but retrieves 300 rows if I write directly 'DG','EX' in the IN operator.Kindly help or suggest some other way.
See below code too and help soon
Thanks
declare
final varchar2(100) := ''''||'DG'||''''||','||''''||'EX'||'''');
tmp number;
begin
dbms_output.put_line(final); /*it shows 'DG','EX' */
Select count(*) into tmp
from item_mst
where
itm_type_cd in (final) ;
dbms_output.put_line(tmp); /* it shows 0 */
end;
/
|
|
|
|
|
|
| Re: See reply in PLSQL forum. [message #83774 is a reply to message #83770] |
Wed, 10 December 2003 17:55  |
Taran
Messages: 21
Registered: December 2001
|
Junior Member |
|
|
Sorry dear for posting in multiple forums...I got my solution from pl sql forum ..Thanks..I will take care not to post in multiple forums...I posted so I will get immediate reply from anywhere...
Thanks...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
