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

Report message to a moderator

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

Report message to a moderator

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)

Report message to a moderator

Re: DataTypes [message #223980 is a reply to message #223718] Mon, 12 March 2007 09:01 Go to previous message
joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic: grants and synonyms
Next Topic: Shrinking database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:53:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.