User Tools

Site Tools


Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

plsql

This is an old revision of the document!


A PCRE internal error occured. This might be caused by a faulty plugin

====== Oracle PL/SQL Compatibility ====== HPL/SQL compatibility with Oracle PL/SQL and SQL. ===== Language Elements ===== Oracle PL/SQL language elementes supported by HPL/SQL: | TRUE and FALSE | Boolean literals | {{:green_tick.gif}} | 0.3.13 | | %%--%% comment | Single line comment | {{:green_tick.gif}} | 0.1 | | /* comment */ | Multi line comment | {{:green_tick.gif}} | 0.1 | | NOT NULL | Variable constraint | Parser only {{:exclamation.png}} | 0.3.13 | | CONSTANT | Constant variable | {{:green_tick.gif}} | 0.3.13 | | := or DEFAULT | Default clause | {{:green_tick.gif}} | 0.1 | | [[type-attribute|%TYPE]] | Data type attribute | {{:green_tick.gif}} | 0.3.13 | | SUBTYPE //subtype// IS //type// | Subtype | {{:red_cross.png}} || ===== Data Types and Declarations ===== Oracle PL/SQL data types supported by HPL/SQL: | BIGINT | 64-bit integer | {{:green_tick.gif}} | 0.3.13 | | BINARY_DOUBLE | Double precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | BINARY_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | BINARY_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | BLOB | Binary long data | {{:red_cross.png}} || | BOOLEAN | True or false | {{:green_tick.gif}} | 0.3.13 | | CHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | CHARACTER(//n//)| Fixed-length string | {{:green_tick.gif}} | 0.1 | | CLOB | Characater long data | {{:red_cross.png}} || | DECIMAL(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | DATE | Date (year, month, day and time) | {{:green_tick.gif}} | 0.1 | | INT | 32-bit integer | {{:green_tick.gif}} | 0.1 | | INTEGER | 32-bit integer | {{:green_tick.gif}} | 0.1 | | LONG | Long string | {{:red_cross.png}} || | LONG RAW | Long binary string | {{:red_cross.png}} || | NATURAL | Nonnegative 32-bit integer | {{:red_cross.png}} || | NATURALN | Nonnegative non-null 32-bit integer | {{:red_cross.png}} || | NCHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | NCLOB | Characater long data | {{:red_cross.png}} || | NVARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | NUMBER(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | PLS_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | POSITIVE | Positive 32-bit integer | {{:red_cross.png}} || | POSITIVEN | Positive non-null 32-bit integer | {{:red_cross.png}} || | RAW | Binary data | {{:red_cross.png}} || | ROWID | Row address | {{:red_cross.png}} || | SIGNTYPE | -1, 0 or 1 | {{:red_cross.png}} || | SIMPLE_DOUBLE | Double precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | SIMPLE_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | SIMPLE_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | SMALLINT | 16-bit integer | {{:green_tick.gif}} | 0.1 | | SYS_REFCURSOR | Cursor variable | {{:green_tick.gif}} | 0.3.11 | | TIMESTAMP | Date and time | {{:green_tick.gif}} | 0.3.7 | | VARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | VARCHAR2(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | UROWID | Row address | {{:red_cross.png}} || | UTL_FILE.FILE_TYPE | File handle | {{:green_tick.gif}} | 0.1 | ===== Operators and Expressions ===== Oracle PL/SQL operators and expressions supported by HPL/SQL: | [[twopipes||| Operaror]] | String concatenation | {{:green_tick.gif}} | 0.1 | ===== Statements ===== Oracle PL/SQL statements supported by HPL/SQL: | [[assign|:=]] | Assignment statement | {{:green_tick.gif}} | 0.1 | | [[null|NULL]] | No operation | {{:green_tick.gif}} | 0.3.13 | | [[select-into|SELECT INTO]] | Assign values from query | {{:green_tick.gif}} | 0.1 |