Oracle Common コマンド (command)

Set head off
Set Lin 150
Set pages 0
Set Long 10000
Select TEXT from User_source t where T.name = upper (' get_car_status_new ') Order by TYPE, line;

=======================

Set pages 0
Set Longchunksize 3000
Set Long 2000000000
Set head off
Set Linesize 1000
Set Feedback off
Set trim on
Set trims on
Set echo off
Set term off
Set Autotrace on
Set Serveroutput on

パッケージのソースを says
Select DBMS_METADATA.GET_DDL (' Package ', ' bsa_pkg ', ' CLARO ') from dual;

トリガーのソースを says
Select Dbms_metadata.get_ddl (' TRIGGER ', ' update_status_bros_web ', ' CLARO ') from dual;

タイプのソースを says
Select Dbms_metadata.get_ddl (' TYPE ', ' Bsa_price_typ ', ' CLARO ') from dual;

Shimonoseki Number のソースを indicates
Select Dbms_metadata.get_ddl (' FUNCTION ', ' get_bike_status ', ' CLARO ') from dual;

レビューのソースを says
Select Dbms_metadata.get_ddl (' VIEW ', ' bsa_checklist_vw ', ' Bpproto ') from dual;

プロシージャーのソースを says
Select Dbms_metadata.get_ddl (' PROCEDURE ', ' bsa_proc_ftp_mgmt ', ' CLARO ') from dual;

シーケンスのソースを says
Select Dbms_metadata.get_ddl (' SEQUENCE ', ' seq_sharestock_id ', ' CLARO ') from dual;

Tong expands designation のソースを said
Select Dbms_metadata.get_ddl (' synonym ', ' bsa_vw_acs_sum_daily ', ' CLARO ') from dual;

Materializedレビューのソースを says
Select Dbms_metadata.get_ddl (' Materialized_view ', ' bsa_biz_tool_est_cnt ', ' CLARO_MV ') from dual;

SELECT object_type from user_objects WHERE object_name= ';

SELECT owner as Uname,object_name from All_objects WHERE object_type= "and OWNER like";

SELECT column_name from All_tab_columns WHERE owner= ' and data_type= ' and table_name= ';

Select query from all_mviews where mview_name = Upper (' Bsa_biz_tool_master ');

SELECT table_name | | ' | ' | | COMMENTS from User_tab_comments;

Select A.constraint_name| | ', ' | | A.column_name from User_cons_columns A, user_constraints b where a.constraint_name = B.constraint_name and b.constraint_t ype = ' P ' and a.table_name = ' table ';

Oracle Common コマンド (command)