Collections:
Convert Character Types to Numeric Types in Oracle
How To Convert Character Types to Numeric Types in Oracle?
✍: 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;
2018-11-17, 838👍, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...