Oracle

SUSE one-SP2 installation of ORACLE 11g small problems encountered:1. Run in the database directory./runinstall, after the appearance of the graphical interface, and then point to the next step, to the 3rd or 4th interface, the card is not moving,

1 Importcx_oracle2 ImportMySQLdb3 4 defconn_oracle ():5CNN = Cx_oracle.connect (' User name','Password','IP: Port number/Database') //user name, password, IP port number database6Cur =cnn.cursor ()7 returnCnn,cur8 9 Ten defclose_oracle (cnn,cur):

The difference between Oracle's sqlplus and Plsql job Java code Create Job Variable test_job_really number; Begin Dbms_job.submit (: test_job_really,' Test_jobproce; ', sysdate,' sysdate+1/1440 '); Commit End ------------------

For the use of Any,all, the book said more around the mouth, difficult to understand, if by example will be more clear.Example of any:SELECT * from T_hq_ryxx where Gongz > A (select Pingjgz from T_HQ_BM);The result of the output is all values

Any: if it is greater than (a > B), then all values in a that are greater than the smallest number in B will be output.If the number is less than (a SELECT * from T_hq_ryxx where Gongz > A (select Pingjgz from T_HQ_BM);Some: usage is the same as any,

Oracle Date-time functions Daquanto_date Format (time: 2007-11-02 13:45:25 for example)Year :yy two digits two-digit year display value:yyy Three digits three-bit year display value: 007yyyy four digits four-digit year display value:Month:mm number

1.View server-side encodingSelect Userenv (' language ') from dual;The result I actually found was: American_america. Al32utf82.EXECUTE statement SELECT * FROM V$nls_parametersSee if the value in the parameter item in the first row is the same as

1, Baotou:CREATE OR REPLACE Package bawq_proc_page are-- bawq_proc_page is the packet header TYPE t_cursor is REF CURSOR ; -- dynamic cursor PROCEDURE proc_page-- stored procedure name ( cs_zbin INT: =

2015-10-24DirectoryResources[1] How to monitor Oraclezabbix monitoring Oracle[3] Oracle Performance monitoring common commands[4] Oracle database monitoring and fault maintenance[5] Oracle Monitoring query statement[6] Monitoring of the number of

First download on Oracle official website:Note Before installation: Copy the \win64_11gr2_database_2of2\database\stage\components\* from the WIN64_11GR2_DATABASE_2OF2 to the \win64_11gr2_ Database_1of2\database\stage\components directory, or the

SQL constraintsConstraints are used to restrict the type of data that is joined to a table.You can specify constraints (through the CREATE TABLE statement) When you create the table, or you can (via the ALTER table statement) after the table is

1. Establish a link to the database operation, SQL Server can use ADO, Oracle can use OLE DB or System.Data.OracleClient (need to add reference to use)The advantage of this scheme is simple, each write their own database operation code, the

Previously summary:In queries through the SELECT statement, the returned result is typically a collection of multiline records. The cursor mechanism is provided for this SQL. Cursors can act as pointers so that the application design language can

Tag:oracle   linux    startup script     #!/bin/bash#chkconfig:35 01case "in Start" echo-e "\n\t\t ' date +%f ' date +%t '" Echo-e "\t\t is starting lsnrctl start. : "Su-oracle-c ' lsnrctl start ' &>>/var/log/oracle echo-e" \t\t is starting dbstart

1 GrammarGreatest (Expr_1, expr_2, ... expr_n) 2 DescriptionGreatest (expr_1, expr_2, ... expr_n) function from an expression (column, constant, computed value) expr_1, expr_2, ... expr_n and so on to find the largest number to return. At the

Processing When the oracle tablespace is too large First, view the data usage of all tablespaces. SELECT Upper (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)",

Delete duplicate recordsBecause data is manually input, duplicate data is often generated, and redundant data needs to be deleted. CREATE a test TABLE: create table dupes (id integer, name varchar (10); insert into dupes VALUES (1, 'Tom '); insert

Common oracle Stored Procedure skills1. Stored Procedure structure 1.1 The first Stored Procedure Create or replace procedure proc1 (p_para1 varchar2, p_para2 out varchar2, p_para3 in out varchar2) as v_name varchar2 (20); begin v_name: = 'zhang

Movement of oracle tablespace data filesRequirement: to move the data files in a certain tablespace from one path to another for some reason: (1) the tablespace files and system tablespace files in the current instance are all on one hard disk, IO

Sort values in different columns based on conditionsSometimes the ordering requirements are complex. For example, if a leader is more interested in employees with salaries between 1000 and 2000 yuan, the employees with salaries in this range must be