・ロ。シ・爨ヒフ皃
テク「。ヲフネタユ。。サ

Oracle Objectコタョ・ケ・ッ・・ラ・ネ、ホコタョ

サイケヘ・゛・ヒ・螂「・。ァ・・ユ・。・・ケ ・゛・ヒ・螂「・
SELECTハク、ホテ讀ヒハクサイ荀盪爨ウ、ネ、ヌナミマソコム、゜、ホ・ェ・ヨ・ク・ァ・ッ・ネ、タョ。ヲコスケ、・ケ・ッ・・ラ・ネ、タョ、ヌ、ュ、゛、ケ
SELECTハク、ホセ、リト熙ケ、、ウ、ネ、ヌノャヘラ、ハ・ェ・ヨ・ク・ァ・ッ・ネ、タョ、ケ、・ケ・ッ・・ラ・ネ、タョ、ヌ、ュ、゛、ケ
、゛、ソ。「ツセ、ホVIEW、ネマ「キ、オ、サ、、ウ、ネ、ヌ。「ノャヘラ、ハ・ェ・ヨ・ク・ァ・ッ・ネ、スミ、ケ、、ウ、ネ、ャ、ヌ、ュ、゛、ケ


Drop Object
select 'drop ' || object_type || ' ' || object_name || ';' from   user_objects;



SYNONYM
ナミマソコム、゜、ホSYNONYM、マ ALL_SYNONYMS VIEW、ヌウホヌァ、ヌ、ュ、゛、ケ
 
SELECT 'CREATE PUBLIC SYNONYM', ALL_SYNONYMS.SYNONYM_NAME, 'FOR', ALL_SYNONYMS.TABLE_NAME, ';'
  FROM ALL_SYNONYMS
 WHERE OWNER = 'PUBLIC'
   AND TABLE_OWNER != 'SYSTEM'
   AND TABLE_OWNER != 'SYS'
/

セ蠏ュSQLキイフ
CREATE PUBLIC SYNONYM A54_T_A4COMM                   FOR T_A4006                        ;
CREATE PUBLIC SYNONYM A54_V_DAI_FC                   FOR V_A4012                        ;
CREATE PUBLIC SYNONYM A54_V_MODEL_MEI                FOR V_A4013                        ;
CREATE PUBLIC SYNONYM AA5D_T_A4COMM                  FOR T_AD006                        ;
CREATE PUBLIC SYNONYM AA5D_V_DAI_FC                  FOR V_AD012                        ;
CREATE PUBLIC SYNONYM AA5D_V_MODEL_MEI               FOR V_AD013                        ;
CREATE PUBLIC SYNONYM AGB_V_FC_MEI                   FOR V_FC_MEISAI                    ;
CREATE PUBLIC SYNONYM AGW_KMRP_LNK                   FOR KMRP_LNK                       ;


Copyright (C) 1999 System Infinity Corporation. All rights reserved.