Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Yashdeep.

Asked: June 06, 2025 - 4:26 pm UTC

Last updated: June 27, 2025 - 4:41 pm UTC

Version: 25C

Viewed 100+ times

You Asked

There is an requirement to get the DDL for Oracle fusion custom tables is it possible to achieve??

and Chris said...

I don't know about working through Fusion itself. If you have a client that can connect to the database you can get the DDL with dbms_metadata:

select dbms_metadata.get_ddl ( 'TABLE', '<table_name>', user );


If you're using SQLcl/SQL Developer you can use the DDL command:

ddl <table_name>

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

DBMS_METADATA

More on PL/SQL routine DBMS_METADATA here