OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Search String (oracle 10g,win xp)

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

Search String [message #605733]

Tue, 14 January 2014 01:33

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Hello experts,

Please help me out ....

i am going to search the perticular string but 'get_alloc_amt' is not present in the
string so why like operator search the string .....

------------------query-----------------------
select a
from (select 'function_get_budget_alloc_amt(a_entity_codevarchar2,
a_tcodevarchar2,
a_vrnovarchar2,
a_slnonumber,
a_from_datedate,
a_to_datedate,
a_group1_valuevarchar2,
a_group2_valuevarchar2,
a_budget_flagvarchar2)returnnumber' a
from dual)
where a like '%get_alloc_amt%'

Thanks

Report message to a moderator

Re: Search String [message #605734 is a reply to message #605733]

Tue, 14 January 2014 01:48

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

'get_alloc_amt' is not present in the string

That's what YOU think (and yes, you are wrong). Look closer.

Report message to a moderator

Re: Search String [message #605737 is a reply to message #605734]

Tue, 14 January 2014 02:47

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

i got it ...
sory for disturbing u...
Shocked

Report message to a moderator

Previous Topic:	Syntax for similar Pattern between the tables
Next Topic:	ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired while gathering stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 22:45:18 CDT 2024