commit sql

Oracle 12c has a new feature that can archive data in the database, hide infrequently accessed data from the application, and set it to inactive. Of course, it can also be displayed at the session level. This is achieved through the row archival

12-SQLite transactions and 12-sqlite transactionsI. Transaction Overview A transaction is a series of operations performed as a single logical unit. Multiple operations are submitted to the system as a whole, either executed or not executed.

Data loss during oracle Storage Using date, minute, and second, oracledate Today, a developer called me and said that there was a strange phenomenon. In the stored procedure, values of the date type are lost in minutes, minutes, And seconds. Here is

Create table student (id varchar2 (5) primary key, name varchar2 (20) not null, sex char (2) check (sex = 'male' or sex = 'female ')) -- insert a piece of data into student and use a function to verify whether the insertion is correct. create or

Oracle 12c has a new feature that can archive data in the database, hide infrequently accessed data from the application, and set it to inactive. Of course, it can also be displayed at the session level. This is achieved through the row archival

In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMAN catalog, all related scripts are provided to simulate Oracle Data Guard to a certain extent in a car to reduce database losses on the

The ASKTOM website provides the remove_constants function to check the SQL running status in the shared pool. The solution is to change the query condition value to a common tag, for example: replace select * from t where object_id = 1 with select *

In DBMS_METADATA, use SESSION_TRANSFORM to filter DDL and dbmsmetadata. When dbms_metadata.get_ddl is used to obtain the object ddl, other additional information is sometimes obtained. For example, when you want to obtain the table creation

Oracle Performance Analysis 5: Index Structure and scan mode of data access methods, oracle Index The previous article describes full scan. This article describes the index structure and scan methods, and describes each scan method later.When Oracle

Oracle performance analysis 6: Index scanning of data access methods, oracle Index This section describes various index scanning methods. After learning about the features of various index scanning methods, you can determine whether the scanning

Oracle11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval

Listparts, 11 glistparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval

Oracle Dual table details 1. Use of DUAL tablesDual is an existing table in Oracle that can be read by any user. It is often used in Select statement blocks without a target table.-- View the current connected userSQL> select user from dual;USER-----

Oracle FGA fine-grained audit and oraclefga fine-grained Audit If you want to audit the table, it is a good choice to use FGA for a certain period of time, persons and DML statements. SQL> select * from v $ version;Oracle Database 11g Enterprise

Oracle analysis function PERCENTILE_CONT, percentile Function Query the salaries of people with the salary distribution of 25%, 50%, and 75% in each department. percent_rank () is the relative position in the ranking. Create table EMP(Empno number (4

Solution to ORA-01417 under Oracle 11g Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This

Oracle 11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval

Oracle multi-key partition Test Partitions can be partitioned by two fields. The first column is compared first. If yes, the second column is ignored. If the first column is not met, the second column needs to be compared. This partitioning method

Single-record functions in SQL 1. ASCII Returns the decimal number corresponding to the specified character; SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual; A ZERO SPACE------------------------------------65 9

Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character (Note: it is a character rather than a string );SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual;A ZERO