Run the command script to the right.
The product package contains procedures related to product management, such as:
- Writing the category catalog in a hierarchical format to a file.
- Creating products in the database with verification of the catalog name
- Verify product availability in the warehouse based on the number of items requested
Features of this package are:
- Definitions:
- CREATE OR REPLACE PACKAGE ... IS
- CREATE OR REPLACE PACKAGE BODY... IS
- CREATE OR REPLACE PROCEDURE ... IS
- CREATE OR REPLACE FUNCTION ... IS
- Cursor Support:
- CURSOR ... IS SELECT ...
- OPEN, FETCH, CLOSE
- %FOUND, %NOTFOUND, %ISOPEN
- Data types:
- PL/SQL syntax:
- := - assignment
- /* ... */ - block comments
- Built-in packages:
- DBMS_OUPUT
- UTL_FILE
- UTL_DIR
- New SQL syntax:
- ... START WITH ... CONNECT BY PRIOR ...
- LEVEL
- (+) - outer join
- New sequences keywords:
You should see several success statements in the right panel.