Oracle

Turn on the flash back databaseALTER DATABASE flashback on;ALTER DATABASE open;Modify Date Time display format:Alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ';View the Flashback database log information in the system view

The index is like the directory of a dictionary. With the dictionary directory, we can find the items we need very quickly. The same is true for databases.　 　With an Oracle database index, related statements can quickly locate the location of a

Oracle field typeHttp://www.cnblogs.com/lihan/archive/2010/01/06/1640547.html Field type Describe Field length and its default value CHAR (size) String data used to hold the fixed length (size) byte.

Hello everyone, this is a small part of me to tidy up every time the project to deploy the server in the field of the most commonly used Oracle database SQL statements, I hope to help everyone.--Create a data table spaceCreate Tablespace

Oracle Intercept string Function substrSubstr The Intercept string function in Oracle. The syntax is as follows: substr (String, start_position, [length]) Parametric analysis: String String value Start_position The initial position of the truncated

1, first to download the installation cx_oracleNote: The downloaded version of Cx_oracle is consistent with its own version of the Python environment, or the database may be connected to an error. 2. Database table structure3. Python

In Oracle 10G or 11G versions, the reasonable setting of the shared pool size has a significant impact on the performance of the Oracle database.The size setting rules for the Shared pool are as follows:1. Find a reasonable value for the shared pool

Quickly import Oracle data to MySQL using MySQL migration toolkitCome on, start talking nonsense.I recently learned some knowledge of the database, prior to contact with Oracle and MySQL, and recently very popular MongoDB non-relational database, so

Recently saw a lot of links to Oracle database blog, after I measured, the. NET environment to connect to the Oracle database is divided into the following steps:1. Connecting an Oracle database requires downloading a Oracle.DataAccess.dll file. The

64-bit environment, use PL/SQL developer to connect to Oracle:1. Download the 32-bit Oracle instantclient and expand to a directory, such as C:\instantclient-basic-nt-11.2.0.2.0;·2. Copy the system's Tnsnames.ora to the directory;·3. Set up the

Union, which is combined with two result sets, excluding duplicate rows, and sorting the default rules;Union all, which is set up for two result sets, including repeating rows, without sorting;Intersect, the intersection of two result sets,

CREATE TABLE Test(NO number,VALUE VARCHAR2 (100),NAME VARCHAR2 (100));--------------------------------------INSERT INTO TestSELECT * FROM(Select ' 1 ', ' a ', ' Test 1 ' from dual UNION ALLSelect ' 1 ', ' B ', ' Test 2 ' from dual UNION ALLSelect ' 1

The power of Oracle is that he can always help you choose the right execution plan , even if you give it the wrong instructions. Experiment:1. Create a test table :Collect statistics:To create a B-Tree index:2. Execute select ID from Tbl_plan; view

Dbms_stats can well estimate statistics (especially for larger partitioned tables) and get better statistical results, eventually making a faster SQL execution plan.EXEC dbms_stats.gather_schema_stats (Ownname = ' SCOTT ',Options = ' GATHER AUTO

Https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P 11_question_id:1163635055580http://blog.csdn.net/zq9017197/article/details/76900611. First create a table to hold the collated data:CREATE table T1 as select Sql_text from V$sqlarea;2. Add a

Centos6.5 install Oracle11gR2 (64-bit)Centos6.5 install Oracle11gR2 (64-bit) and centos6.5 (My virtual machine environment) 1. Download The centos6.5 installation package. For example:2. Download the oracle installation package, which is not

How to view the Oracle client version and the oracle client In practice, you will always encounter issues that require you to view and verify the ORACLE client version, because one server may have multiple Oracle client versions; you may also need

Length of Chinese Characters in Oralce Generally, we use the String. length () method when verifying the String length at the Java layer. The returned length is the same in both Chinese and English. However, after a database is inserted, an error is

In a 64-bit Window operating system, the Orcal Data Access server and client versions correspond to communication problems. 2014-11-04 Reference: http://blog.163.com/huiping_z/blog/static/80541312201310191020557/ Can the 64-bit operating system

Oracle dynamic SQL statements Dynamic SQL return cursor: Create or replace procedure partition (p_regioncode in number, p_pscode in number, p_outputcode in number, p_pollutantType in number, Region in varchar2, p_attencode in varchar2, p_checkstatus