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 : 2
uperpages.com
> -Original Message-
> From: Sinardy [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 10:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL+ SELECT statement need help
>
> Hi all,
>
> 1. I have table emp (enam
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
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;
&