From clchan@nie.edu.sg Mon, 27 Aug 2001 20:04:28 -0700 From: "CHAN Chor Ling Catherine (CSC)" Date: Mon, 27 Aug 2001 20:04:28 -0700 Subject: RE: SQL+ SELECT statement need help Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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@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@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).