Search This Blog

Saturday, February 4, 2023

Get DDL of any Object in Oracle

SELECT DBMS_METADATA.get_ddl (<OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL; --Must write everything in capital word


No comments:

Post a Comment

Java to Oracle database Connection Using JDBC

Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...