Need some guidance

I'm new at working with Oracle, and need some advice.

I need to get fields out of my database, perform some comparisions, re-set the values if they meet certain conditions, then print the fields.

When I use the BEGIN-END, nothing happens - I get no results: BEGIN
SELECT x, y, z FROM table WHERE x = j;
IF y = 5 THEN

        y := 15;
ELSEIF y = 6 THEN

        y := 16;
ELSE y := 20;
ENDIF;
END; If I take off the BEGIN-END, I get the results of the SELECT FROM WHERE statement only. The IF statements are not recognized.

What am I doing wrong? Thanks.

Brenda T.
bthompson_at_sbctri.sbc.com Received on Mon Aug 22 1994 - 21:15:01 CEST