How to assign values to the decimal type in Oracle?

In Oracle, the DECIMAL type typically refers to the NUMBER type, and you can assign values to the DECIMAL type in the following way.

1. Assign values directly using numbers.

DECLARE
    decimal_number DECIMAL(10,2);
BEGIN
    decimal_number := 123.45;
END;

1. Assigning values to variables:

DECLARE
    decimal_number DECIMAL(10,2);
    some_variable NUMBER := 678.90;
BEGIN
    decimal_number := some_variable;
END;

1. Assign values using the SELECT statement.

DECLARE
    decimal_number DECIMAL(10,2);
BEGIN
    SELECT 456.78 INTO decimal_number FROM dual;
END;

In Oracle, the DECIMAL type is typically implemented using the NUMBER type, where DECIMAL(precision, scale) specifies the total length of the number and the number of digits to the right of the decimal point.