PL/SQL Varray – How to write syntax, example. Unlike indexed arrays, varrays have a maximum size seted on the declaration. The PLSQL Varray are used on one-to-many relationships. The Varray syntax is: TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF...
PL/SQL Nested Table – How to write syntax, example The plsql Nested Table are indexed arrays whose size is not fixed and INDEX BY BINARY_INTEGER clause is missing. The Nested Table syntax is: TYPE type_name IS TABLE OF { { element_type...
PL/SQL Indexed Arrays – How to write syntax, example Indexed arrays have elements with two components: a primary key of type BINARY_INTEGER and a column of type scalar or record. The Indexed Arrays syntax is: TYPE type_name IS TABLE OF {...
PL/SQL Record Data Type – How to write syntax, example The Record data type – defines a group of stored data in the form fields with the data type and name. The Record data type can be used in the declarative...
PL SQL Interview Questions What is the difference between implicit and explicit cursors What are the attributes of implicit and explicit cursors What is the difference between procedure and function What is the difference between rowid and rownum What is an...