The below query will display the structure of the objects
For Table:-
Query :- SELECT DBMS_METADATA.GET_DDL ('TABLE','CUSTOMERS',’SCOTT’)
FROM DUAL;
For Index:-
Query:- SELECT DBMS_METADATA.GET_DDL ('INDEX',’PK_CUSTOMERSID',
‘SCOTT’) FROM DUAL;
Description of parameters:-
In the above query, we need to pass total three
parameters
1st Parameter:- To check the identity of the
objects like table or index.
2nd Parameter:- Pass the Name of the object
3rd Parameter:- Name of the database User
Thanks Piyush Pandey for the help in Oracle database query optimization . Please keep me helping, i really appreciate your hard work towards your social activity on internet , you are always trying to help other developers.
ReplyDeleteCongratulations for the contribution in Oracle Forums , you have spent lot's of your valuable time on the different oracle sites for the your help and you have provided help to other developers. your prompt response to the issue/questions asked by the different users is really appreciated by our core support team.