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!

Using Decode - Age Grouping???

323240Jan 23 2004 — edited Jan 23 2004

Hi,

I am wondering if we can use decode/sign functions to achieve the following. If so I would like to know how without using stored procedures.

Depending on a person's age, I need to determine the person's AGE_GROUP. I will be decoding AGE and I need the AGE_GROUP in the below ranges.

Example:

AGE_GROUP (VARCHAR2)
<20
21-40
41-60
61-80
81-100

100

How best can I achieve this? Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2004

Added on Jan 23 2004

5 comments

799 views