用plsql提取批量提取檢視view定義的動態指令碼

select 'select dbms_metadata.get_ddl('||''''||'VIEW'||''''||','||''''||view_name||''''||')||';' from dual;' from user_views;

select dbms_metadata.get_ddl('VIEW','V_DOWNLOAD_MESSAGE')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_RESOURCE_ADVANCED_SEARCH')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_GRADE_INFO')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_QUESTION_MY_QUESTION')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_PLAZA_INDEX_ALLQUESTION')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_QUESTION_MY_COLLECTIONS')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_STAR_QUESTIONANDANSWER')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_STAR_QUESTION_INDEX')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_STAR_TEACHER_INDEX')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_QUESTION_MY_ANSWERS')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_GET_QUESTION_TO_ANSWER')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_HW_GET_SUBJECTINFO')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_QUESTION_ANSWERS')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_HW_GET_CLASS')||';' from dual;
select dbms_metadata.get_ddl('VIEW','V_QA_GET_QUESTION')||';' from dual;
select dbms_metadata.get_ddl('VIEW','R_MYUPLOAD')||';' from dual;
select dbms_metadata.get_ddl('VIEW','R_MYFAVORITY')||';' from dual;
select dbms_metadata.get_ddl('VIEW','R_MYDOWNLOAD')||';' from dual;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-669377/，如需轉載，請註明出處，否則將追究法律責任。