Oracle Built−in Packages- P155: 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 Parameters are summarized in the following table. Name Description sname Name of the schema that owns oname. oname Table whose conflict resolution statistics are to be deleted. start_date Beginning of date range for which statistics are to be deleted. If NULL all entries less than end_date are deleted. end_date End of date range for which statistics are to be deleted. If NULL all entries greater than end_date are deleted. There are no restrictions on calling PURGE_STATISTICS. Exceptions The PURGE_STATISTICS procedure may raise the following exceptions Name Number Description missingobject -23308 Object oname does not exist missingschema -23306 Schema sname does not exist Example This example purges all records collected for the products table between 01-Jan-1998 and 01-Feb-1998 BEGIN sname SPROCKET oname PRODUCTS start_date 01-JAN-1998 end_date 01-FEB-1998 END PREVIOUS HOME HEXT Assigning Resolution B00K INDEX 17. Deferred Transactions Methods with and Remote Procedure DBMS_REPCAT Calls Orode PL SQL Oracle PL SQL Orode Advanced PL SQL Oracle Web Applications Oracle PL SQL Oracle PL SQL H Programming I Programming I Budt-in I Programming PL SQL Developer s I Language I Budt-ins 0 nG Second Edition Guide to OradeAi Features Packages with Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. About Monitoring 761 Oracle Built-in Packages SEARCH PREVIOUS Chapter 17 NEXT 762 17. Deferred Transactions and Remote Procedure Calls Contents About Deferred Transactions and RPCs DBMS_DEFER_SYS Managing Deferred Transactions DBMS_DEFER Building Deferred Calls DBMS_DEFER_QUERY Performing Diagnostics and Maintenance Oracle s advanced replication option relies primarily on deferred transactions and remote procedure calls RPCs . When you commit a transaction against a replicated table for example the replication support
