Home » RDBMS Server » Server Administration » SUBSTR and number datatype.
SUBSTR and number datatype. [message #61343] Thu, 15 April 2004 11:45 Go to next message
Yass Zoel
Messages: 7
Registered: April 2004
Junior Member
 

Can I use SUBSTR fuction on a "number" datatype column.

I know it work with character strings. I tested on a "number" datatype columns and it worked in a test table.

I will run that update statement that uses SUBSTR in a very critical production environment, and I wanna make sure that nothing will get screwed up. Here is the simple propsed statement I will run:

update tbl set c2=substr(c1,2,2);

c1 and c2 are both "number datatype.

Thanks for your advice...

 

Report message to a moderator

Re: SUBSTR and number datatype. [message #61345 is a reply to message #61343] Thu, 15 April 2004 19:32 Go to previous message
khuram
Messages: 4
Registered: February 2003
Junior Member
hi
substr will work with number data type because oracle support implicit data type conversion !
Khuram.

Report message to a moderator

Previous Topic: Database Link Not working
Next Topic: RE:Checking storage space
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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