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;
⇒ Types of Execution Flow Control Statements in Oracle
⇐ Scalar Data Types Supported in PL/SQL in Oracle
2018-11-17, 1581🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...