OraFAQ Forum: SQL & PL/SQL » storage for number and character fields

Home » SQL & PL/SQL » SQL & PL/SQL » storage for number and character fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

storage for number and character fields [message #21823]

Tue, 03 September 2002 07:24

Joan
Messages: 36
Registered: February 2002

Member

if I have fields eg number(4) what is the different in storage if i change to varchar2 .. the value to be entered will numbers between 4-7

Report message to a moderator

Re: storage for number and character fields [message #21826 is a reply to message #21823]

Tue, 03 September 2002 07:49

Mark
Messages: 284
Registered: July 1998

Senior Member

Someone else may wish to correct this - but I'm guessing that if you use VARCHAR2 then it is possible to enter text, but you only want to enter numeric values. Also, I'm not sure if you can perform calculations on numbers if they are not stored in a NUMBER field. Some simple test at your end should verify this.

Report message to a moderator

Previous Topic:	Partitions....
Next Topic:	PL/SQL automatic procedure calls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:46:15 CDT 2024