OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » searching

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

searching [message #392268]

Tue, 17 March 2009 04:33

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I want to search for the line which is multilined.

string

--------------------------------
sadsad0343j4jk32h42h4kjkkh3432
l3j44j34j3l434l34

where i want to search i cannot seach for whole string.

select *
from tab1
where id like '%sadsad0343j4jk32h42h4kjkkh3432%'

It shows the result then how i can search for the

select *
from tab1
where id like '%sadsad0343j4jk32h42h4kjkkh3432
l3j44j34j3l434l34%'

????????

Thanks

Report message to a moderator

Re: searching [message #392272 is a reply to message #392268]

Tue, 17 March 2009 04:40

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Search for "chr(10)"
Use INSTR (for instance).

Regards
Michel

Report message to a moderator

Previous Topic:	Number
Next Topic:	DBMS_JOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 08:22:02 CDT 2025