Oracle

Isnull () in sqlserver () Nvl () in Oracle () Nvl (expr1, expr2) If expr1 is null, the value of expr2 is returned; otherwise, the value of expr1 is returned. Nvl2 (expr1, expr2, expr3) If expr1 is not null, the value of expr2 is returned;

I wrote an article yesterday, but it cannot solve the problem of connecting to Oracle using WINXP SP2 + php5.1.4 + apache2.2.2. Last night, I saw from the official PHP website that I had upgraded to PhP 5.2 and immediately went down. After going

In the article "Install RHEL 5.2 record (1)", we will first learn how to install rhel5.2 to install oracle. After some exploration, we finally set up the RHEL environment, including the Chinese language environment (although this is not much help

  Http://space.itpub.net/9399028/viewspace-687358    A usage for getting down from the Internet OracleSent Email Stored Procedure. You can directly call this stored procedure by sending an email. The parameter meanings are described. The Code is as

Document directory 2. Usage of case when in different positions in the statement 1. The case when expression has two forms: -- Simple case function case sex when '1' then' male 'when' 2' then' female 'else' other 'ends -- case search function

 -- 1. Learning jobs in PLSQL -- Learning job -- Create a table Create Table test_job (para_date date ); Commit; Insert into test_job values (sysdate ); Commit;   Select * From test_job; -- Establish the storage process Create or replace procedure

This article from: http://blog.csdn.net/caihaijiang/article/details/6083566   1. Download the instant client from the Oracle Website: Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html Select different Instant

This is a virtual table. You can use this table when operating most Oracle Objects, such as sequence and sysdate.For example, select sysdate from dualSelect seq1.nextval from dualAnd so on. 1. Dual is created by SQL. bsq. When each database is

Hints is a mechanism provided by Oracle to manually specify the execution plan of SQL statements for hint writing. It is used to tell the optimizer to generate an execution plan in the way we tell it. We can use hints to achieve: 1) Type of

In Oracle databases, undo has three major functions: providing consistent read, rollback transaction, and instance recovery). Consistent read is relative to dirty read (dirtyRead. Assume that a table t contains 10000 records. It takes 15 minutes to

From Oracle 9i, You can monitor the usage of Oracle indexes by using the following methods: Alter index . monitoring usage; After enabling monitoring for an index, you can check whether the index is used: To disable INDEX usage monitoring, use the

Why cursor: First look at this: Declare v_empno EMP. empno % type; v_ename EMP. ename % type; begin select empno, ename into v_ename, v_empno from EMP; dbms_output.put_line (v_empno | ''| v_ename); end;This SELECT statement may return

1. Define the stored procedure of Oracle with output cursor. The output cursor definition type is sys_refcursor.1 create or replace procedure sp_demo ( 2 emp_no in varchar2, 3 o_res1 out varchar2, 4 o_res2 out varchar2, 5 o_ds1 out sys_refcursor, 6

Example: PID IDA BA cA EB B1B B2C C1E E1E E3D D1Specify pid = A and selectA BA cA EB B1B B2C C1E E1E E3SQL statement: Select parent, child from Test start with PID = 'A'Connect by prior id = PID     OracleSQLRecursive query:1. Table StructureSQL>

Oracle import utility allows you to extract data from a database and write the data to an operating system file. The basic format used by IMP: Imp [username [/password [@ Service]. The following describes common usage of imp. 1. Get help imp

// Create a temporary tablespaceCreate temporary tablespace test_tempTempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf'Size 50 mAutoextend onNext 50 m maxsize 2048 mExtent management local;// Create a data table

In business system applications, a large amount of data is often submitted (including querying, updating, or deleting). If the data volume of the target database is large, a large number of operations need to be processed at a time, the system

Record the information to facilitate future search:Create or replace procedure sp_test ( AA in varchar, Bb in number default 0 ) Is V_pos varchar (50 ); V_num number; Begin   --- String search and replacement Select substr (parameter, 1, instr

1. Concepts and usage Similar to the custom type in C, it can be used to define the field set of a table. Type recordname is record (Field Name field type,Field Name field type); Use steps: 1) Declare struct 2) define struct variable 3) use. 2.

1. Create a stored procedure Create or replace procedure Test (var_name_1 in type, var_name_2 out type) -- Declare a variable (variable name and variable type) Begin -- Execution body of the stored procedure End test; Print the input time