Oracle

Resources:Oracle stored procedures and parameters understand the non-parametric stored procedures: Create or replace procedure SayHello as -description part begin Dbms_output.put_line (' Hello World '); End two ways to invoke a command

Set operator precedence is the same as "=" Union: joint operation (combined with set, going heavy) Query number 7833 current wages, positions and historical wages, jobs SELECT sal,job from EMP WHERE empno=7839 UNION SELECT sal,job from

Oracle Column Operations Add a column: ALTER TABLE Emp4 Add test varchar2 (10); Modify a column: ALTER TABLE Emp4 Modify Test varchar2 (20); Delete a column: ALTER TABLE emp4 drop column test; Here to pay attention to a few places, first of

Commit (Commit), rollback (rollback) DECLARE dept_no number (2): =; Begin-Start transaction INSERT into dept VALUES (dept_no, ' marketing department ', ' Beijing '); --Inserting department records INSERT INTO

㈠ Definition builtA reverse index sets the key value (each column key value) to the byte, and for the key combination, the order of the columns is preserved, but the bytes of each column are reversed For example: The contents of a column in a

This two days to the new colleagues to arrange a job, that is, to do an update cascade update, in the actual operation found a problem. For Oracle's newer syntax, most people, especially those who have studied SQL Server, have a lot of questions

1. Knowledge points --First stored procedure/* Print Hello World create [or replace] PROCEDURE procedure name (parameter list) as Plsql subroutine; call stored procedure: 1. Exec SayHelloWorld ( ); 2. Begin SayHelloWorld (); SayHelloWorld (

A version of Show_space written by Master Tom. Often used in storage space analysis. Create or Replace procedure Show_space (P_segname in Varchar2, P_owner in Varc Har2 Default User, P_type in varchar2 default

Decode (condition, value 1, translation value 1, value 2, translation value 2,... Value n, translation value n, default value)The meaning of the function is as follows:IF condition = value 1 THENreturn (translation value 1)elsif condition = value 2

1. About sequences (about sequence) A sequence is a database object. Multiple users can generate sequential numbers through a sequence to achieve automatic, unique growth of primary key fields, and a sequence can be used concurrently for multiple

Exp local Export and imp local import Exp command:1 exp username/psw@test file=d:test.dmp full=y2 exp username/psw@test file=d:test.dmp owner= (ly)3 exp username/psw@test file= d:test.dmp tables= (GRID1,GRID2)1 One is the overall export of test

Reference Document: Http://www.cnblogs.com/eshizhan/archive/2012/04/06/2435493.html --NVL function -NVL (string1, replace_with) function: If string1 is null, the NVL function returns the Replace_with value, otherwise the string1 value is returned.

--********************************* --Oracle 10.2.0.1 upgrade to 10.2.0.4 --********************************* This article is based on the Linux environment Oracle, but and win difference is not very big, commands and so on are the same. I also

Problem When the development of the debug to an update of the SQL statement, the program will not move, and then I tried on the plsql, found that Plsql has been in the display is being implemented, and so long time no results. But it's strange that

Download Oracle's installation package: Download Address: Note Download Oracle is required to register Oracle's http://download.oracle.com/otn/nt/oracle11g Download Two packages: Linux.x64_11gR2_database_1of2.zip Linux.x64_11gR2_database_2of2.zip 1,

How to view the Oracle version and what options are installed. System environment: 1, operating system: Windows 2000 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, Installation path: c:/oracle Description 1. View database

If you have previously installed Oracle, you can clear it by using the following command: sudo rm-rf $ORACLE _home sudo rm/etc/oratab sudo rm/etc/orainst. Loc The two files in/etc are automatically generated when the root.sh is run during the

1. Programme Overview NFS, which utilizes Linux operating systems, provides disk space for UNIX, uses the Rman tools of the database to perform a backup of the database, and the backup data is stored in the disk space on the backup

Difference between left Outer join and Outer Association (+) in "original" Oracle 2008-03-23 16:22:37 url:http://space.itpub.net/?uid-6517-action-viewspace-itemid-216974 difference between on and where in Oracle's left join 2009-09-28

[Article summary] describes the basic use of the XmlType data type of Oracle9i includes: establishing a table with a XmlType data type Insert (insert) Data Query (SELECT) Data Update ( Update) Data Add more than 4k bytes of XML documents to