Oracle PL/SQL Compatibility

HPL/SQL compatibility with Oracle PL/SQL and SQL.

Oracle PL/SQL language elementes supported by HPL/SQL:

TRUE and FALSE	Boolean literals		0.3.13
-- comment	Single line comment		0.1
/* comment */	Multi line comment		0.1
NOT NULL	Variable constraint	Parser only	0.3.13
CONSTANT	Constant variable		0.3.13
:= or DEFAULT	Default clause		0.1
%TYPE	Data type attribute		0.3.13
SUBTYPE subtype IS type	Subtype

Oracle PL/SQL data types supported by HPL/SQL:

BIGINT	64-bit integer		0.3.13
BINARY_DOUBLE	Double precision floating-point number		0.3.13
BINARY_FLOAT	Single precision floating-point number		0.3.13
BINARY_INTGER	32-bit integer		0.3.13
BLOB	Binary long data
BOOLEAN	True or false		0.3.13
CHAR(n)	Fixed-length string		0.1
CHARACTER(n)	Fixed-length string		0.1
CLOB	Characater long data
DECIMAL(p,s)	Fixed-point number		0.1
DATE	Date (year, month, day and time)		0.1
INT	32-bit integer		0.1
INTEGER	32-bit integer		0.1
LONG	Long string
LONG RAW	Long binary string
NATURAL	Nonnegative 32-bit integer
NATURALN	Nonnegative non-null 32-bit integer
NCHAR(n)	Fixed-length string		0.1
NCLOB	Characater long data
NVARCHAR(n)	Variable-length string		0.1
NUMBER(p,s)	Fixed-point number		0.1
PLS_INTGER	32-bit integer		0.3.13
POSITIVE	Positive 32-bit integer
POSITIVEN	Positive non-null 32-bit integer
RAW	Binary data
ROWID	Row address
SIGNTYPE	-1, 0 or 1
SIMPLE_DOUBLE	Double precision floating-point number		0.3.13
SIMPLE_FLOAT	Single precision floating-point number		0.3.13
SIMPLE_INTGER	32-bit integer		0.3.13
SMALLINT	16-bit integer		0.1
SYS_REFCURSOR	Cursor variable		0.3.11
TIMESTAMP	Date and time		0.3.7
VARCHAR(n)	Variable-length string		0.1
VARCHAR2(n)	Variable-length string		0.1
UROWID	Row address
UTL_FILE.FILE_TYPE	File handle		0.1

Oracle PL/SQL operators and expressions supported by HPL/SQL:

|| Operaror

String concatenation

0.1

Oracle PL/SQL statements supported by HPL/SQL:

:=	Assignment statement		0.1
CREATE FUNCTION	Create a user-defined function		0.3.1
CREATE PACKAGE	Create a package		0.3.13
CREATE PROCEDURE	Create a stored procedure		0.3.1
NULL	No operation		0.3.13
SELECT INTO	Assign values from query		0.1