OraFAQ Forum: Reports & Discoverer » using LIKE command in oracle reports

Home » Developer & Programmer » Reports & Discoverer » using LIKE command in oracle reports (reports 5i)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

using LIKE command in oracle reports [message #568168]

Wed, 10 October 2012 01:19

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%';

Report message to a moderator

Re: using LIKE command in oracle reports [message #568181 is a reply to message #568168]

Wed, 10 October 2012 02:19

ranamirfan
Messages: 498
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

Report message to a moderator

Re: using LIKE command in oracle reports [message #568186 is a reply to message #568181]

Wed, 10 October 2012 02:38

alimahboob
Messages: 14
Registered: November 2005
Location: jeddah

Junior Member

thanq mr irfan. its working.

Report message to a moderator

Re: using LIKE command in oracle reports [message #568189 is a reply to message #568186]

Wed, 10 October 2012 02:50

ranamirfan
Messages: 498
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Thanks for your feedback.

Report message to a moderator

Previous Topic:	Digits Conversion
Next Topic:	Report 10g parameter form Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 22:29:18 CDT 2013

Total time taken to generate the page: 0.07796 seconds