Oracle

When you are working on a project, you may need to merge multiple records into one record, then combine different fields into one field for display, and separate them with commas, solved a lot of problems that are inconvenient to solve. We will sort

New Feature of oracle11g. When the number of data entries is 0, no segment is assigned, so it cannot be exported. Solution: 1. inserting a piece of data (or deleting it again) is a waste of time. Sometimes hundreds of tables are exhausted.2. Before

1. Stop all ORACLE-related services.2. Use OUI (Oracle Universal Installer) to uninstall Oracle software."START"-> "Program"-> "Oracle-OraDb110g_home1 | Oracle installation product | Universal installer.3. Delete the Registry content.　Run the

The customer reported that the workstation software could not connect to the backend occasionally and could be connected for a period of time. It was initially suspected that the number of connections was insufficient. The following are some of the

What is DBMS_JOB?DBMS_JOB is an expert package provided by Oracle database.It is mainly used to run programs in the background and is an excellent tool in the database. It can be used to automatically adjust scheduling routine tasks, such as

  I. Database Name What is the database name? The database name is the ID of a database, just like the ID card number of a person. He uses the DB_NAME parameter to indicate that if multiple full databases are installed on a machine, each database

  An error is reported in the background of the application server today: Java. SQL. SQLException: ORA-01114: IO error when writing blocks to file 201 (block #1015305) ORA-27069: skgfdisp: Try to execute I/O out of file range OSD-04026: The passed

  1 UTL_FILE_DIR Parameter Definition UTL_FILE_DIR is a "static parameter" in Oracle. You can set one or more paths. It is used to specify the path when file I/O operations (utl_file package can be used) are performed in PL/SQL. UTL_FILE_DIR is a

  Oracle defines a BLOB field to save binary data. However, this field cannot store real binary data, and only one pointer can be saved to this field, then place the data in the LOB segment of the Oracle to which the Pointer Points. the LOB segment

  Oracle normal tables cannot be directly converted to partitioned tables by modifying attributes. They must be transformed through reconstruction. The following describes three efficient methods and their respective features.   Method 1: use the

  1. Start-> Settings-> Control Panel-> management tools-> services Stop all Oracle services.   2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer Unmount all Oracle products, but the Universal Installer

  In Oracle, a keyword is NULL, indicating that a value is unknown and uncertain. Since it is unknown, there are several possibilities. Therefore, NULL is not a definite value. Let's take a look at two examples: Example 1: Declare V_b1 boolean: =

  When the Oracle10g Database is installed in win7, the following error message is displayed: oracle 10g is installed in win7, indicating that the program is terminated abnormally and an unknown error occurs.   Solution: Right-click setup, choose

Oracle Control File OperationsThe control file is the link connecting the instance and database. The structure information of the database is recorded. The control file is a binary file. The status of the current database is recorded. There can be

Oracle trigger addition, deletion, and modification instance ---------- trigger for adding, deletion, and modification to a table -------------- Create or replacetrigger zhjkafter insert or update or delete on ITIL_USR_DEPARTMENT_DAGFOR each row

Oracle expdp filtering and parallelism we know there are three ways to call the Data Pump. Here I will never use the command line, but the reasons for giving up the command line in the first script mode are probably as follows: ① restrictions on the

According to the test instance of Jonathan Lewis, The TPCC test instance Statement of Oracle finds that the sort function of the cluster exists completely for the tpcc test and the non-equivalent query statement, they all follow the wrong plan to

The global area of the Oracle program (PGA) is in the shared server mode and dedicated server mode. The following is a diagram of the PGA and UGA in the proprietary mode: Note: The sort area belongs to the pga, SORT_AREA_RETAINED_SIZE is the memory

Flash plus query, flash back version query, flash back transaction query 1. flash back query: the process is to record the current SCN and time, then perform DML operations, submit and use timestamp and SCN to query the data before DML operations

PL/SQL remote database connection exception handling1. An error occurred while parsing the specified connection identifier. Solution: configure the TNS_ADMIN environment variable with the variable value tnsnames. ora path 2 · I/O error 123 solution: