Oracle

Original sql:Select substr (field1, InStr (field1, ' | ', 1, rownum) + 1, InStr (field1, ' | ', 1, rownum + 1)- InStr (field1, ' | ') , 1, RowNum)-1) as Field2 from (select ' | ' | | ' A|bbb|cccc|ddddd|ee|d|a '

Syntax:InStr (Fatherstr, Sonstr [, Start_position [, Matchtimes]])Fatherstr: The parent string where to find the substring in this string.SONSTR: The string to find in Fatherstr.Start_position: Represents the starting position of the search from

In the DB2 database, in fact, there is an autostart parameters, but I do not know why in the db2v10.1 is always not effective, no way, had to solve their ownSome methods on the Internet is to write a script, set to boot, feel too much trouble, I did

Permissions classification 1. System permissions: Permissions for database operations, including but not limited to:CREATE TABLECREATE VIEWCREATE SESSIONCREATE SEQUENCECREATE PROCEDURE......2, object permissions: For user-created tables, view

1. View all tablespaces: SELECT * from Dba_tablespaces;2. View the default tablespace for a user: SELECT default_tablespace,username from Dba_users WHERE username= ' USERNAME ';3. View the remaining capacity of the table space: SELECT

Check the salary of each department in 25%, 50%, 75% position,Percent_rank () is the relative position in the ranking .CREATE TABLE EMP(EMPNO Number (4) is not NULL,Ename VARCHAR2 (10),JOB VARCHAR2 (9),MGR Number (4),HireDate DATE,SAL number

1. Case-When expressions have two forms--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function CaseWhen sex = ' 1 ' Then ' man ' When sex = ' 2 ' Then ' women ' Else ' other

1. Query the result set using an Oracle stored procedure:It's all bullshit on the internet! In fact a word on the line, you just return a cursor is OK. The specific code is as follows:CREATE OR REPLACE PROCEDUREpr_order_list (order_idVARCHAR2,

If you want to save as a bat file, it is best to use KanjiImport:IMP Clsoftoa/[email protected]--username/password of the database to be imported @ database nameFromuser= ' Clsoft ' touser= ' Clsoftoa 'File= ' D:\clsoft_2012-06-26_17.dmp '--the path

for a long time without Oracle for work reasons, it has taken some time to learn and record what you have learned in order to consolidate in the future (take 10g for example). I. ORACLE installation and uninstallation(1) Oracle installation can go

1. View All Users: SELECT * from Dba_users;  select * from All_users; select * from User_users; 2. View user or role system permissions (System permissions that are directly assigned to a user or role): SELECT * from Dba_sys_privs; select * from

Linux configuration Oracle with system boot and shutdown1. Modify the/etc/oratab fileModify the database you want to start with the OS from N to yLis:/u01/app/oracle/product/11.2.0/db_1:nModified to:Lis:/u01/app/oracle/product/11.2.0/db_1:y 2, edit

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  

drop table test Purge;CREATE TABLE Test (ID number,Code varchar (20),Name varchar (20));INSERT into test values (1, ' 201401 ', ' aaa ');INSERT into test values (2, ' 201402 ', ' BBB ');INSERT into test values (3, ' 201402 ', ' CCC ');INSERT into

1. Download JDK7 (i downloaded the Java SE Platform (JDK) 7u51):http://www.oracle.com/technetwork/java/javase/downloads/index.html2. Unzip the downloaded compressed package to any location in the system (I usually unzip to/usr/local/)3,

Oracle Database Connection Modeled http://blog.csdn.net/makenothing/article/details/17080069 1. Create an Oracle connection. Add a database connection in VS2010. Obtain the connection string Data Source = server1; Persist Security Info = True; User

ORA-12520 error solved one Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I can report the following

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'

When pfile is used to start an oracle instance, startup fails --- the db_recovery_file_dest parameter value does not exist on the OS. [Oracle @ vm22 ~] $ Export ORACLE_SID = orcl [oracle @ vm22 ~] $ Sqlplus/as sysdbaSQL * Plus: Release

About Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three steps: NOMOUNT-> MOUNT-> OPEN.