OraFAQ Forum: SQL & PL/SQL » Alias cannot be used in function? Thank you in advance.

Home » SQL & PL/SQL » SQL & PL/SQL » Alias cannot be used in function? Thank you in advance.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alias cannot be used in function? Thank you in advance. [message #283]

Sun, 03 February 2002 21:09

Herbert
Messages: 3
Registered: February 2002

Junior Member

Alias cannot be used in function?
example:
1 select ename,concat(job,ename) e,length(ename)
2 from emp
3* where substr(e,1,5)='SALES'
SQL> /
where substr(e,1,5)='SALES'
*
ERROR :
ORA-00904:

How can I modify the states?

Report message to a moderator

Re: Alias cannot be used in function? Thank you in advance. [message #288 is a reply to message #283]

Sun, 03 February 2002 22:51

Abul Fazal
Messages: 39
Registered: February 2002

Member

Select ename, concat( Job,ename), length(ename)
from emp
where substr(concat(job, ename),1,5) = 'SALES'

Report message to a moderator

Previous Topic:	Re: Creating Schema Objects Through Procedures
Next Topic:	Creating Views with parameters..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 05:49:34 CDT 2024