Metadata(Table,Index,DBLink) sql in Oracle

METADATA(Table,Index and DBLink)

select dbms_metadata.get_ddl('TYPE','OBJECT','OWNER') from dual;

For EX.

select dbms_metadata.get_ddl('DB_LINK','TEST','PUBLIC') from dual;

select dbms_metadata.get_ddl('TABLE','TABLE_TEST','SCOTT') from dual;

select dbms_metadata.get_ddl('INDEX,'INDEX_NAME','SCOTT') from dual;