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, 1582🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...