Querying user table/index/View creation statements in Oracle

Don't say much, just go dry.

1, query the current user to create the following table statement

Select Dbms_metadata.get_ddl (' TABLE ', ' ux_future ') from dual;

2, query other users to create the following table statement

Select Dbms_metadata.get_ddl (' TABLE ', ' ux_future ', ' Admin ') from dual;

3, query the current user under the index of the creation statement

Select Dbms_metadata.get_ddl (' INDEX ', ' ux_future ') from dual;

4, query other users under the index of the creation statement

Select Dbms_metadata.get_ddl (' INDEX ', ' ux_future ', ' Admin ') from dual;

5, query the current user under the creation of the view statement

Select Dbms_metadata.get_ddl (' VIEW ', ' ux_future ') from dual;

6, query other users to create statements under the view

Select Dbms_metadata.get_ddl (' VIEW ', ' ux_future ', ' Admin ') from dual;

Querying user table/index/View creation statements in Oracle