ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
email@example.com. Request a Workshop for
your organization today.
Provides a PL/SQL procedure called CREATE_EXTDDL_FOR_HIVE(), that creates an Oracle external table for a given hive table. Big Data SQL needs to be correctly set up for DBMS_HADOOP to work.
Given a hive table name, creates a text of DDL that can be executed to create an external table corresponding to the hive table
cluster_id IN VARCHAR2,
db_name IN VARCHAR2,
hive_table_name IN VARCHAR2,
hive_partition IN BOOLEAN,
table_name IN VARCHAR2,
perform_ddl IN BOOLEAN,
text_of_ddl OUT CLOB);