And some more...
An additional Feature in ORACLE 10g
Enchancement in PL/SQL IEEE Floating-Point Types
1. BINARY_FLOAT
2. BINARY_DOUBLE.
These can be used for computations as the work is passed directly to the operating system.
Literal assignments can be perfomed using the
"f" and
"d" suffixes or conversion functions
TO_BINARY_FLOAT and
TO_BINARY_DOUBLE Code:
DECLARE
vFloat BINARY_FLOAT;
vDouble BINARY_DOUBLE;
BEGIN
vFloat := 1.1f;
vDouble := 1.00001d;
vFloat := TO_BINARY_FLOAT(1.1);
vDouble := TO_BINARY_DOUBLE(1.00001);END;
Improvement in Overloading With Numeric Types Code:
CREATE OR REPLACE PACKAGE SP_NUMBERIC AS
PROCEDURE NUMBERIC(vNumber NUMBER);
PROCEDURE NUMBERIC(vNumber BINARY_FLOAT);
PROCEDURE NUMBERIC(vNumber BINARY_DOUBLE);
END;
/
CREATE OR REPLACE PACKAGE BODY SP_NUMBERIC AS
PROCEDURE NUMBERIC (vNumber NUMBER) AS
BEGIN
DBMS_OUTPUT.put_line('PRINTING NUMBER');
END;
PROCEDURE NUMBERIC(vNumber BINARY_FLOAT) AS
BEGIN
DBMS_OUTPUT.put_line('PRINTING BINARY_FLOAT');
END;
PROCEDURE NUMBERIC(vNumber BINARY_DOUBLE) AS
BEGIN
DBMS_OUTPUT.put_line('PRINTING BINARY_DOUBLE');
END;
END; Code:
Output
SET SERVEROUTPUT ON
BEGIN
SP_NUMBERIC.NUMBERIC(2);
SP_NUMBERIC.NUMBERIC(0.1f);
SP_NUMBERIC.NUMBERIC(0.1d);
END;
PRINTING NUMBER
PRINTING BINARY_FLOAT
PRINTING BINARY_DOUBLE
PL/SQL procedure successfully completed.
Regular Expressions
•
REGEXP_INSTR - Similar to INSTR except it uses a regular expression rather than a literal as the search string.
•
REGEXP_LIKE - Similar to LIKE except it uses a regular expression as the search string.
•
REGEXP_REPLACE - Similar to REPLACE except it uses a regular expression as the search string.
•
REGEXP_SUBSTR - Returns the string matching the regular expression. Not really similar to SUBSTR.
And still many more......