Oracle

Original: http://www.cnblogs.com/crazyjava/archive/2012/10/31/2748202.htmlInStr (String1,string2[,start_position[,nth_appearence])String1: To find in this string.String2: The string to find in string1.Start_position: The location to look for from

I. Oracle Common data types (other types are less common)(1) Character type1, char fixed length, maximum 2000 characters. For example: char (10) ' Xiao Ming ' first four words descriptors ' Xiao Ming ' after adding 6 blanks to complete. 2, VARCHAR2 (

Select Userenv (' language ') from dual;Simplified Chinese_china. Al32utf8Sql> Conn/as sysdba;sql> shutdown immediate;Database dismounted.sql> startup Mount;Total system global Area 135337420 bytesFixed size 452044 bytesVariable size 109051904

ObjectiveThis chapter is mainly about Oracle's architecture, which is also a strong theory. There are some more theoretical points of knowledge (such as table space AH), temporarily do not write, the next chapter began to enter the operational phase

SQL statements for querying and deleting duplicate records   reprinted from: HTTP://WWW.CNBLOGS.COM/252E/ARCHIVE/2012/09/13/2682817.HTML1, redundant duplicate records in lookup tables, Duplicate records are based on a single field (ID) to determine  

In Oracle, single quotes have two effects:1: String is quoted by single quotation mark2: Escape.The use of single quotation marks is the nearest pairing. While single quotation marks are relatively poorly understood when they act as escape

SQL statements that are paged and sorted by RowNum in Oracle are used to using such SQL statements before paging:Select * from (SelectT.*, RowNum row_num fromMyTable TOrder byt.id) bwhereB.row_numbetween 1 and Tenit turns out that because the

/**scm_iss.test_imti_fun2* function*/create OR REPLACE FUNCTION test_imti_fun2 (p_no in number) with input parameters RETURN VARCHAR2 is P_imti_name VARCHAR2 (200); P_imti_desc VARCHAR2 (200); P_return VARCHAR2 (200); BEGIN--select i.imti_name

--1, querying system tablespace informationSELECT * from SYS. Dba_tablespaces;--2, query table space where the path informationSELECT * from Dba_data_files;--3, querying user-owned table spacesSelect U.username as user name, u.default_tablespace as

1. The following steps: Start key--Enter run-in Sqlplus enter username: sys input password: SYS as SYSDBA//NOTE: The password entered here must follow the as SYSDBA.      sql> alter user Scott account unlock; The user has changed.      Sql> commit;

We may need to manipulate the Oracle database in our tests, such as a scenario where the data is inserted into Oracle while another tool reads from it, and how to ensure that the data being read is sequential, that is, first inserted into the first

One: Version informationOperating system version: AIX 61009Database version: 11.2.0.3.11 (RAC)Two: Error description1) Crsctl Stat res-t command to view the CRS resource status, Discover "Ora." Listener.lsnr "Resource Status exception:Ora.

Http://hi.baidu.com/rebooo/item/12b500b130022bf263388e69 assumes A is the primary table (which contains a table with a primary key) and B is from the table (that is, the primary key that references A is the foreign key). When a table is deleted, if

Mysql-implements Oracle-row_number () over (partition by) grouping sorting functionBecause MySQL does not provide a rich analysis function like over () in Oracle. So in MySQL we need to implement such a function, we can only use a few flexible

1, common date type data types1.1. DATEThis is the most commonly used date type for Oracle, which can hold dates and times, which can be used for common date processing. Date range may be from January 1, 4712 to December 31, 9999 A.D.The date type

Oraclerman recovery from different machines     Oracle source host Oracle target host Host Platform CentOS6.2 (final) CentOs6.2 (FInal) Host Name Vick Rman IP address 192.168.1.11 192.168.1.

Use Cases of Oracleupdate +Drop table test purge;Create table test (Id number,Code varchar (20 ),Name varchar (20));Insert into test values (1, '20170101', 'aaa ');Insert into test values (2, '20170101', 'bbb ');Insert into test values (3, '20170101'

Oracle _ control User PermissionsZookeeper Oracle _ control User Permissions ① PermissionDatabase Security:System SecurityData securitySystem permissions: Database PermissionsObject permission: permission to operate on database objects 1. System

Oracle technology _ UTL_FILE package Usage Details _ writing files, reading and receiving tables UTL_FILE is a standard toolkit provided by oracle for reading and writing files. This document describes how to use this package through an instance.

Installing oracle software using NFS Yesterday, I used openfiler to create a nas storage system and install the oracle software. Everything went well before that. A ora error was reported when I created a database. When I used nfs to install the