Oracle

Data import times ORA-12899 error, that is, the length of the inserted data exceeds the set length of the field, the actual length is not long, because of the different Oracle character set, the length of the Chinese characters caused by different.

Environment:os:oel5.6rac:10.2.0.1.0There are rac1 at the moment. Rac2. RAC3 three nodes, the following is the process of deleting the RAC3 node1. Delete The DB instance on the RAC3 node[Email protected] ~]$ dbca-silent-deleteinstance-gdbname

Syntax:SELECT * FROM table_name where DBMS_LOB.INSTR (field name (clod type),' query condition ', ' n ') > 0;Syntax Explanation:In Oracle, you can use the InStr function to judge a string to determine whether it contains the specified character. Its

1, first create the usersyntax [Create users]: Create user username identified by password [i.e. password];Example: Create user zhengxin identified by Zhengxin;2. Giving the User DBA Authority Grant DBA to Zhengxin3. Open cmd command lineSyntax: MP

Data type:Character typeChar fixed length, maximum 2000 charactersvarchar LONG, max 4000 charactersCLOB (character large object) character type large objects, Max 4GNumber TypeNumber Range (10-38 Square to 10 38-square, fractional integer

In order to standardize the relational data model, the relational database system must obey certain rules in the design, which becomes the relational database paradigm. 1. First Paradigm 1NFif the value in the field is already a value that cannot be

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

 1 Start time and end time of the fetch week The start time of the pick-up week. Start with Monday. Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' D ') + 1 ASA from DUAL;A-----------2013/11/25

The virtual machine probably needs 60-80g of hard disk space, then the memory starts at 4G1. The first is the installation of operating system Rredhat, in the installation process to pay attention to each step to be optimistic, to choose with a GUI

Directory1) Basic2) Mathematical functions3) rownum4) Paging5) Time Processing6) Character function7) To_number8) Aggregation function1) Basic--New table:CREATE TABLE table1 (ID varchar (primary) key, name varchar (+) not NULL);--Inserting

First part knowledge preparation1. SQL Execution Process2. SQL sharing3. Binding variables4. Data table access method5. SQL Execution Order6. Index usage　　　　　　　　　　　　　　　　　　　　　　 1. SQL Execution Process1) Execution ProcessWhen an Oracle instance

[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.3.0 Production on Wed Jul 12 09:54:57 2017Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0

　　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

First, the basic concept of the databaseIi. Examples of databasesIII. Features of OracleIv. Oracle VersionV. Installation of Oracle ConsiderationsVI. Introduction to SQLVII. SELECT statementsFirst, the basic concept of the databaseDatabase (DATABASE,

[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

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