Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newshub.sdsu.edu!west.cox.net!cox.net!newsfeed1.earthlink.net!newsfeed.earthlink.net!nntp2.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!news5.aus1.giganews.com.POSTED!not-for-mail From: "Scott W" Newsgroups: comp.databases.oracle.server References: Subject: Re: New datatypes for 9.2 ? Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-GC-Trace: gv1-23kdbAXqTUgheglt2dPkpEtwy6cozBicuIKCQ== Message-ID: NNTP-Posting-Date: Thu, 06 Jun 2002 17:55:23 CDT Organization: Giganews.Com - Premium News Outsourcing X-Trace: sv3-wIoYU2UUfZX997lLKbMIosFeKtMEOD7Qc4lPgRTooQzeQoUL+jvnOL+Upb8TgTZ4eNNFP9HS/A/VGAl!I3Irhr3uWaJCgLOz6JTGYFWY1NG1Z81zY7u0LUoUwmtvVAduW+8GdJ+GchGi8Z3oNFIDhch+Wvst!XMqHqHXWYNvdLuk= X-Complaints-To: abuse@GigaNews.Com X-DMCA-Notifications: http://www.giganews.com/info/dmca.html X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly Date: Thu, 06 Jun 2002 22:55:23 GMT Xref: easynews comp.databases.oracle.server:149805 X-Received-Date: Thu, 06 Jun 2002 15:53:04 MST (news.easynews.com) Interesting, it shows 64 rows where PREDEFINED = Yes. Now if I could just figure out what that means :). What is the PREDEFINED column for ? I will look into it, but if you could shed more light I would greatly appreciate it. Thanks, Scott "Rene Nyffenegger" wrote in message news:a6d06107.0206050014.6740a51f@posting.google.com... > Not being 100% sure, maybe this helps you go to the right direction: > > select type_name from dba_types where predefined = 'YES'; > > Rene > > > I am trying to determine if there are any new datatypes for 9.2 (over 9.1), > > or if the handling of current datatypes has changed enough that current SQL > > might be broken. I looked through the New Features doc, but that is not > > conclusive. Does anyone know of more detailed info on this ? > > > > Thanks, Scott