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

Create a Form Using Python for Save Data into Excel like a Database

#Download Pyhton from here https://www.python.org/downloads/  #Download Python: #Click the “Download Python 3.x.x” button (the latest versio...