Oracle

REGEXP_SUBSTR Functions in OracleInstructions for using the REGEXP_SUBSTR function in Oracle:The topics are as follows:In Oracle, a statement is used to implement the ' 17,20,23 ' split into a collection of ' 17 ', ' 20 ', ' 23 '.The REGEXP_SUBSTR

Directly on the SQL code:Declare begin forCinch(SelectS_personinfo.nextval asSeq fromdual) LoopInsert intoTbpersoninfo (Ipersoninfoid,vcpersoncard,vcpassword,vcpersonname,vcpersionsex)Values(C.seq,'33000021','123456','Xiao Ming','male',); ifC.

--Create the user created (username is wpip, password is WPIP) create username Wpip identified by wpip default tablespace pipdb_dat1 temporary tab Lespace TEMP profile DEFAULT;--Grant/revoke role privileges (grant to user Wpip Connect, DBA, resource

Case: Open card information in the bank Field Field type Id Number Name VARCHAR2 (64) Sex CHAR2 () Birth Date Money Number (10,2)

1. After extracting the Oracle compressed files, open the directory and double click "Setup.exe" to start the installation.2. "Oracle Universal Installer" window pops up3, e-mail prompts, follow the default next action4, the second step directly

Oracle creates a normal user and gives permissions1) using SYS or system/manager as SYSDBA; Connect to the database.2) Create peng:create user Peng identified by pwd_oracle;Delete users, drop user peng;3) grant the user permission to log on to the

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　Cursor Properties and Restrictions/*1. Cursor Properties%found%notfound%isopen to determine if the cursor is open%rowcount the number of rows affected2, the cursor limitBy default, the Oracle database allows only 300

Many times, we do a small batch of data migration will use the data pump, but 12C we want to configure TNS to specify the PDB import, but the public service we are through the cluster using SRVCTL to create. At this time preferred instances may have

Recently, because the table space of the customer data in the business is occupied too large, and want to reduce the size of the tablespace file by deleting some data, it is possible to use partition table to implementPartitioned tables are divided

Transfer from http://www.cnblogs.com/advocate/archive/2010/08/20/1804066.htmlDeepen your understandingThe database is a photographic film.Example is photo paperA film can be used to punch multiple photographic papers, but a photo paper is a maximum

1. Stitching strings1) You can use the "| |" To stitch a string2) through the concat () functionNote: Oracle's CONCAT function only supports two parameter methods, that is, only two parameters can be stitched together, if you want to stitch multiple

Delete statementBasic syntax:Delete from table name where conditionPrecautions:1, if you do not use the WHERE clause, all data in the table is deletedDelete from test;2, if you want to delete the value of a column, delete is not possible3, delete

This morning to the company, opened the computer and found that the launch of the Oracle instance, reported the following error:Oops, all of a sudden worried, the original still good how suddenly so? I recalled that it was my previous modified

I. ORACLE internal structure1. Table SpaceA tablespace is a logical division of a database, a table space belongs to only one database, each table space consists of one or more data files, and other logical structures in the table space are stored

CREATE TABLE Space--View all users, and the corresponding permanent table space, temporary tablespaceSelect Username,default_tablespace,temporary_tablespace from Dba_userswhere username= ' SYSTEM ';1.1 Creating a temporary table spaceCREATE

[Email protected] ~]$ Ps-ef|grep SmonOracle 14809 1 0 Sep25? 00:13:02 ORA_SMON_MAILP3[Email protected] ~]$ export ORACLE_SID=MAILP3[Email protected] ~]$ echo $ORACLE _sidMailp3[Email protected] ~]$ Sqlplus/as sysdba;Sql*plus:release 11.2.0.3.0

--creating materialized views using on commitCreateMaterializedViewEmp_dept Refresh on Commit as SelectT.*, D.dname fromEMP T, dept DwhereT.deptno=D.deptno; --creating materialized views using on DemandCreateMaterializedViewMv_name Refresh Force

Attempt to load Oracle client libraries threw badimageformatexception. This problem would occur when running in a bit mode with the-the-bit Oracle client components installed. ---> system.badimageformatexception: An attempt was made to load an

--Execution in---sqlplus (awr time period)@?/Rdbms/Admin/Awrrpt.sql-----Generate snapshots manuallyexecDbms_workload_repository.create_snapshot ();--statement Three executions, grouped into snapshots--Querying SnapshotsSelect *

First download and install Cx_oracle:: Installation: pip3.6 Install E:\PYTHON36\SCRIPTS\CX_ORACLE-6.0.2-CP36-CP36M-WIN_AMD64.WHL write a simple test code:Import cx_oracle as ora# print (ora.version) # Open database connection # conn = ora.connect