yangtingkun Article Index ----PL/SQL aspects of personal BLOG

Posted on 2010-01-15 filed under: Oracle (RSS) 16 views

PL / SQL areas:
Of the string "sum" - in the Oracle custom aggregate functions example: If you use Oracle functionality to achieve a custom user-defined aggregate functions, this example gives an example of realization of the combined string.
DBMS_REPAIR Use: This paper describes the role of DBMS_REPAIR package and give the package to modify the use of DBMS_REPAIR example.
DBMS_REPAIR use (2): In the last article, based on the use of its preparation of the recovery process, from the index has been saved to recover the data.
Oracle's online redefinition table function: Introduction 9i introduction of online re-defined functions.
Oracle's online redefinition table function (2): an online redefinition of the use cases.
How to locate the required documents DUMP number and BLOCK ID: DUMP data file need to specify the DATAFILE and BLOCK, this article describes how the most convenient access to the above information through the ROWID.
Oracle9i use of flashback operations: Introduction Oracle9i flashback feature.
NUMBER type into a binary: Oracle failed to translate into binary numerical approach, where to achieve the conversion function.
Gloomy 911 error: a Chinese character to such problems.
The custom analysis function: the custom analysis function is an example.
To grant permission to the user should try to avoid ANY system privilege: This paper gives a permission to obtain administrator privileges by ANY example.
Deterministic Functions: Introduction ORACLE function DETERMINISTIC characteristics.
Deterministic function (2): 10g of DETEMINISTIC the difference.
Calculate monthly mortgage payments of small processes (1): wrote a simple calculation on the repayment of the applet.
Calculate monthly mortgage payments of small process (2): For the first article of the function of the package, overloading, an increase of new features.
Calculate monthly mortgage payments of small processes (3): an increase of prepayment function.
Trigger replication by the type of table that contains LONG: LONG given through the trigger will be copied to a BLOB type data type of the table, while this example also demonstrates how to avoid the change of the table.
BULK COLLECT small problems: BULK COLLECT may have an empty record problems.
Date of transfer function parameters case the format of the rules: The Oracle date format conversion function parameters case problems.
FORALL statement is a small problem: describe the restrictions on a FORALL statement.
FOR ALL Syntax Analysis: A comparative FOR ALL statements and FOR LOOP efficiency.
PLSQL calculating prime numbers: Using PLSQL calculating prime numbers, examples show the major impact of the efficiency of the algorithm.
To determine whether the number of types: the two to determine whether a string contains a valid numerical method.
To determine whether the number of type (2): adds to the science and technology law judgments.
10g, MAX, MIN of the bug: in 10g using MAX or MIN of the CHAR type of operation, and the resulting output to the variable results may cause long problem.
The importance of coding standards - a PLSQL procedure diagnosis: An example shows the importance of coding standards.
RETURNING statement a few minor questions: introduced PLSQL the RETURNING statement.
The process of implementation of the Baocuo ORA-4068: This error on the 4068 production of in-depth analysis.
Custom aggregate function to access the remote object (1): description of the problem.
Custom aggregate function to access the remote object (2): testing a variety of angles, all-round display problems.
Custom aggregate function to access the remote object (3): solutions and summarized.
One dealing with a small function of the operating system file attributes: Using Oracle batch processing system file attributes to be a script.
The calculation of personal income tax function: a calculation of personal income tax small function.
A simple example of UTL_FILE package: This paper describes the use of UTL_FILE package, given a query result will be written CSV file example.
Arbitrary table data as a CSV file export process: the above article of the upgrade, to support any query results generated CSV file.
Will be converted into numerical IP addresses: IP addresses will be converted to a numeric function.
New objects may also lead to failure of a stored procedure: description of new objects stored procedure result in failure situation.
Add an object to the caller permission to stored procedure effects: a new target may lead to the implementation of the caller permission to stored procedure error.
The process of the caller access permissions problem: the caller describes the characteristics of stored procedure permissions.
The caller permission to access stored procedure features: use dynamic SQL to avoid problems with permissions.
Namespace small problem: naming space problems.
VIEWS is a keyword do: VIEWS is actually the PLSQL keywords.
TO_LOB function: TO_LOB function specificity.
More than NUMBER values that the scope of the biggest problems (1): By a small value of the function leads to the maximum extent of the problem of more than NUMBER.
More than NUMBER values, said the biggest range of issues (2): given an external C stored procedure solution.
More than NUMBER values that the scope of the biggest problems (3): given an external JAVA stored procedure solution.
More than NUMBER values, said the biggest range of issues (4): Using Oracle stored procedure by custom additive approach to solve the problem.
More than NUMBER values that the scope of the biggest problems (5): the use of Oracle objects, using a different algorithm.
ORA-28595 error: Configuration of external C procedure encountered an error.
ORA-19206 error: error description and solution.
DBMS_METADATA package to obtain permission to use the information: Using DBMS_METADATA package to obtain permission information.
An INSTEAD OF TRIGGER example: one small example of INSTEAD OF triggers.
Oracle9i of the 1467 error: Custom aggregate function ORA-1467 error occurs.
ORA-600 (923) Error: call DBMS_UTILITY package GET_PARAMETER_VALUE process occurs when the ORA-600 errors.
Trigger to obtain SQL statement: get the triggering statement in the trigger function.
In the remote and local stored procedure, passing an array of rooms: Remote stored procedures and local stored procedure to pass between the array of methods.
Strange ORA-1422 error: Login Trigger Query V $ SESSION cause problems.
Withdrawal transaction Baocuo ORA-55505: to build the table of time and was revoked Service problems caused by too short interval.
Revocation, the designated lead XID error ORA-600 (4000) Error: specified the wrong XID cause problems.
ORA-600 (ktftb_backout_xids_3) Error: the specified number of errors caused by the withdrawal of services issues.
Withdrawal transaction there are a number Baocuo ORA-600 error: it removes the transaction testing process encountered several flaws.
Oracle11 new features - PLSQL function of the cache results (1): 11g New features PLSQL function of caching the results of functions.
Oracle11 new features - PLSQL function of the cache results (2): 11g New features PLSQL function of the cache results and DETERMINISTIC function of the difference.
Oracle11 new features - PLSQL function of the cache results (3): 11g New features PLSQL function of the cache the results of application examples.
Oracle11 new features - PLSQL new features (1): PLSQL function calls and CONTINUE statement in the specified parameters.
Oracle11 new features - PLSQL new features (2): PLSQL's SEQUENCE improvements.
Oracle11 new features - PLSQL new features (3): PLSQL's SIMPLE_INTEGER data types.
Oracle11 new features - PLSQL new features (4): PLSQL the inlining optimization.
Oracle11 new features - PLSQL new features (5): PLSQL trigger additional control over the order of function of the trigger.
Oracle11 new features - PLSQL new features (6): PLSQL new compound triggers.
Oracle11 new features - PLSQL New Features (7): PLSQL dynamic SQL enhancements.
Oracle11 new features - to withdraw services (1): a brief introduction to withdraw services usage.
Oracle11 new features - to withdraw services (2): Introduction to withdraw cascade affairs.
Oracle11 new features - to withdraw services (3): revocation of affairs and the foreign key constraint relationship.
Oracle11 new features - on-line operation enhancements (3): Oracle object dependencies to determine enhanced.
Oracle11 new features - on-line operation enhancements (6): On-line re-defined function on the support of materialized view log.
10g-line re-definition of the new features - to copy the table related objects: Oracle provides a new process COPY_TABLE_DEPENDENTS, greatly simplifying the online re-defined steps.
IN the list is too long to use TYPE to solve the problem: Using TYPE way to solve the problem IN the process of scheduling.
A complex problem solving process (4): try to use PL / SQL implementation.
A complex problem solving process (5): still use PL / SQL implementation of the recursive algorithm is used here.
An interesting error ORA-1002: loop to continue to operate after the rollback would cause this problem.
Construct an array of small discussion Oracle: a brief summary about the PL / SQL using two-dimensional array.
Interestingly, the trigger events: the view in the query triggers encountered an interesting problem.
How many records in the table were constructed to achieve the result set (2): Using Oracle's TYPE to achieve the result set structure.
Do not use the date function to achieve ADD_MONTHS function features: The PL / SQL to achieve Oracle's ADD_MONTHS function.
Do not use the date function to achieve ADD_MONTHS function function (2): on the basis of the original made a little change.
BEFORE triggers revised data error: the use of BEFORE triggers records or to amend the import process long data types appear in the error, the results did not succeed, here look at this issue.
Led to the failure to obtain import data: from the exported dmp file to obtain the error records.
Led to the failure to obtain import data (2): revise our approach continues to identify unusual data.
Led to the failure to obtain import data (3): finally get a record that led to the error.
Access to the first letter of Pinyin: This paper gives an access to the first letter of Chinese phonetic examples and brief description of ideas.
Oracle to achieve even the ride: How to implement even by Oracle.
10g New Features CONNECT_BY_ISCYCLE tree query implementations of 9i (a): Describe the problem-solving ideas.
10g new features tree query CONNECT_BY_ISCYCLE implementations of 9i (2): Initial implementation CONNECT BY NOCYCLE function.
10g new features tree query CONNECT_BY_ISCYCLE implementations of 9i (3): Initial implementation CONNECT_BY_ISCYCLE function.
10g new features tree query CONNECT_BY_ISCYCLE implementations of 9i (4): CONNECT_BY_ISCYCLE function finally realized.
PIPE function example: PIPE function is to solve the problem using an example.
Talk on Self-Government Services (1): a brief description of what autonomous transaction can use the location.
Talk on Self-Government Services (2): describe the characteristics of self-government affairs matters.
Talk on Self-Government Services (3): describe the relationship between self-government affairs and conversation.
Talk on Self-Government Services (4): description of the main transaction, autonomous transactions in the transaction and session-level relations.
Talk on Self-Government Services (5): description of the main transaction, autonomous transactions and the relationship between the temporary table.
Talk on Self-Government Services (6): To compare the self-government affairs and general affairs of the price difference.
Temporary table ORA-14550 error: Test-Self-Governing Affairs, to visit a temporary table when the error occurred, a simple summary.
Oracle to achieve pi rate (1): In Oracle to implement Oracle pi calculations.
Oracle to achieve pi rate (2): given a real algorithm.
Oracle to achieve pi rate (3): the code to move to JAVA stored procedure.
INTO does not contain the dynamic SQL will not increase the sequence of values: INTO does not contain the dynamic SQL will not increase the sequence of values.
JAVA stored procedure ORA-24345 error occurs: to write a simple JAVA stored procedure to deal with a mathematical precision of a larger problem, the results encountered ORA-24345 error.
The use of the string to achieve high-precision numerical computation (1): describe the sum of two strings.
The use of the string to achieve high-precision numerical calculation, (b): description of two strings multiplied.
The use of the string to achieve high-precision numerical calculation, (iii): description of two, said a string of integers subtraction.
The use of the string to achieve high-precision numerical calculation, (d): given a complete string subtraction solution.
The use of the string to achieve high-precision numerical calculation, (5): given a string of division-based solution.
Statement-level consistency with the function of the relationship: Query will not see the uncommitted changes in other sessions, or took place after the beginning of the changes in the query.
ORA-7445 error (pdtisq_record_explode): cause of the error indexes and index tables on time.
An ORA-1461 error handling procedure (1): a brief account of the settlement process.
An ORA-1461 error handling process (2): describes a hidden solution to the problem.
Custom analysis functions using an example: Using Oracle custom aggregate functions to solve a problem.
ORA-7445 (kkxmgoag) Error: In the run custom analysis function, the process of the emergence of this error.
ORA-7445 (kkxmgoag) error (2): This paper describes this error in different versions of different manifestations.
Trigger iteration limit: description of the trigger iterative trigger restrictions.
Long string to connect the settlement (1): a custom aggregate functions return value changed to LOB types.
Long string to connect the solution (II): a custom aggregate function's internal variables changed to LOB types.
LOB fields dealing with a PLSQL optimization: This paper describes about the process of optimizing LOB handling.
Oracle10g New DBMS_FILE_TRANSFER package (1): Introduction COPY_FILE process.
Oracle10g New DBMS_FILE_TRANSFER package (2): Introduction GET_FILE and PUT_FILE process.
DBMS_FILE_TRANSFER package using remote backup: Use DBMS_FILE_TRANSFER package to achieve the backup to other server functions.
10g new features to achieve a string to connect: Oracle10g provides the connection string feature, use the WMSYS.WM_CONCAT (TNAME) can achieve this function.
Connection Settings interval operator to solve a string of questions: by modifying the custom aggregate function to achieve the set interval break function.
Using PLSQL table space to achieve migration (1): Introduction PULL_SIMPLE_TABLESPACE process.
Using PLSQL table space to achieve migration (2): Introduction PULL_TABLESPACES process.
Using PLSQL table space to achieve migration (3): Introduction CLONE_TABLESPACES process.
Using PLSQL table space to achieve migration (4): Introduction ATTACH_TABLESPACES process.
Using PLSQL table space to achieve migration (5): Introduction DETACH_TABLESPACES process.
The use of triggers on the materialized view refresh to customize: You can create a materialized view by way of a trigger on the refresh operation to customize.
The use of UTL_SMTP email: UTL_SMTP package can send EMAIL.
The system triggers the application of order (1): describe the system-level triggers the trigger sequence.
The system triggers the application of the order (2): to see an exceptional situation.
The system triggers the application of order (3): to find cause of the problem.
The system triggers the application of order (4): By TRACE check the cause of the problem.
The problems caused by the use of DBMS_RANDOM process: Description DBMS_RANDOM call may lead to problems.
Function call occurred before or during the SQL call: To describe the function call is occurred in the SQL to run before, or occurred in the SQL-running.
Run resolve compilation error: majority of cases, the process of implementation can try to omit the compilation step. However, sometimes, direct running and does not work.
Oracle11gr2 rely on to determine the trigger enhancement (1): 11.1 and 11.2 in the comparison depends on the difference between column level.
Oracle11gr2 triggers rely on to determine enhancement (2): The column level trigger dependency problems.
Flip-flops to operate LOB: flip-flops can be handled like any other data types as LOB field, but only limited to SQL statements to the LOB modifications.