Home » SQL & PL/SQL » SQL & PL/SQL » Help with Data Types of Different versions of Oracle
Help with Data Types of Different versions of Oracle [message #398060] Wed, 15 April 2009 01:36 Go to next message
Hemanth123
Messages: 56
Registered: April 2009
Member
Hi,

I have a requirement where I have to create a table,views and write stored procedures,packages at different versions of oracle..i.e.8i,9i,10g & 11g...<<please do not ask why the hell do they need in all the versions...as I was asked to do without questions>>>

Can anyone please provide the datatypes supported at different versions and also list of functions supported at different versions...like NVARCHAR,CLOB,BLOB,CASE..etc..

Any help is appreciated...please

Thanks in advance..
Re: Help with Data Types of Different versions of Oracle [message #398064 is a reply to message #398060] Wed, 15 April 2009 02:04 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Quote:
Can anyone please provide the datatypes supported at different versions and also list of functions supported at different versions...like NVARCHAR,CLOB,BLOB,CASE..etc..

Surprisingly, Oracle provides a large set of documentation books for all database versions. The most recent ones (from 8.1.7 to 11.1) are available online on http://tahiti.oracle.com/ (as already stated in the Useful Sites part of the OraFAQ Forum Guide).

You might be interested in SQL Reference and PL/SQL User's Guide and Reference books. Enjoy.

[Edit: typo]

[Updated on: Wed, 15 April 2009 02:05]

Report message to a moderator

Re: Help with Data Types of Different versions of Oracle [message #398066 is a reply to message #398064] Wed, 15 April 2009 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Furthermore, Google is capable of finding documents which compare datatypes through different Oracle database versions; you might try to combine these two: 7 - 9i and 9i - 11g. Perhaps you'll find them useful as well.
Re: Help with Data Types of Different versions of Oracle [message #398069 is a reply to message #398060] Wed, 15 April 2009 02:22 Go to previous messageGo to next message
Hemanth123
Messages: 56
Registered: April 2009
Member
Thank you all....I have checked in various sites but in some sites they say that CASE function is supported from 8i where as in other sites they it as from 9i..which should I follow....unfortunatelty I am provided with only 10g and not any other versions and was just asked to write them in various versions..

Is there any comparison of functions at various versions as was provided by LITTLEFOOT with different data types??

Please help me...

[Updated on: Wed, 15 April 2009 02:30]

Report message to a moderator

Re: Help with Data Types of Different versions of Oracle [message #398075 is a reply to message #398069] Wed, 15 April 2009 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
.I have checked in various sites but in some sites they say that CASE function is supported from 8i where as in other sites they it as from 9i.

Both are true.
CASE has been supported in SQL since 8i and in PL/SQL since 9i.

Regards
Michel
Re: Help with Data Types of Different versions of Oracle [message #398081 is a reply to message #398075] Wed, 15 April 2009 03:12 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
as I was asked to do without questions


When you write code you will have to know why you have to do things a certain way. At least some broad idea.

There might be different reasons for wanting to have code that runs on all of these versions, and this different reasons might require different ways of doing things.
Re: Help with Data Types of Different versions of Oracle [message #398089 is a reply to message #398075] Wed, 15 April 2009 03:57 Go to previous message
Hemanth123
Messages: 56
Registered: April 2009
Member
Thanks for your responses..

So CASE function can not be used in PL/SQL(Stored Procedures & Packages) of Oracle version 8i...
Is NVARCHAR supported in all the versions and also the LOB's??
I have seen in sites provided by LITTLEFOOT that the above datatypes are supported by Oracle in all the versions..but even I found in some sites that they are supported in 8i..

Please clarify ...
Previous Topic: Help with query change (merged)
Next Topic: Date filter leads to different number of records to be displayed
Goto Forum:
  


Current Time: Tue Dec 06 04:41:11 CST 2016

Total time taken to generate the page: 0.84172 seconds