Home » SQL & PL/SQL » SQL & PL/SQL » searching
searching [message #392268] Tue, 17 March 2009 04:33 Go to next message
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
Re: searching [message #392272 is a reply to message #392268] Tue, 17 March 2009 04:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for "chr(10)"
Use INSTR (for instance).

Regards
Michel
Previous Topic: Number
Next Topic: DBMS_JOB
Goto Forum:
  


Current Time: Sun Dec 04 22:36:04 CST 2016

Total time taken to generate the page: 0.11230 seconds