Oracle DBMS_GVT
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Utilities providing Oracle SQLGRAPH to JSON conversion functionality
AUTHID CURRENT_USER
Dependencies
ALL_PG_EDGE_RELATIONSHIPS ALL_PG_LABEL_PROPERTIES ODCIRIDLIST
ALL_PG_ELEMENTS ALL_PG_DROP_DEFINITIONS ODCIVARCHAR2LIST
ALL_PG_ELEMENT_LABELS ALL_TAB_COLUMNS ORA_GRAPH_BUILD_JSON
ALL_PG_KEYS DUAL PLITBLM
Documented No
First Available 23ai
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/md/admin/dbms_gvt.sql
{ORACLE_HOME}/md/admin/dbms_gvt_body.plb
Subprograms
 
BUILD_JSON (new 23ai)
Prepares a JSON result from vertexid and edge_id tables. dbms_gvt.build_json(
vertex_table IN sys.odciridlist,
edge_table   IN sys.odciridlist,
counter      IN NUMBER,
graphname    IN VARCHAR2,
graphowner   IN VARCHAR2,
vertex_group IN sys.odcinumberlist,
edge_group   IN sys.odcinumberlist)
RETURN CLOB;
TBD
 
PROPERTIES_LATERAL_STRING (new 23ai)
Prepares vertex subquery string in LATERAL() dbms_gvt.properties_lateral_string(
db_table_name_list   IN sys.odcivarchar2list,
db_object_owner_list IN sys.odcivarchar2list,
graph_viz_table_name IN VARCHAR2,
vertex_idcol_name    IN VARCHAR2,
graphname            IN VARCHAR2,
graphowner           IN VARCHAR2,
element_type         IN VARCHAR2)
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved