Oracle SQLJUTL
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Utilities supporting SQLJ and JPublisher as well as generic data type conversion functions
AUTHID CURRENT_USER
Dependencies
ALL_ARGUMENTS TYPE$ URITYPE
DBMS_STANDARD    
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/initsqlj.sql
Subprograms
 
BOOL2INT
SQL to PL/SQL conversion from BOOLEAN to INTEGER sqljutl.bool2int(b IN BOOLEAN) RETURN INTEGER;
SQL> DECLARE
  2   inVal1 BOOLEAN := FALSE;
  3   inVal2 BOOLEAN := TRUE;
  4  BEGIN
  5    dbms_output.put_line(sqljutl.bool2int(inVal1));
  6    dbms_output.put_line(sqljutl.bool2int(inVal2));
  7  END;
  8  /
0
1
 
CHAR2IDS
SQL to PL/SQL conversion from CHAR to Interval Day Second sqljutl.char2ids(ch IN CHAR) RETURN DSINTERVAL_UNCONSTRAINED;
TBD
 
CHAR2IYM
SQL to PL/SQL conversion from CHAR to Interval Year Month sqljutl.char2iym(ch IN CHAR) RETURN YMINTERVAL_UNCONSTRAINED;
TBD
 
GET_TYPECODE
Required at translate-time for JPublisher sqljutl.get_typecode(
tid   IN  RAW,
code  OUT NUMBER,
class OUT VARCHAR2,
typ   OUT NUMBER);
TBD
 
HAS_DEFAULT
Required at translate-time for SQLJ sqljutl.has_default(
l_owner IN VARCHAR2,
proc    IN VARCHAR2,
seq     IN NUMBER,
ovr     IN VARCHAR2 DEFAULT NULL,
pkg_nm  IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;
TBD
 
IDS2CHAR
SQL to PL/SQL conversion from Interval Day Second to CHAR sqljutl.ids2char(iv IN DSINTERVAL_UNCONSTRAINED)
RETURN CHAR;
SQL> DECLARE
inVal DSINTERVAL_UNCONSTRAINED := NUMTODSINTERVAL(120, 'DAY');
retVal VARCHAR2(256);
BEGIN
retVal := sqljutl.ids2char(inVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.SQLJUTL", line 84
ORA-06512: at line 5
 
INT2BOOL
SQL to PL/SQL conversion from INTEGER to BOOLEAN sqljutl.int2bool(i IN INTEGER) RETURN BOOLEAN;
BEGIN
  IF sqljutl.int2bool(0) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F
 
IYM2CHAR
SQL to PL/SQL converstion from Interval Year Month to CHAR sqljutl.iym2char(iv IN YMINTERVAL_UNCONSTRAINED) RETURN CHAR;
TBD
 
URI2CHAR
SQL to PL/SQL conversion from URITYPE to VARCHAR2 sqljutl.uri2vchar(uri IN SYS.URITYPE) RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved