Oracle

  Book Description Oracle PL/SQL recipesIs yourGoBook for PL/SQL programming solutions. it takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. then it's as simple

Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;A A zero space------------------------------------65 97 4

Oracle Database glossary Structured Query Language (Structured Query Language) --- Structured Query Language VPD (Virtual Private Database) --- virtual private database OAS (Oracle Application Server) --- Oracle application Program server

1. Differences between genuine Oracle products and pirated products Go straight to the topic, which is a lot of research and development attention. For commercial use (that is, you are not at home or playing on your own), strictly speaking, it is

OCI: to install the Oracle client, the portability is slightly poor, and theoretically the performance is better Thin: belongs to type4, which is implemented in pure Java and has good portability. Theoretically, the performance is slightly lower.

-- Basics: select * from area select * From cgfpmxb/* can contain any expression * // * specifies the alias. You can directly write it or use as AA * // * to combine the two fields into one field. use | * // * to enclose a string in single quotes

The ORACLE tutorial is: use and maintain the password file of the Oracle database. Summary:Oracle relational database system has been widely used for its excellent performance. Ensuring database security is an important part of database management.

The following articles mainly introduce several faster methods to diagnose common Oracle problems. The following describes the specific solution of Oracle troubleshooting methods, I hope it will be helpful for your future study. The following is a

Method 1: Use the script that comes with oracle to start and close... 1 1. oracle user modify the/etc/oratab file:... 1 2. oracle users modify the $ ORACLE_HOME/bin/dbstart file:... 1 3. Test and run dbshut and dbstart 1. 3.1. Execute the

The following describes how VC connects to the oracle database and SQL Server for your reference. If you are interested in connecting to the oracle database, take a look. Connect VC to oracle Database _ ConnectionPtr m_pConn; CString m_sConn =

So far, the export/import toolset is still the preferred utility for transferring data across multiple platforms with the minimum labor intensity, although it is often complained that it is too slow. Import only reads each record from the export

Take a look at the following example: Use a sys account to connect to the database: SQL> conn sys/test as sysdba; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as SYSThe following query shows that only the sys account has the

Replace variables (only used for SQL * Plus or development tools with the same principle as SQL * Plus ): the temporary storage value can be used to create a general script. It can be used to interact with users, therefore, the format of the

Query the information of an oracle table (table, field, constraint, index) by column name + Table name query constraint name SELECT * FROM USER_CONSTRAINTS WHERE table_name = upper ('org _ info ') SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_NAME

Oracle Database SQL single-row functions-date functionsPrefaceThe date functions of the Oracle database are very powerful and relatively large. I will sort it out for future reference.. Convenience for yourself and convenience for others!Common date

Oracle X $ table naming conventions [plain] X $ table naming conventions [plain] [K] ernel Layer [2]-Phase Commit [G] lobal [T] ransaction [E] ntry X $ K2GTE-Current 2 PC tx X $ K2GTE2-Current 2 PC tx [C] ache Layer [B] uffer Management Buffer [H]

Importance of oracle data dictionary and dynamic performance table: because the data dictionary contains user information, we need to query the data dictionary when logging on and have permission information, we also need to query the data

Ora-28056 (Writing audit records to Windows Event Log failed) addressed ORA-28056 systems: windows XP Oracle version SQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release

Parallel recovery of large oracle transactions leads to database performance degradation-high cpu usage-processing ideas parallel recovery of large oracle transactions leads to database performance degradation-high cpu usage processing ideas large

There are three ways to throw an exception 1. Use the PL/SQL Runtime Engine2. Use the RAISE statement3. Call the Stored Procedure RAISE_APPLICATION_ERROR.When an error occurs during database or PL/SQL running, an exception is automatically thrown by