Hi all, Thank you Kirti, Irfan, Shah -----Original Message----- Sent: Tuesday, 28 August 2001 10:47 AM To: [EMAIL PROTECTED]; LazyDBA.com Discussion Sinardy, Here is one way to do it (using CHR(10) for new line) : SELECT 'NAME : ' || ename || CHR(10) || ' DEPARTMENT : ' || dept || CHR(10) || ' SALARY : ' || sal FROM emp; HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -----Original Message----- > From: Sinardy [SMTP:[EMAIL PROTECTED]] > Sent: Monday, August 27, 2001 9:24 PM > To: LazyDBA.com Discussion > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).