SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

if else statement

888783Sep 16 2011 — edited Sep 17 2011

hi everyone
i need help

I'm trying to make if else statement in the sqldeveloper query
and my code us like ...

IF CHARGE_PRICE BETWEEN 10000 AND 20000
THEN
charge_apartment(1,600);
ELSIF CHARGE_PRICE BETWEEN 20000 AND 40000
THEN
charge_apartment(1,500);
ELSIF CHARGE_PRICE > 40000
THEN
charge_apartment(1,900);
ELSE
charge_apartment(1,650);
END IF;

now the question is how do i cover that part of code so the sqldeveloper query will know that I'm talking about an Apartments table...?

I dig around the net and so far all the info i got is relevant only for sql*Plus
so...
How can I do this at the query?

thanks in advance

Edited by: 885780 on Sep 16, 2011 4:04 PM

Edited by: 885780 on Sep 16, 2011 4:05 PM

This post has been answered by JustinCave on Sep 17 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2011

Added on Sep 16 2011

7 comments

665 views