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!

Displaying Characters based on length need help

1567114Mar 16 2017 — edited Mar 24 2017

Hello,

I have table requirement where the field contains data of 100 characters

create table test_dd

(

name varchar2(100));

insert into test_dd

values

('abc Software private limited dca sunrise corporation');

commit;

I need to represent if the name is more than 35 characters it will display in next line.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2017
Added on Mar 16 2017
8 comments
2,041 views