OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Line Break

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

Line Break [message #4006]

Fri, 01 November 2002 07:10

Michele
Messages: 77
Registered: December 2000

Member

Hello everyone,
We have an Oracle table here that stores address information in one column. ie
Col_name
Street1 & Street2 & City & State & Zip.

Is there a line break or delimiter that we can store in the Oracle column so that when I produce a Crystal Report the data from the column displays like this:
Street1
Street2
City, State Zip

Many Thanks!!

Report message to a moderator

Re: Line Break [message #4007 is a reply to message #4006]

Fri, 01 November 2002 07:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 GENOME         CHarles

SQL> select deptno||chr(10)||dname||chr(10)||loc from dept;

DEPTNO||CHR(10)||DNAME||CHR(10)||LOC
---------------------------------------------------------------------
10
ACCOUNTING
NEW YORK

20
RESEARCH
DALLAS

30
SALES
CHICAGO

40
OPERATIONS
BOSTON

50
GENOME
CHarles

Report message to a moderator

Previous Topic:	HELP NEEDED!COUNT()??-----URGENT!!!!
Next Topic:	URGENT!!COUNT()???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 14:51:55 CDT 2024