Oracle

SQL * Loader is a tool used to import external data from Oracle databases. it is similar to the Load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * Loader We can use

This article will discuss and share with you some common classic queries of oracle SQL. You are welcome to add them. You can also share some classic queries. In this article, if you think there is any better solution to every problem, you are

Link to the comprehensive exercise for creating, updating, and querying Oracle notes (11): Oracle notes (1) Introduction to Oracle and installation of explain (2) SQLPlus command http://www.bkjia.com/database/201209/154051.html#oraclenotes (3) scott

Use plsql to import Excel Data to Oracle 1 prepare Excel to import data2. Save the Excel file as a text file (tab-separated) (*. txt ))You can also save an Excel file as a Unicode file, to convert the file encoding format of the generated Txt Text

ORA-09925: Unable to create audit trail file error resolution Operating System: RHEL6.1 Oracle: 10.2.0.4 error: In execution: oracle @ linux-37 :~ /Oradata> sqlplus/as sysdba, package the following error SQL * Plus: Release 11.1.0.6.0-Production on

Oracle used a temporary table to return data tables and found many articles about the returned data tables in the stored procedure. We found that there is a big difference between oracle and SQL server. SQL server can directly return data tables in

ORA-01017 invalid username/password; logon denied "password loss solution 1. First confirm whether to enter the wrong user name and password www.2cto.com 2. If the password is indeed lost: View sqlnet. ora for SQLNET. AUTHENTICATION_SERVICES = (NONE)

Query the SQL information of oracle processes that occupy the CPU 1: first, use the TOP command to pass the SPID number pid username thr pri nice size res state time cpu COMMAND3575 oracle 1 12 0 0 K 0 K run 748.6 H 24.98% oracle3571 oracle 1 22 0 0

Understanding the cursor (2) Introduction to the attribute of the cursor and Case Study of Different cursor categories links: Understanding the cursor (1): Overview of the cursor http://www.bkjia.com/database/201212/177395.html PL/SQL provides six

Sqlplus Command Format and set Usage and interpretation in sqlplus [oracle @ oracle02 username] $ sqlplus -- helpSQL * Plus: Release 9.2.0.4.0-Production Usage: SQLPLUS [[] [] [] where :: =-H |-V | [[-L] [-M ] [-R ] [-S] :: = [/] [@ ] |/NOLOG ::=@

The SQL script running FOR 10 Gb IN oracle9i environment is incompatible. There is no problem IN running the SQL script IN oracle10g environment. The following is the SQL code FOR C IN (SELECT * FROM TABLE (pkg_rj_common.f_split (P_IN_IDS _, ',')

ORACLE 11 ORA-00119 startup exception throw error handling today unexpected server restart, resulting in oracle exceptions. Www.2cto.com SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or

Let the show parameter command of Oracle show the hidden parameter Find internal of "show parameter" by session tracingSQL> select * from v $ version; www.2cto.com BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit

Oracle | PL/SQL sets auto-increment of primary keys. Oracle does not set auto-increment of primary keys. You need to set the sequence and trigger to auto-increment of primary keys. Example: create a table menu: [SQL] create table menu (menuId number

Automatically add DML triggers to a specified batch of tables. In order to track operation records of a batch of tables, you need to perform a trigger tracking on the batch of tables (no audit is used because the Audit requires the SYS permission ),

Oracle log file switch (checkpoint incomplete) solution Description: oracle log file switch (checkpoint incomplete), Every 15 min, tpm will drop to almost zero. cpu load is not high, very low. 1 set the parameter: alter system set

Oracle character function lower () upper () length () substr (char, m, n) I. Character function: lower case function: lower (); usage: for example, all the names of a table are in lowercase: select lower (t. ename) from scott. emp t capital function:

Oralce 10g officially certified Operating system version oralce 10g officially certified Operating system version Operating system x86 Red Hat Enterprise Linux AS/ES 3 (Update 4 or later) red Hat Enterprise Linux AS/ES 4 (Update 1 or later) Oracle

Oracle Patch Bundle Update I. Introduction to related knowledge I only know CPU (Critical Patch Update) and PSU (Patch Set Update), but I do not know that there is a Bundle Patch, due to a TNS-12531 BUG, you need to install at least Patch bundle 22

Oracle-RMAN full recovery 1. concepts related to RMAN full recovery 1. mainly two commands are used in RMAN full recovery, one is restore and the other is recover. 2. Data can be restored at three levels: database, tablespace, and data file. 3. In