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;