Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Associative Arrays - Index Not In Array

PL/SQL Associative Arrays - Index Not In Array

From: absinth <absinth_at_gmail.com>
Date: 9 Jun 2005 01:07:24 -0700
Message-ID: <1118304444.300506.264620@g44g2000cwa.googlegroups.com>


Say I have an associative array 'blah' and it has members 'hello' and 'bye.'

How can I instruct Oracle to return a NULL if I lookup the array and the value isn't found?

E.g.
blah('hello') might map to '1'
But I want blah('Oracle') to return NULL. Received on Thu Jun 09 2005 - 03:07:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US