schema get_ddl

select dbms_metadata.get_ddl('INDEX','INDEX_CC_TAXID','USERID') from dual;
select dbms_metadata.get_ddl('TABLE','COLL_CONTACT','USERID') from dual;

select sys_context( 'userenv', 'current_schema' ) from dual;