The GET_IN_DB_SCHEMA_VERSION function returns the current version of the INUSER schema from the IN_PRODUCT_MOD_HIST table. This function returns the entire schema version number along with the encoding type.
Note: Note If you need to return the base schema version for conditional
logic then use the SCHEMA_BASE parameter returned by the PARSE_SCHEMA_VERSION stored procedure instead.
| Parameter | Description | |
|---|---|---|
| SCHEMA_VERSION | Type: | RETURN |
| Datatype | VARCHAR2(40) | |
| Default Value: | None | |
| Description | Returns the full schema version. | |
Examples
SELECT IN_DB_UTIL.GET_IN_DB_SCHEMA_VERSION FROM DUAL; GET_IN_DB_SCHEMA_VERSION ------------------------ 7.1.3.3
SET SERVEROUTPUT ON; DECLARE V_INOW_VERSION VARCHAR2(16); BEGIN V_INOW_VERSION := IN_DB_UTIL.GET_IN_DB_SCHEMA_VERSION; DBMS_OUTPUT.PUT_LINE(CHR(10)||V_INOW_VERSION); END; / 7.1.3.3