Home » RDBMS Server » Server Administration » DataTypes
DataTypes [message #223718] Sat, 10 March 2007 12:20 Go to next message
Morpheus
Messages: 2
Registered: March 2007
Junior Member
Server version oracle 9i.

I dont get it, when i creating Colum as float type, i see it as a number type?

Doesnt oracle 9i as integer type ? Well i am creating colum as int type, i get it as number aswell.

Create table bla ("Hello"Int,"hi"float)

Maby someone can open my eyes with oracle 9i ? yes i have read the faq
Re: DataTypes [message #223727 is a reply to message #223718] Sat, 10 March 2007 14:16 Go to previous messageGo to next message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Oracle documentation is your friend
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i54335

Gints Plivna
http://www.gplivna.eu
Re: DataTypes [message #223752 is a reply to message #223718] Sat, 10 March 2007 23:36 Go to previous messageGo to next message
knam
Messages: 5
Registered: March 2007
Location: Austria
Junior Member
use NUMBER(4,0) or NUMBER(15,6)
Re: DataTypes [message #223980 is a reply to message #223718] Mon, 12 March 2007 09:01 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Very BAD idea to give column names in double quotes, because now every single time you refer to these columns, they will have to be in double quotes. At SQL prompt, in scripts, procedures, functions, code, etc.
Previous Topic: grants and synonyms
Next Topic: Shrinking database
Goto Forum:
  


Current Time: Sat Dec 03 22:38:35 CST 2016

Total time taken to generate the page: 0.06050 seconds