Oracle

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.

The server is Windows Server 2003. After the Oracle client is installed normally, when data is inserted, all Chinese characters are displayed ?. Exception: Enter select userenv ('language ') from dual in the PLL/SQL statement, and the result is

Differences: 1. Primary keys. Oracle cannot implement auto-increment, and MySQL can implement auto-increment. Oracle new sequence, seq_user_id.nextval 2. Index: MySQL index starts from 0 and Oracle starts from 1. 3. Paging, MySQL: Select *

A table can be partitioned by range, hash, or list. After the table is partitioned, the indexes on the table are different from those on the normal table. oracle classifies the indexes on the partition table into two types: Local and global

Similar to other database systems, Oracle uses "|" to concatenate strings, which is the same as the plus sign "+" in MSSQLServer. For example, execute the following SQL statement: Copy codeThe Code is as follows: SELECT 'employee ID is '|

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

Stored Procedures and stored functions refer to the stored procedures and stored functions that are stored in the database and called by all user programs.. The stored procedure does not return values. Stored functions return values Create a stored

Because subtotal is involved, it needs to be calculated twice. Idea: 1. Insert the query results to the temporary table, 2. Insert the statistical result to the temporary table. 3. query temporary table records and place them in the cursor. 4.

Directory structure: 1 _ crazy Java _ crazy software _ Xiao wenji instructor _ Oracle_Oracle Server InstallationThe video includes: Download, installation, uninstallation, and precautions for Oracle10g servers.2 _ crazy Java _ crazy software _

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 user Copy codeThe Code is as follows: -- create directory Create or replace

Comparison of some simple commands of Oracle and mysql 1) SQL> select to_char (sysdate, 'yyyy-mm-dd') from dual; SQL> select to_char (sysdate, 'hh24-mi-ss') from dual; Mysql> select date_format (now (), '% Y-% m-% D '); Mysql> select time_format

SQL code Copy codeThe Code is as follows: select count (*) from user_objects where object_name = upper (p_table_name ); Select count (*) from user_tables where table_name = upper (p_table_name ); Create or replace procedure p_drop_table_if_exist_v1

1. Oracle downloadNote that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as spaces. Official Address: Bytes.

There are two methods: One is to declare the system cursor, the other is to declare the custom cursor, and then follow the same operation, the parameter type is In out or out (1) Declare the personal system cursor. (recommended) Copy codeThe Code is

I accidentally heard about the snapshot of the oracle database. I was stunned when I first heard it. I didn't know what it was, and I spent some time studying it, the following is my summary on network learning. Snapshots are mainly used in

When writing another stored procedure, the following SQL statement is used: Copy codeThe Code is as follows: select max (RE_DATE) INTO V_RE_DATE FROM T_RECORDING Where id = '000000' It is reasonable to say that the query result based on this

Oracle provides two listener service registration methods: Dynamic and Static. The status of the dynamically registered service in lsnrctl status is ready, and the static service is unknown. In versions earlier than 11g2, the listener is configured

Many data conversion and processing operations may encounter the need to convert 0.007007040000 to 0.70%. We can use the Oracle SQL function to_char to achieve this conversion. This function is used to convert the DATE or NUMBER data type to a

Today I encountered a strange problem:Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifierSQL> conn system @

Oracle has many locks, and the effects of various locks are different. The following describes Oracle row-level locks. Oracle row-level locks only lock the row that the user is accessing. This ensures data security. If the user is modifying a row,