Oracle

2 transaction isolation levels supported by Oracle Read committed and Serializable The Read committed is the default isolation level. Isolation levels (Isolation level) The isolation level defines the degree of isolation between transactions and

Advantages: 1. Precompiled, optimized, and highly efficient. Avoids the inefficiency of SQL statements being transmitted over the network and then interpreted.2. If the company has a dedicated DBA, the write stored procedure can be done by the

--1, Plsql or navicat database client Tools Administrator account: Table space Create tablespace demo_tablespace logging datafile ' D:\Oracle\database\ tablespace\demo.dbf ' size 100M autoextend on next 100M maxsize 500M extent management local; --2

Oracle function gets Chinese Pinyin first letter /*------Increase: yl--*/ Use of Nlssort functions in Oracle Nlssort (), used for language sorting Pinyin SELECT * from Team orders by Nlssort (sort field name, ' Nls_sort = Schinese_pinyin_m

Author: eygle Source: Http://www.eygle.com/blog Date: October 27, 2005 This article link: http://www.eygle.com/archives/2005/10/oracle_howto_kill_session.html «why my server down? | Blog Home | Oracle HowTo: How to start and close oem» in

DML (Data Manipulation Language): Used to retrieve or modify data. DML includes: SELECT: for retrieving data; INSERT: For adding data to the database; UPDATE: Used to modify existing data from the database Delete: Used to delete data from the

In one of the tables in Oralce, an address field contains full-width characters that need to be converted to half-width characters for further processing. Table Name: A Fields that include full-width characters: Address Edit table structure, add a

The original project is Ssh+sql Server2005, now move the system to the oracle11g, is going to generate database tables, the results start Tomcat Server, the console error, some tables can not be created, the wrong message is as follows: 16:23:24,896

1. List all tables for the current user: SELECT * from tab; 2.sqlplus can also execute commands on the operating system itself. The command format is: HOST operating system command For example, open the Windows registry, use: Host regedit; Open the

For SQL spool data, it is best to define the format yourself to facilitate direct import of the program, SQL statements such as:Select Taskindex| | | | commonindex| | | | tasktype| | | | To_number (To_char (sysdate, ' YYYYMMDD ')) from

Oracle Date Conversion Conversion functions The biggest relationship with date operations is two conversion functions: To_date (), To_char () The to_date () action converts a character type to a date type in a certain format: Specific usage: to_date

I. Demand when will an Oracle cursor be used, and the For, loop, if? Let's look at one such requirement: There is a Student class table t_teaching, each student has several courses: Primary Key ID (self-increasing) Course Number

Oracle Database system users forget their passwords. D:\oracle\ora92\bin>sqlplus/nolog Sql*plus:release 9.2.0.1.0-production on Thursday August 16 11:32:22 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Sql> Conn/

The following should be used by everyone. Sql> SELECT SID from v$mystat WHERE rownum = 1; Sid———-19949 The following is simpler, but can only be used in Oracle 10g and above. sql> SELECT USERENV (' SID ') from DUAL; USERENV (' SID ')————–19949

java-oracle Stored procedure knowledge Puzzle A stored procedure is a collection of SQL statements that is saved to accept or return user-supplied arguments. In daily use, complex business logic and operation of the database are often encountered,

preparatory work: Install Oracle Database on the machine, which is 11g, and is said to install only the client. then download the corresponding cx_oracle, so that Python can support Oracle, the first test using Python to connect Oracle may be

Bitmap indexes apply to low cardinality (low-cardinality) columns, and the so-called low cardinality column means that the column has very few desirable values. Problem with bitmap indexing:With a bitmap index, one key points to multiple rows,

Scope limitations for Oracle VARCHAR2 Varchar2In the table is 4000, in the process can be 32KThe VARCHAR2 in the process is not the same as the VARCHAR2 in the table and exterior.The length of the VARCHAR2 variable in the process can reach 32K, for

Today, when you help developers demon install Oraclexe, there is this tip: Destination folder:d:\oraclexe\ port for ' Oracle Database Listener ': 1521 port for Oracle Services for Microsoft Transaction Server ': 2030 Port for HTTP listener:8080 As

Data export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmp file=d:\daochu.dmp full=y2 Exporting the system user in the database to the SYS user's tablefile=d:\daochu.dmp owner= (System,sys)3 Exporting