Oracle

fields in the database 2017-07-11 13:37:51 type is char or varcharTo compare the input with ' 20170625 ', the format is inconsistent and needs to be converted to: YYYYMMDD string1, first to_dateto_date (create_date, ' yyyy-mm-dd,hh24:mi:ss ') format

　　This blog for work, see the technical issues of the solution notes, Welcome to reprint, reproduced please indicate the source, thank you ~　　　　Update Time: 2017-07-12　　1. When reading the Clob field value, the Oracle Datagram data type is

[From] Https://oracle-base.com/articles/10g/dml-error-logging-10gr2You need to record a specific record of errors in a large number of DML operations, and see that there are two scenarios, one of which is to use the bulk DML operation Bulk collect

Oracle Table Partitioning Detailed-Teach you step -by-Step Oracle Partitioned Tables1, create three different table spaces, simulate saving different ranges of data on different disks create tablespace test01

1. Download MinGW (GCC compilation)---Win322. Download the latest OCI version, stored in C:\instantclient_12_1---Win323. Download OCI SDK latest version, store in C:\INSTANTCLIENT_11_2\SDK4. Download the relevant source code.Configure system

Meet a customer, there is a need to extract data from MSSQL into Oracle. After searching the internet, I feel that the Gateway tool can be implemented, so we will set up an experimental environment for testing. First download the corresponding

1. Download instantclient-basic-win32-11.2.0.1.0(Oracle official Website:http://www.oracle.com/technetwork/topics/winsoft-085727.html, 2:http://download.csdn.net/ detail/czw2010/5732241) 2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place

1, char (size) holds a string, it can hold a maximum of 2000 characters, is a fixed length.To illustrate:CREATE table test1 (name char); The name field in the//test1 table holds a maximum of 32 characters and less than 32 characters Oracle will use

Currently in the Oracle database (version before 11G) parsing JSON there is no direct use of the system method, the online Plsql script can only parse the structure of a single JSON string, for the complex structure of JSON string can not be

1. Overview of Table Spaces1. Tablespace is a logical part of a database. 2. Physically, the database data is stored in the data file; 3. Logically, a database is stored in a table space, and the tablespace consists of one or more data

1. Knowledge points--First stored procedure/* Print Hello worldcreate [or replace] PROCEDURE procedure name (list) as Plsql subroutine body; Call stored procedure: 1. exec SayHelloWorld (); 2. Begin SayHelloWorld (); SayHelloWorld (); End /*

1. Open PL/SQL DeveloperIf PL/SQL developer is installed on the machine, open the PL/SQL Developer interfaceEnter the user name, password, and host name, which is exactly the same as configured in Web. config in the program, click OKLocate the

Flashback recovering dataPreparatory work:1. Create a table spaceCreate tablespace zxq datafile ' d:\zxq.dbf ' size 2m;2. Create a userCreate user Zxq identified by zxq default Tablespace zxq;3. Create a test tableCREATE TABLE Zxq.zxq as SELECT *

1. Query the profile information: SELECT * from SYS. Dba_profiles;SELECT * from SYS. Dba_profiles where profile= ' DEFAULT ';2.An example of creating a profile:1. CREATE profile "TEST"2. LIMIT3. Cpu_per_session 10004. Cpu_per_call 60005.

Assuming that you run the following command, you will basically find two root.sh scripts under the Oracle Software folder[Email protected] templates]$ find/u01/-name root.sh |xargs ls-ltr-RWXRWX---1 oracle oinstall 02:37/u01/app/db11g/product/11.2.0/

-Three Forms of loop (1). LOOP (2). While ... Looop (3). For ... LOOP1. Basic Loop statement set Serveroutput on;--exit ... when end loop declare v_value number (8): =-3; BEGIN >-loop tag loop dbms_output.put_line (' V_value = ' | | v_value);

First, disable constraintsALTER TABLE table_name DISABLE NOVALIDATE constraint constraint_nameSecond, bulk import dataBe sure to check the violation of the constraint before opening the constraint record1. Execute the script Utlexpt1.sql from Oracle

Oracle Self-Growth ID:Reference blog: Automatic incrementing of the Oracle Database creation table ID fieldMyBatis statementsReference blog: Reviews ibatis+oracle three ways to bulk insert. Refer to the third typeReference Blog: Two ways to BULK

　　Oracle queries　　　　One, simple queryORDER BYSelect T.sno, T.sname, t.ssex from STUDENT t ORDER byGroup BY Enhanced EditionSELECT P.toma, P.ptype, SUM (P.lastcou) from product P GROUP by Rollup (P.toma, P.ptype)　　　　Second, advanced query

I. Database DMP file ExportUnder the PL/SQL tool, select Export Tales, select all tables, and select the exported path.Second, database DMP file ImportCreate user table space;Create User: Grant DBA to AML;Execute Import Script: (premise: Windows