Home » SQL & PL/SQL » SQL & PL/SQL » Equivalent datatypes in oracle
Equivalent datatypes in oracle [message #241906] Thu, 31 May 2007 00:05 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member

Hi All,

Plz tell me the equivalent datatypes in oracle 8i for all these teradata datatypes:

In Teradata:

1. FLOAT /*Storage In Bytes is 8 &
Floating Point Format (IEEE) 2x10-307 to 2x10+308 */

2. SMALLINT /*Storage In Bytes is 2, Whole number
& Range: -32,768 to 32,767 */

Regards,
Dinesh
Re: Equivalent datatypes in oracle [message #241907 is a reply to message #241906] Thu, 31 May 2007 00:13 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

datatypes in oracle8i

regards
shanth
Re: Equivalent datatypes in oracle [message #241911 is a reply to message #241907] Thu, 31 May 2007 00:30 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
can u suggest me which one is more appropriate datatypes as par my requirment......?
Re: Equivalent datatypes in oracle [message #241916 is a reply to message #241911] Thu, 31 May 2007 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use FLOAT and SMALLINT, Oracle only knows NUMBER and it converts you datatype to its own.

Storage is irrelevant.
Oracle does not recognize IEEE floating point standard.

Regards
Michel
Re: Equivalent datatypes in oracle [message #242014 is a reply to message #241916] Thu, 31 May 2007 06:38 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi,

I am getting confuse about which datatype i should prefer in oracle in the place of FLOAT /*Storage In Bytes is 8 &
Floating Point Format (IEEE) 2x10-307 to 2x10+308 */ in teradata.


Regards,
Dinesh
Re: Equivalent datatypes in oracle [message #242016 is a reply to message #242014] Thu, 31 May 2007 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What part of my answer don't you understand?

Regards
Michel
Re: Equivalent datatypes in oracle [message #242068 is a reply to message #242016] Thu, 31 May 2007 09:26 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
in oracle i have two option:
1. number(p,s)
2. float(p)

so which one is better?
Re: Equivalent datatypes in oracle [message #242073 is a reply to message #242068] Thu, 31 May 2007 09:34 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None.
Both are NUMBER.

Read the documentation and use the one that fit what you want to do FOR EACH COLUMN AND EACH TABLE.
YOU CAN'T JUST REPLACE YOUR FLOAT TO ORACLE FLOAT.
THERE ARE NOT THE SAME.

Port is a more than sed work.

Regards
Michel
Previous Topic: Error in Executing Spool file
Next Topic: to get record in a single row
Goto Forum:
  


Current Time: Sat Dec 03 22:37:49 CST 2016

Total time taken to generate the page: 0.07746 seconds