Using DECODE function......

[Deven Oza]

Hello everyone
Please help me for the following query

I want to solve the query Using the (DECODE) function, I want to write a program segment that will successfully decode all the CIS courses pertaining to Databases into a description.
For example,
(1)CIS 143 to be decoded to Introduction to SQL.,
(2)CIS 090 to be decoded to Introduction to VISUAL BASIC.,
(3)CIS 145 to be decoded to Introduction to ORACLE.,
(4)CIS 147 to be decoded to Introduction to JAVA,
(5)CIS 148 to be decoded to Introduction to ASP.NET.
(6)CIS 200 to be decoded to Introduction to VB.NET.
(7)...... ..... ...... ........ ........
(8)...... ..... ...... ........ ........
...... ..... ...... ........ ........
(18)...... ..... ...... ........ ........

I dont understand how can I solve the query using DECODE function. should I create database table ? if so then which field I have to create. Please help me or give me some idea about this.

Thank you
Deven Oza

[Mondo Tofu]

The DECODE statement is equivalent to a number of IF THEN ELSEs or CASE statements.

Using a DECODE statement to solve the problem means that anytime that there's a change in a course title or description, you're going to be back to the task of mending the program logic.

What would be more resillient is to have your program basically act the same even though the data is changing, so creating a dataase table to assert this relationship is the way to go.

Mondo Tofu