Oracle

PQL Parameters ORACLE Account------------------        -------------------------PQL_MASTLM = ASTLM = 1000Pql_mbiolm = Biolm = 1000PQL_MBYTLM = 1000000 BYTLM = 2000000Pql_mdiolm = Diolm = 1000Pql_mpgflquo = 2000000 Pgflquo = 2000000PQL_MPRCLM = PRCLM

= = <> (not equals)! = (Not equal to): = (Assignment)Between......and (contains boundaries in an interval)--Query wages from 2000 to 5000 of the salary select salary from employees where salary between2000and5000In ()--Query 80,90,70,50, department

1, to Anhui colleagues installed a production Oracle database, the recent period of time has always been 2 points-10 points between the database is not connected to the situation, the specific Tomcat application log as follows:08:58:09 ERROR C.d.web.

You can think of the result set of group by as a table, and then you can take the number from here.e.g.Select A.project_code,a.die_no,e.one_consuming from (select T.project_code, T.die_no, SUM (t.offline_qty) OffqtyFrom Data_plan TWHERE t.begin_date

Table Structure AnalysisBuild a Table statementCREATE TABLE TABLE_NAME (table_name VARCHAR2 (TEN), Table_name1 Int (5),)Alter statementALTER TABLE table_name ADD column_name datatypeALTER TABLE table_name MODIFY (column_name datatype)Oracle

The latest database space has a feeling catch urgent, last time, deleted some data empty 800+g, one months, and now there are 400+g, 10G per day increments, how much space also feel not enough ah.Cannot add the hard disk, only then deletes the

Storage FunctionsCreate or replace function Name of function (name in type, name out type, ...) return Data Type is result variable data type ;begin return ( result variable );end[Name of function];The difference between stored procedures and

Many times we need to filter the table to update, INSERT, delete and other operations. So if we're going to be a lot of trouble with a single table, here's how the merge into usage will greatly optimize the time and amount of code for our operation

| 0 |          SELECT STATEMENT |   |  107 |     2782 | 3 (34) |        00:00:01 |      |            | ||  1 |          PX Coordinator |       |       |            |          |        |      |            | ||   2 | PX SEND QC (RANDOM) |   : TQ10001 |

--1. Lists all department and department information for at least three employees.SELECT D.deptno, D.dname, D.loc, t.countsFrom DEPT D, (SELECT DEPTNO, COUNT (*) COUNTS from EMP GROUP by DEPTNO) TWHERE D.deptno = T.deptnoand T.counts >= 3;--2. List

(1) using Rman to view$ Rman Target/Recovery manager:release 11.2.0.4.0-production on Fri June 12 03:20:19 2015Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.Connected to target Database:dbtest (dbid=1275017193)Rman>(2) Use

The join on, left join, right join, INNER join (equivalent join), and common set operations for SQL Common Federated queries are: union, UnionAll, minus, intersect effects and summariesThe first book table and Pbook table are then used:First put the

--View data usage for all table spacesSELECT Upper(f.tablespace_name) "tablespace name", D.TOT_GROOTTE_MB "table space size (M)", D.TOT_GROOTTE_MB-f.total_bytes "used Space (M)", To_char (Round((D.TOT_GROOTTE_MB-F.total_bytes)/D.tot_grootte_mb* -,2)

Packages are used to logically combine procedures and functions, which consist of package specifications and package bodies.1), we can use the Create Package command for creating packages such as:I, create a package sp_packageII. Declare that the

To view the remaining table space:Select tablespace_name,sum(bytes)/1024x768/1024x768| | ' M ' from Group by Tablespace_nameView Total table space size, usage size, remaining size, usage, remaining

Syntax: Select...start with...connect By...priorThere are two main points1) The prior is placed on the child node side, indicating that the scan tree is scanned from top to bottom as the node specified by start with the root node. May correspond to

I. Naming rules for table and column names1), must start with a letter2), length cannot exceed 30 characters3), cannot use Oracle's reserved words4), can only use the following characters a-z,a-z,0-9,$, #等Ii. Types of data1), character classChar has

One set to archive mode 1Sql>ArchiveLoglist; #查看是不是归档方式2Sql> AlterSystemSetLog_archive_start=True scope=spfile; #启用主动归档 SQL> AlterSystemSetLog_archive_dest='Location=/oracle/ora9/oradata/arch'Scope=SPFile; #设置归档路径 SQL>

In daily work, Oracle Database recovery is sometimes required, such as setting up a test environment, finding historical data, and recovering tests. It is hereby documented that the recovery scripts can be executed in such a way as to schedule tasks

System PreparationVi/etc/selinux/config Iptables-fiptables-l/etc/init.d/iptables Save1. Network2. Memory >3gFree-m3. Storage >60gDf-lh4. Create users and user groupsGroupadd oinstallgroupadd dbauseradd-g oinstall-g dba oraclepasswd oraclemkdir-p /