Home » Developer & Programmer » Reports & Discoverer » using LIKE command in oracle reports (reports 5i)
using LIKE command in oracle reports [message #568168] Wed, 10 October 2012 01:19 Go to next message
alimahboob
Messages: 14
Registered: November 2005
Location: jeddah
Junior Member

i want to use the like command inside report query. i am giving my query below. please suggest. i am not getting the required resule.

select sum(debit) from doc_Detail where doc_acct no like ':acctno%';
Re: using LIKE command in oracle reports [message #568181 is a reply to message #568168] Wed, 10 October 2012 02:19 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Try it.
Select Sum(Debit) from Doc_Detail
where Doc_Acct_No like :AcctNo||'%';



Regards,
Irfan
Re: using LIKE command in oracle reports [message #568186 is a reply to message #568181] Wed, 10 October 2012 02:38 Go to previous messageGo to next message
alimahboob
Messages: 14
Registered: November 2005
Location: jeddah
Junior Member

thanq mr irfan. its working.
Re: using LIKE command in oracle reports [message #568189 is a reply to message #568186] Wed, 10 October 2012 02:50 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thanks for your feedback.
Previous Topic: Digits Conversion
Next Topic: Report 10g parameter form Error
Goto Forum:
  


Current Time: Thu Mar 28 05:16:09 CDT 2024