RE: HOW TO CONVERT A LARGE VARCHAR2 TO NUMBER???

1.Copy the decimal part(if present) to a string. 2.Break the left side of decimal part of the string into strs of 10 chars each.

3.For each 10 char str do step 4-7
4.Loop thro each char of 10 char str.
5.Multiply it by its place value (postn from units place).
6.Store the result in the number variable.
7.Accumulate the total result in another number var.
8.Add decimal part to it.

-----Original Message-----
Sent: Thursday, May 16, 2002 11:33 AM
Cc: orafaq

[REPLY and UNSUBSCRIBE instructions are available at the bottom of  this E-mail.]

abc posted the following message on the sql message forum:

Re: HOW TO CONVERT A LARGE VARCHAR2 TO NUMBER???:

i don't know

---

Message URL: http://www.orafaq.com/msgboard/sql/messages/13655.htm

If you are no longer interested in receiving these
messages, please UNSUBSCRIBE from the following URL:
http://www.orafaq.com/msgboard/sql/index1.htm

This e-mail message was automatically generated by
the Oracle FAQ Message Board at http://www.orafaq.org/.
Please do NOT reply to this message, rather go to the
FAQ and reply on the relevant message forum.

Thank you for your support.

Sincerely,
The Oracle FAQ Team






-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: 
  INET: cosltemp-g.manoj_at_orbitech.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).