Oracle

When using sqlplus to connect to the oracle database, there are always ???? The main reason is that the language settings of the server and the client are different. In the Japanese environment, the server side is set to JA16SJIS, and the above

1. What is registration? Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users

AbstractThis article takes Oracle database as an example to introduce a simple and common form data storage processing method for developing WEB applications using JSP technology to reduce the development workload and provide the main program

In the process of diagnosing database system performance, SQL statements with low tracking efficiency are always involved. Oracle Database 10 Gb contains a new utility trcsess, it allows you to selectively extract trace data from a large number of

This document describes how to create and delete users and roles in Oracle. importing and exporting data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp

LieHuo. Net documentSince Oracle does not provide tools for Real-Time Message output, Oracle database developers always have to face the challenge of real-time monitoring of their reserve process execution. They must use dbms_output.put_line to call

The Oracle database cannot be connected, and related errors are prompted.OERR: ORA-12519 TNS: no appropriate service handler foundClient Connection intermittent failure, error ORA-12519Cause: the listener cocould not find any available service

Today in the data export, because the user name password is a special character, so encountered the error code: "EXP-00056: encountered ORACLE error 12154", online search for the reason, the quotation marks must be used for expansion, but the

I. System Environment 1. Notebook: 3 GB memory Hard Disk 500 GB Operating System: window xp sp3 2. Virtual Machine environment: Operating System: Windows server 2003 Enterprise (pack 2) Memory Allocation: 1.5 GB Virtual Memory: 3 ~ 6G (try to be as

1. OriginWhen the oracle database field value is less than 1 decimal point, the char type is used for processing, and the 0 before the decimal point is lost.For example, 0.35 is changed to. 35. 2. Solution: Use the to_char function to format the

In Oracle queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number) of oracle) For exampleSelect name from all data queried by the user. If you

Solution:1. Run as administrator in win7 2. Modify the time zone Files required (the first half may vary depending on the path of your installation ):A: D: \ oracle \ product \ 10.2.0 \ db_1 \ WJLMGQS-PC_WJLMGQS \ sysman \ config \ emd.

The current system time is the week of the year. Copy codeThe Code is as follows:Select to_char (sysdate, 'ww '), to_char (sysdate, 'iw') from dual;Select to_char (sysdate, 'ddd ') from dual;Select TRUNC (SYSDATE, 'mm') from dual; 1)The ww algorithm

When oracle ebs operates a FORM interface or a table in the background database, it is found that the table has been in the "suspended" status. It may be because the table is locked by a user, and other users cannot continue the operation.Copy

In oracle, The utl_file package provides some functions and procedures for operating text files, and learns their basic operations.1. Create a directory and authorize the userCopy codeThe Code is as follows:-- Create directoryCreate or replace

1. query the number of connections to the current process of the database:Copy codeThe Code is as follows:Select count (*) from v $ process; 2. view the number of connections in the current session of the database:Copy codeThe Code is as

1. UPDATE nowait: query a piece of data and enable database transactions for it. If no lock is applied to the current data, the system returns the correct result and locks the current data. If the queried data is already in the transaction, the

Fault description: the problem of insufficient temporary tablespace has already been reported three times, and the customer is also bored. The first two were colleagues who added 5G data files. Currently, they have reached 40 GB, the occupied

At this time, if duplicate data exists in the temporary table, whether the primary key field businessid is repeated or the whole row is duplicated, an error in violation of the unique primary key constraint will be reported. Method: group by XX

1. left outer join: LEFT OUTER JOIN SELECT e. last_name, e. department_id, d. department_nameFROM employees eLeft outer join orders ments dON (e. department_id = d. department_id );EquivalentSELECT e. last_name, e. department_id, d.