Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Convert Character Types to Numeric Types
How To Convert Character Types to Numeric Types? - Oracle DBA FAQ - Understanding PL/SQL Language Basics
✍: FYIcenter.com
You can convert character types to numeric types in two ways:
The sample script below shows you how to convert character types to numeric types:
PROCEDURE proc_convert_1 AS start_time CHAR(5); finish_time CHAR(5); elapsed_time NUMBER(5); BEGIN start_time := '12052'; finish_time := '15314'; elapsed_time := TO_NUMBER(finish_time) - TO_NUMBER(start_time); elapsed_time := finish_time - start_time; -- same as above END;
2007-04-30, 5559👍, 0💬
Popular Posts:
How do I use a scriptlet to initialize a newly instantiated bean? A jsp:useBean action may optionall...
Is Session_End event supported in all session modes ? Session_End event occurs only in “Inproc mode”...
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
interview.FYIcenter.com offers a collections of interview questions and answers for software and Web...
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...