Oracle

Set oracle_home environment variable: Export oracle_home=/oracle/product/11202Set PATH environment variable: Export path= $ORACLE _home/bin: $PATHSwitch to Lsnrctl directory: Cd/oracle/product/11202/bin 1. Launch Oracle under Linux Su-oracleLsnrctl

4 Installation Pre-Oracle Preparation 4.1 Basic Configuration 4.1.1 Shutdown Firewall [root@oracle ~]# service iptables stop Iptables:setting chains to Policy Accept:filter [OK] iptables:flushing firewall rules: [OK] iptables:unloading modules:

Previously, when processing Oracle's exports in code, if there is a return line in the field, processing is always very annoying, the practice is to put the field in the return line to kill, this is too dirt point, oh, but because of Oracle is not

Oracle string interception from backward forward method The format of the Instr:instr method is INSTR (source string, target string, start position, match ordinal) The default lookup order is left to right. When the starting position is a

In Oracle, blocking and blocking are frequently encountered. There are several main ways to find blocking and blocking:I. By looking for V$lock and V$locked_objectThis is the most common and direct method. Sql> Select Sid,block from V$lock where

Analysis function over and open window function One: Analysis function over Oracle provides analytic functions from 8.1.6, which are used to compute some sort of aggregation value based on a group, and the difference between it and the aggregate

First of all, we need to rearrange the relevant concepts, functions in an Oracle database are invoked only by others, stored procedures can be executed separately, and a stored procedure can be invoked, and the package's action package can place any

The using keyword in a join connection in Oracle is relative to the natural join. If you are using the Natraul join, and if more than one field in both tables has the same name and data type, the fields will be joined by Oracle on their own. but

Today, for example, write a simple pl/sql statement that looks at the newly-written statement in the buffer, as follows: Sql> L1 DECLARE2 I number (4): =13 BEGIN4 LOOP5 INSERT into EMP2 (empno) VALUES (i);6 EXIT when 1>2;7 i:=i+1;8 End LOOP;9*

Write stored procedure encountered a problem, the execution of dbms_output.putline (variable name), when the errorOra-20000:oru-10027:buffer Overflow,limit of bytes.$ oerr ora 2000020000, 00000, "%s"*cause:the stored procedure '

In an Oracle database, the more frequent the submission is, the better. On the contrary, bulk submissions can get better performance. This article gives you a simple demonstration of the performance difference between submitting a row to a bulk

This article address: http://blog.csdn.net/kongxx/article/details/7107683 After installing the cx_oracle and Oracle Instant client packages, the following problems occur when importing packages using import Cx_oracle

Java EE Development of various types of resources download list, the history of the most complete IT resources, click to enter. (1) Only DBAs can import files exported by other DBAs Grant DBA to TestUser; If not, in the execution: Alter user

About an old error with Oracle ORA-01555 snapshots First, understand under what circumstances Oracle will produce ORA-01555 errors: Assuming that there is a testdb table of 60 million rows of data, it is expected that testdb full table scanning 1

Java EE development of various types of resources download list, the history of the most complete IT resources, click to enter. 1. General SID Mode Jdbc:oracle:thin:username/password@x.x.x.1:1521:sid2. Ordinary servername Way

Have always wanted to summarize the knowledge of Oracle memory tuning, recently optimized a database memory parameters, look for some information and Google a lot. Now write it down and do the backup. First, overview: Oracle memory can be divided

CREATE USER "NewUser" identified by "NewUser"DEFAULT tablespace Crm_dataTemporary tablespace TEMPAccount UNLOCK; Today, I created a user named NewUser on the oracle10g, but logged in normal state, always prompting for unsuccessful login, username

Turn from: http://database.51cto.com/art/201010/231126.htm The Oracle Wm_concat (column) function is what we often use, and here's how you can use the Oraclewm_concat (column) function to implement a field merge if you are wm_concat for Oracle

In the Pl/sql test window --Created on 2005-7-3 by TangtianDeclare--Local variablesI integer;leftpad varchar (11);Rightpad varchar (14);Begin--Test statements hereSELECT lpad (' hello! ', 8, ' Tangtian '), Rpad (' hello! ', 8, ' Tang ') into the

1, the row and column conversion of fixed number Such as Student Subject Grade --------- ---------- -------- Student1 Language 80 Student1 Math 70 Student1 English 60 Student2 Language 90 Student2 Math 80 Student2 English 100 ...... Converted