サイケヘ・゛・ヒ・螂「・。ァ・・ユ・。・・ ケ
・゛・ヒ・螂「・
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 ; |