Tag Archives: TO_CHAR

Working with large integers using PL/SQL – Part I – Addition


Scope I would like to compute 75! with all the digits what could not be done directly with the Oracle standard data types. Oracle objects In order to achieve this, we will use the Oracle objects. Oracle objects are defined with the CREATE TYPE and the CREATE TYPE BODY statements. Internally, we must define how […]

Working with large integers using PL/SQL – Part II – Multiplication


Constructor First of all, the constructor that has the 3 “int_part” as parameters is not very convenient, because you have to enumerate the 3 “int_part” parts starting by the last digits of the large integer. We will add a new constructor method that will take a VARCHAR2 as a parameter. We will define this constructor […]