サイケヘ・゛・ヒ・螂「・｡ァ・･ユ・。・･ ケ
・゛・ヒ・螂「・
SELECTハク、ホテ讀ヒハクサｲ 荀盪 爨ウ、ネ、ヌナミマソコム、゜、ホ・ェ・ヨ・ク・ァ・ッ・ネ、 ﾀョ。ヲコｽ ケ、･ケ・ッ・･ラ・ネ、 ﾀョ、ヌ、ュ、゛、ケ
SELECTハク、ホセ ､ リト熙ケ、､ウ、ネ、ヌノャヘラ、ハ・ェ・ヨ・ク・ァ・ッ・ネ、 ﾀョ、ケ、･ケ・ッ・･ラ・ネ、 ﾀョ、ヌ、ュ、゛、ケ
、゛、ソ。「ツセ、ホVIEW、ネマ「キ､オ、サ、､ウ、ネ、ヌ。「ノャヘラ、ハ・ェ・ヨ・ク・ァ・ッ・ネ、 ｽミ、ケ、､ウ、ネ、ャ、ヌ、ュ、゛、ケ
Drop Object
| select 'drop ' || object_type || ' ' || object_name || ';' from user_objects; |
| 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 ; |