RE: SQL+ SELECT statement need help

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Mon, 27 Aug 2001 20:04:28 -0700
Message-ID: <F001.003790E5.20010827201031@fatcity.com>

Try CHR(10)

.ie. SELECT 'NAME : ' || ename ||CHR(10)||'DEPARTMENT : ' || dept || CHR(10)||'SALARY : ' ||sal FROM emp;

Hope it helps.

Regds,
Chorling

                -----Original Message-----
                From:   Sinardy [mailto:sinardyxing_at_bcsis.com]
                Sent:   Tuesday, August 28, 2001 11:41 AM
                To:     Multiple recipients of list ORACLE-L
                Subject:        SQL+ SELECT statement need help

                Hi all,

                1. I have table emp (ename, dept, sal)
                2. I do
                        SELECT 'NAME : ' || ename || '  DEPARTMENT : ' ||
dept || '   SALARY : ' ||
                sal
                        FROM emp;

                        Result:

                        NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY :
2000
                        NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000


                3. I can I break them to be like

                        Name : JAMES
                        DEPARTMENT : LAB ENGINNER
                        SALARY : 2000

                        NAME : BOB
                        DEPTARTMENT : DRIVER
                        SALARY : 2000

                        something like a new line ('/n') in C++

                        SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' ||
dept || '/n   SALARY :
                ' || sal
                        FROM emp;


                Thank you

                Sinardy

                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: Sinardy
                  INET: sinardyxing_at_bcsis.com

                Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                San Diego, California        -- Public Internet access /
Mailing Lists
        
--------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail
message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).
You may
                also send the HELP command for other information (like

subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 27 2001 - 22:04:28 CDT