Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding the new line character in a field

PandeeshMay 12 2011 — edited May 18 2011
Hi,

i am cretaing the table as given below:

CREATE TABLE ITEM_TEST(item_desc varchar2(48));

table created

I am inserting the below records

1)insert into ITEM_TEST values('AWT_SWING');

2)insert into ITEM_TEST values('AWT-
SWING');

3)insert into ITEM_TEST values('AWT-S
SWING');

Now there are 3 records in the ITEM_TEST table.

i want to fetch only the records which are in multi line.(i.e 2 and 3 rd records in tis case)

So how should my WHERE clause look like?

i have tried using CHR(10) with LIKE clause.
But i am not getting the desired output,.

Any help would be highly appreciated.

thanks
This post has been answered by Hoek on May 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2011
Added on May 12 2011
32 comments
31,437 views