Re: How to write

On Nov 12, 12:00 pm, pal <jayadevpal..._at_gmail.com> wrote:
> Hi guys ,
> I'm new to oracle and i have a doubt,please help me out...
>
> SELECT emp_master.emp_code,
> emp_master.f_name || emp_master.l_name as empname ,
> IS NULL(key_person, 'N') as NotInRoster FROM emp_master ;
>
> while i excecute this query in oracle this is giving an error like
> "Missing expression".
>
> I belive that error is in this line "IS NULL(key_person, 'N') as
> NotInRoster"
>
> can any one tell me how to use IS null in Oracle..
>
> thanx and regards
>
> paleri

is null is not a function in Oracle, it is a predicate only.

You need to replace is null(key_person,'N') by nvl(key_person, 'N')

--
Sybrand Bakker
Sneior Oracle DBA