[jeffreyjane]

hi.. im a newbie here.. please help me how to code this one using pl/sql oracle.. thanks..

 select 'My name is ' || ename, 'and I am a ' || job from emp; 

i have to get the output like this:

My name is BLAKE and i am a MANAGER
My name is CLARK and i am a MANAGER
My name is SCOTT and i am an ANALYST
My name is KING and i am a PRESIDENT
My name is TURNER and i am a SALESMAN
My name is ADAMS and i am a CLERK
My name is JAMES and i am a CLERK
My name is FORD and i am an ANALYST

thanks..

[jeffreyjane]

hi.. so far, this is my code for the output;

 select 'My name is a ' || ename, 'and I am a ' || job from emp
  where JOB <> 'ANALYST'
  or 'My name is a' || ename 'and I am an ' || job
  where JOB = 'ANALYST';

but then i still have errors like this..


or 'My name is a' || ename 'and I am an ' || job
*
ERROR at line 3:
ORA-00920: invalid relational operator

please help me for further changes, so i can execute my codes.. thanks..

by the way, i am using oracle 11g..

good day!

[macosxnerd101]

Moved to Oracle.

[jeffreyjane]

sir, what are the difference of oracle 11g and oracle? thanks..

anyways, i got the..

[baavgai]

'My name is a ' || ename, 'and I am a ' ||

See the comma? That will work for the select, but will give you another column. Try:

'My name is a ' || ename || 'and I am a ' ||

In this:

'My name is a' || ename 'and I am an '

You have nothing joining ename to anything, so it's simply wrong.

You "or" is kind of meaningless. All conditional expressions must resolve to true or false.