Oracle

Source: http://blog.csdn.net/itmyhome1990/article/details/16338637 Oracle is a relational database management system that organizes data in tables, and the data in some tables shows a tree-structured connection. For example, there are the following

Sql> CREATE TABLE Test (ID number,name varchar2 (Ten), Gender VARCHAR2 (5)); sql> INSERT INTO test values (1, ' Song Chunli ', ' Male '); 1 rows have been created. sql> INSERT INTO test values (2, ' ye min paid ', ' Male '); 1 rows have been created.

About node eviction of Oracle RAC caused by heartbeat network (not instance eviction)Ask:Suppose the following scenario: 4 nodes RAC, the heart jumper is the thousand m network switch, if the thousand m network switch power off, I want to know the

This method for using sequence (sequence) For example has a table temp_test structure for: CREATE TABLE Temp_test(ID number,NM varchar (10),Primary key (ID)//ID is the primary key, and the following method sets it as the self-increment field1,

how Oracle can see which users are currently connected to the database   can execute the following statements: Select username,serial#, sid from V$session;  ---Query user session alter system kill session ' serial#, sid

Reprint: Http://www.blogjava.net/pengpenglin/archive/2008/06/29/211462.html "original" Oracle Development topic: report functionDirectory=========================================1. Introduction to report functions2.ratio_to_report functionFirst, the

1.su-oracle #进入到oracle数据库的用户里面2. Start the database$sqlplus/nologMysql>conn/as SYSDBA Log in to the database as an administratorMysql>startup starting the databaseMysql>shudown immediate Closing the databaseMysql>quit exiting the database3. Start

This article original for freas_1990, reprint please indicate source: http://blog.csdn.net/freas_1990/article/details/46310145In Oracle, grouping and aggregation must be paired, and "non-grouped fields" must be aggregated, otherwise execution will

There is a SQL code like this:Get query results from C #:There are two parameters in the SQL code, all of which are string types, and the above C # code is the parameter required to generate the Oracle SQL code. The results of the operation are as

SELECT * from a where InStr (A, B) >0;To implement a B field that is part of a field, discuss the order or the character that you want to be adjacent.If you want characters that are either sequential or not contiguous, the definition function can be

Reason:Xiao sister called me to help her reload the database, so good weekend time not to go out to play, to her to install the database it is not very painful.I asked her why she had to reload, she said: After the data into the database, Chinese

In Oracle, for highly accessed packets, stored procedures or functions, a deadlock can occur. A script that uses a deadlock object will not run, causing the card to die, or to report an exception: too many connections are open.You need to use the

The basic syntax for ORACLE stored procedures is as follows:Create or Replace procedure stored procedure name (parameter) is or asDeclaring parametersBeginCodeEnd stored procedure name.Where or replace represents the creation if no such stored

Select Prod.amount,prod.plansum, (Prod.plansum-prod.amount) as borrow,d.enum_value from----result set subtraction(Select T.quo_prod_list_price * t.quo_prod_volume as amount multiply,----column valuesT.quo_prod_plan_cost * T.quo_prod_volume as

1. FunctionsCreate or Replace function Get_destroy_no return VARCHAR2 isResult VARCHAR2 (50);BeginSELECT Max (destroy_no) into RESULT from T_oms_device_destroy WHERE substr (destroy_no,0,8) = To_char (sysdate, ' YYYYMMDD ') ;IF (result = "OR result

Analytic functions Cube and Rollup charmFirst, take a look at the following example1) Create a tableCREATE TABLE group_test (group_id int, job VARCHAR2 (Ten), name Varchar2 (ten), salary int);2) Initialize tableINSERT into group_test values ('

Oracle Learning (7): Set OperationsSet operationSmall Example SQL> -- Query employees with Department numbers 10 and 20 SQL> -- 1. select * from emp where deptno = 10 or deptno = 20; SQL> -- 2. select * from emp where deptno in (10, 20); SQL> -- 3.

The string in oracleerror quotation marks is not properly ended.ERROR:ORA-01756: the string in the quotation marks does not end properlySelect distinct. jno from Rt as a where not exists (select pno from St as B WHERE NOT EXISTS (SELECT JNO, PNO

Oracle shrinktable shrink table Use Cases There is a serious shortage of External table space in the site, and the customer does not want to resize it. To clean up some data, it is a large field blob. the tablespace is 1 TB and 0.99 TB has been used.

Oracle SQL optimization Case 1: oraclesql Optimization An Alert email is sent from a job in the monitoring alarm log file (Alert). The tablespace TEMPSCM2 cannot expand the temporary segment, indicating that the temporary tablespace has been used up