oracleerp培訓(xùn)教程-預(yù)覽頁
【正文】 A_CUSTOMERS_INTERFACE_ALLRA_CUSTOMER_PROFILES_INT_ALLRA_CUSTOMER_BANKS_INT_ALLOpen interface tableAR Receipts AR_RECEIPT_API_PUB ERT_MISC_RECEIPTAPI packagesGL Journals GL_INTERFACE Open interface tableSun_nan2023Sun_nan2023Oracle 數(shù)據(jù)字典全部數(shù)據(jù)字典在如下三個(gè)組 DBA_OBJECTS DBA_TABLES DBA_VIEWS ALL_OBJECTS ALL_TABLES ALL_VIEWS USER_OBJECTS USER_TABLES USER_VIEWS系統(tǒng)登錄用戶 由系統(tǒng)來定義、分配和控制數(shù)據(jù)庫用戶只用 APPSSun_nan2023Oracle 系統(tǒng)命名的標(biāo)準(zhǔn)規(guī)則Type Rules ExampleTable English Plural, start with module nameAP_INVOICESView table name_V AP_INVOICES_VUnique Index table name_U n AP_INVOICES_U1NonUnique Indextable name_Nn AP_INVOICES_N1Sequence generatortable name_S AP_INVOICES_STrigger table_name_eventAR_CUSTOMER_PROFILES_BRUSun_nan2023Oracle 系統(tǒng) － 數(shù)據(jù)庫觸發(fā)器CREATE OR REPLACE TRIGGER ar_customer_profiles_bru/* $Header: 96/10/29 15:04:58 porting ship $ */BEFORE UPDATE ON AR.AR_CUSTOMER_PROFILESFOR EACH ROWDECLARE CreditHold varchar2(1) := null。N39。 END IF。 END IF。 END IF。Y39。Sun_nan2023Oracle Application – Stored ProcedureClient ServerOracleS1S2S3S4S1S2S3S4OracleAbc(S1, S2, S3, S4)AbcSun_nan2023Q ASun_nan2023演講完畢，謝謝觀
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1