skip to content
Ispirer Migration Knowledge Base
User Tools
Log In
Site Tools
Search
Tools
Media Manager
Sitemap
Log In
>
Sitemap
You are here:
Ispirer Migration Knowledge Base
»
Ispirer Migration Knowledge Base
»
Oracle Database - Migration Reference
»
Oracle Database Conversions
»
Conversions from Oracle to HiRDB
»
Oracle Business Logic to HiRDB
»
Oracle Business Logic to HiRDB
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Business Logic to HiRDB
Procedures
SQL%NOTFOUND
CURSOR_NAME%NOTFOUND
SQL%FOUND
CURSOR_NAME%FOUND
SQL%ROWCOUNT
CURSOR_NAME%ROWCOUNT
Variable Declaration
CONSTANT declaration
Comment
CURSOR
%TYPE in Create Table DDL
%TYPE not in Create Table DDL
%ROWTYPE in Create Table DDL
%ROWTYPE not in Create Table DDL
%ROWTYPE for cursor declaration
Boolean
CLOSE cursor
EXECUTE IMMEDIATE
FETCH
OPEN cursor with parameters
OPEN cursor without parameters
Assignment Operator :=
IF
EXIT
EXIT … WHEN
WHILE LOOP
LOOP
FOR LOOP
FOR LOOP … IN REVERSE
FOR LOOP cursor (cursorname is omitted)
FOR LOOP cursor (cursorname is specified)
RETURN (in function)
RETURN（in procedure）
DBMS_OUTPUT.PUT_LINE
RAISE
RAISE exception_name
SQLCODE (in exception handler)
SQLCODE
SQLERRM (in exception handler)
DECLARE EXCEPTION
Exception Handler
EXCEPTION_INIT
SQL%NOTFOUND = TRUE
SQL%FOUND = TRUE
Page Tools
Back to top
