Oracle

V$session is a synonym for the sys.v_$session view under the apps user.In this view, each session that is connected to a database instance has a record. including user session and background process such as dbwr,lgwr,arcchiver and so on.v$session

Decode function is very useful in the actual development, and the function is more powerful, with other functions, can make a lot of work easier;DECODE ( field , condition 1, result value 1, condition 2, Result Values 2, ... Default Value  ); The

Because I do not have Oracle installed locally, using PL/SQL Developer Remote Connection server requires the following configuration:1. Software PreparationOracle Client: Instantclient-basic-win32-11.2.0.1.0.zipPL/SQL Software: Pl/sql_developer.zip2.

1. Select * from EMP;2. Select Empno, ename, job from EMP;3. Select empno number, ename name, job work from EMP;4. Select Job from EMP;5. Select distinct job from EMP;6. Select distinct empno, job from EMP;Description: Because the employee number is

For complex where condition combinations, where contains multiple indexed fields, consider the use of if statements to discuss the situation;At the same time, remove unnecessary external parameter conditions, reduce complexity, in order to use

Transfer from Http://wenku.baidu.com/link?url=uD_ Egkkh7jtuyjarv8ym6k8clbt6gpjs4ulsy5wkhz46d9bnychtpdgjgd7y6uxytbnhq3ixsgeap0aabtulnqcvwjkgm2lyzpcbx544zrgOracle Database EXP/IMP command details exp/imp commands     EXP/IMP Two commands can be said

Installing JDK6 on Ubuntu 12.04 Lts is not complicated by itself, but the newer version of Ubuntu is not supported directly through the Apt-get installation. Therefore, the installation package needs to be downloaded from the official Oracle website.

1. How to unlock Scott account cause: The default oracle10g Scott cannot log in. Solution:(1) Conn Sys/sys as sysdba;//logged in as DBA(2) ALTER user Scott account unlock;//then unlock(3) Conn Scott/tiger//Popup A Password Change dialog box, modify

Explore Oracle's database Upgrade nine12.1.0.1 Update 12.1.0.2First, check the current database version and System Information[[email protected] ~]$ lsb_release-alsb Version:: Core-4.0-amd64:core-4.0-ia32:core-4.0-noarch: GRAPHICS-4.0-AMD64:GRAPHICS-

Our database operates in Archivelogmode. The Redo log files areNot multiplexed and one of the online redo logs is missing. The Missing Redo log sequence, ISA, is not archived and it contained InformatiOn from 10:35 a.m. onwards. The current time is

1. I used to think that Integer=number (38,0)--38 is number's maximum precision integer is a very large data type, which can be represented as power (10,126)-1 because a byte maximum represents 256, Then n bytes Max represents power (256,n) >=power (

The meaning of the fields of each table:(Reference from: http://www.cnblogs.com/mchina/archive/2012/09/06/2649951.html) 1, Department table: Dept № name type Description 1 DEPTNO Number (2)

The backup-based Rman Duplicate command to create the standby databasePrerequisites: To ensure that the original database backup, archiving for the standby end is fully visible,This assumes that the original library and the target data file, log

Oracle's rounding and rounding functions--floor,round,ceil,trunc usage instructionsfloor--The integer digits of a given numberSql> Select Floor (2345.67) from dual;Floor (2345.67)--------------2345ceil--returns the smallest integer greater than or

ORACLE error 1658 When importing data to oracle, the following error is reported multiple times: IMP-00003: encountered ORACLE error 1659ORA-01659: unable to allocate MINEXTENTS greater than 1 (in tablespace ZSTA_DATA_TBS) IMP-00003:

[Original] solves the problem of excessive oracleCPU with the help of AWR report analysis, awroraclecpu  Introduction:In oracle databases, there are two very useful built-in monitoring tools: EM (Enterprise Manager) and AWR (Automatic Workload

Simple query and limited query, simple limitation Use a table under scott,   1. -- Query all the table contentSELECT * FROM emp;2. -- Query employee ID, name, and basic salarySELECT e. empno, e. ename, e. salFROM emp e;3. -- Query positions and

ORA-12523: TNS: Listeners cannot find routines for client connection, ora-12523tns Today, when you connect to a new test server using PL/SQL Developer, you encounter a ORA error: ORA-12523: TNS: The Listener cannot find a routine for client

Create a tablespace script in oracle Preface: Previously, we used oracle tools to generate tablespaces. Today we see a more convenient and fast way to use database scripts. /* Divided into four steps * // * Step 4: create a temporary tablespace

Basic Oracle data type, basic oracle Data Type I. Data Types in Oracle Oracle provides a wide range of data types to store data, including: 　　1. Character Type: Mainly used to store string-type data.　　 Data Type Length Description