RE: SQL+ SELECT statement need help solve

Hi all,

Thank you Kirti, Irfan, Shah

-----Original Message-----
Sent: Tuesday, 28 August 2001 10:47 AM
To: sinardyxing_at_bcsis.com; 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:sinardyxing_at_bcsis.com]
> 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: 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).