Re: Datatype in stored functions

From: Keld Nielsen <keldnielsen_at_tiscali.you.know.dk>
Date: Wed, 20 Aug 2003 04:44:11 +0200
Message-ID: <3f42e05d$0$32528$edfadb0f@dread16.news.tele.dk>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0308191816.b41ca1b_at_posting.google.com...
> "Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message
news:<3f427f6f$1_1_at_news.estpak.ee>...
> >
> > I just checked for curiosity and at least in 9.2 it isn't reserved.
(used
> > v$reserved_words view).
>
> there are 660 reserved names in 8.1.7.
> How many do you get in 9i?

Not at all sure about you being serious, but as I couldn't sleep ...

SQL*Plus: Release 9.2.0.3.0 - Production on Ons Aug 20 04:30:18 2003

SQL> SELECT * FROM v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production

SQL> SELECT COUNT(*) FROM v$reserved_words;

  COUNT(*)

---

       809

SQL> SELECT * FROM v$reserved_words WHERE keyword = 'EMPTY';

no rows selected

Regards,
Keld

>
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
Received on Tue Aug 19 2003 - 21:44:11 CDT