TAILIEUCHUNG - Oracle Built−in Packages- P145

Oracle Built−in Packages- P145: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk missingresolution -23343 Reference conflict resolution method does not exist missingschema -23306 Schema does not exist missingvalue -23337 Missing value used internally nonmasterdef -23312 Site is not a master definition site nonsnapshot -23314 Site is not a snapshot site paramtype -23325 Invalid parameter type used internally referenced -23332 Attempt to drop column group used for conflict resolution statnotreg -23345 Conflict resolution statistics not registered used internally typefailure -23319 Attempt to replicate nonsupported datatype DBMS-REPCAT Nonprogram Elements In addition to programs and exceptions the DBMS_REPCAT package defines the following constant used for conflict resolution VARCHAR2S PL SQL table of VARCHAR2 60 indexed by BINARY INTEGER. Data Dictionary Views Oracle provides a number of data dictionary views that are useful for analyzing the status and volume of conflicts as listed in Table . Table Data Dictionary Views Associated with Conflict Resolution View Name Description DBA_REPCOLUMN_GROUP Contains information about column groups. DBA_REPCONFLICT Contains information about all conflict resolution methods that have been defined. DBA_REPGROUPED_ COLUMN Contains information about all columns that are members of column groups. DBA_REPPARAMETER_COLUMN Contains information about columns that are designated to resolve conflicts. These columns have been passed in the list_of_column_names parameter of conflicttype _RESOLUTION. DBA_REPPRIORITY Contains information about every value and priority that has been defined for all priority groups and site priority groups. DBA_REPPRIORITY_GROUP Contains information about all priority groups and site priority groups. DBA_REPRESOLUTION Contains information about the conflict resolution technique that has been defined for all conflict types. DBA_REPRESOL_STATS_CONTROL Contains information about statistics that have been gathered

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.