[Solved] RE: Search and compare

augusti 2001 11:43 > To: [EMAIL PROTECTED] > Subject: Re: Search and compare > > > In article > <[EMAIL PROTECTED]>, > Jarkeborn Joacim <[EMAIL PROTECTED]> writes: > > > Hi, > > Oracle has a fuction that compares value and then returns

Search and compare

Hi, Oracle has a fuction that compares value and then returns another value. DECODE( expr, search, result [, search, result] ... [, default] ) E.g. DECODE (deptno, 10, 'ACCOUNTING', 20, 'RESEARCH', 30, 'SALES', 40, 'OPERATION',