Home » SQL & PL/SQL » SQL & PL/SQL » data types to store large integer values (Oracle 10g, Win7)
data types to store large integer values [message #563560] Wed, 15 August 2012 00:03 Go to next message
nischalinn
Messages: 117
Registered: May 2012
Location: nepal
Senior Member
what could be effective data type to store large integer values like, 50,000; 10,000,000 etc.??

Thank You.
Re: data types to store large integer values [message #563562 is a reply to message #563560] Wed, 15 August 2012 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 23034
Registered: January 2009
Senior Member
nischalinn wrote on Tue, 14 August 2012 22:03
what could be effective data type to store large integer values like, 50,000; 10,000,000 etc.??

Thank You.

NUMBER
Re: data types to store large integer values [message #563563 is a reply to message #563562] Wed, 15 August 2012 00:13 Go to previous messageGo to next message
nischalinn
Messages: 117
Registered: May 2012
Location: nepal
Senior Member
@BLACKSWAN THANK YOU.

WHAT IS THE DIFFERENCE IN WRITING,

Quote:
ITEM_COUNT NUMBER && ITEM_COUNT NUMBER(10)

[Updated on: Wed, 15 August 2012 00:14]

Report message to a moderator

Re: data types to store large integer values [message #563566 is a reply to message #563563] Wed, 15 August 2012 01:36 Go to previous message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT post in UPPER case.

Database SQL Reference
All datatypes are explained in details in this book, just read it.

Regards
Michel
Previous Topic: updating Nth row and adding a column (merged 2)
Next Topic: QUERY (2 Merged)
Goto Forum:
  


Current Time: Sun Nov 23 16:38:42 CST 2014

Total time taken to generate the page: 0.10583 seconds