Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11gr2 new APPEND_VALUES tips     - C language preprocessor command (Programming)

- CentOS 6.6 running level (Linux)

- CentOS installation Percona Server 5.5.42 compiling problem solve one case (Linux)

- Linux dd command applies amplification SWAP partition (Linux)

- The temporary operation of the document mkstemp on Linux (Linux)

- How to use awk command in Linux (Linux)

- Linux AS4 VPN server in conjunction with a firewall perfect (Linux)

- linux system optimization and security configuration (Linux)

- Linux (RHEL6 CENTOS6 OLE6) VNC-SERVER Installation and Configuration (Server)

- Android Unzip the ZIP / GZIP data (based on the InflaterInputStream implementation) (Programming)

- Android judgment toward camera pictures (Programming)

- Use ISO document production OpenStack used CoreOS mirror (Linux)

- Oracle LONG RAW BLOB CLOB type of presentation (Database)

- PostgreSQL using the system cache to improve operational efficiency (Database)

- How to download apk file from the Google Play store on Linux (Linux)

- 10 Regulation of painless SQL Schema (Database)

- To install Jetty server configuration in detail (Server)

- Elaborate .NET Multithreading: Using Task (Programming)

- VMWare virtual machine without rebooting way to add virtual disk (Linux)

- Configuring Android NDK development environment for Mac OS X (Linux)

 
         
  Oracle 11gr2 new APPEND_VALUES tips
     
  Add Date : 2017-08-31      
         
       
         
  In 11.2, Oracle added APPEND_VALUES tips, making INSERT INTO VALUES statement can use the direct path insert.

Example is very simple:
SQL> SELECT * FROM V $ VERSION;

BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL / SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> CREATE TABLE T_APPEND (ID NUMBER, NAME VARCHAR (30));
Table has been created.
SQL> INSERT / + APPEND (A) / INTO T_APPEND A
2 VALUES (1, 'ABC');
It has created a row.
SQL> SELECT * FROM T_APPEND;
ID NAME


-------------------------------------------------- ------------------------------

    1 ABC
SQL> COMMIT;
Submit completed.
SQL> INSERT / + APPEND (A) / INTO T_APPEND A
2 SELECT ROWNUM + 1, TNAME
3 FROM TAB
4 WHERE ROWNUM = 1;
It has created a row.
SQL> SELECT * FROM T_APPEND;
SELECT * FROM T_APPEND
*
Line 1 Error:
ORA-12838: Unable to modify in parallel mode after the read / modify objects

SQL> COMMIT;
Submit completed.
Results comparing INSERT INTO VALUES and INSERT INTO SELECT statement is you can clearly see, APPEND prompted for INSERT INTO VALUES statement is invalid, the data is still using conventional path insert.
Use APPEND_VALUES tips 11.2, which makes a single insert statement truly direct path mode:
SQL> INSERT / + APPEND_VALUES (A) / INTO T_APPEND A
2 VALUES (3, 'APPEND_VALUE');
It has created a row.
SQL> SELECT * FROM T_APPEND;
SELECT * FROM T_APPEND
*
Line 1 Error:
ORA-12838: Unable to modify in parallel mode after the read / modify objects

SQL> COMMIT;
Submit completed.
SQL> SELECT * FROM T_APPEND;
ID NAME
     
         
       
         
  More:      
 
- Android annotation support (Support Annotations) (Programming)
- Ubuntu 14.04 install PostgreSQL 9.2 (Database)
- OpenGL Superb Learning Notes - Depth Texture and Shadows (Programming)
- Android determine the device network connection status, and determine the connection (Programming)
- Linux Troubleshooting: How to save the status of the SSH session is closed (Linux)
- Linux / UNIX: Use the dd command to create a 1GB size binary (Linux)
- Build their own recursive DNS server (Server)
- Gitolite how to import other Git repositories (Server)
- MySQL 5.5 on master-slave copy filter (Database)
- The difference between statement and preparedStatement of the jdbc (Database)
- I like Linux Security (Linux)
- Install Debian Linux with R on the Android system (Linux)
- Quick Install software RAID on Linux (Linux)
- Java development specifications summary (Programming)
- Visual Studio Code experience (Linux)
- CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1 (Database)
- Ubuntu 14.10 / 14.04 / 12.04 How to install Kodi 14.0 RC3 (Linux)
- Linux Getting Started tutorial: XWindow what (Linux)
- How to configure security services under Linux (Linux)
- Linux platform Oracle MySQL connection (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.