Oracle

  Create table xcp as (select * from B _za_bzdzkxx ); Select * from xcp; Select count (1) from xcp; -- 22001 Select count (1) from xcp t where t. dzbh like '20140901'; -- 510521% Delete from xcp t where t. dzbh like '20140901 '; Select count (1)

  In December 2, I deleted the database by mistake. The boss was so upset that I would recover the database within 30 minutes. In a hurry, I wrote a stored procedure, this method is applicable when the table is deleted on the day of restoration

Steps:1. Export data files from mysql Select sender, imsi, random_code, date_format (token_create_time, '% Y % m % d % H % I % s'), date_format (last_login_time, '% Y % m % d % H % I % s'), 1 as statusFrom tb_sms_token where last_login_time is not

Important: cursors are inefficient for large data volumes. Important:1. cursor attributes2. Current of cursor Current record  1. cursor: the cursor is the result set after select. We can use the cursor to assign each entry of the result set to the

I. Analysis Function syntax FUNCTION_NAME ( ,...) OVER ( )   1. FUNCTION_NAME ( ,...) The purpose of each analysis function is described later. 2. OVER keyword Over is just a keyword. It is an analysis function. 3. PARTITION clause The condition

Author: runming 2012-2-1 QQ: 226399587 http://blog.csdn.net/runming918 Difference between Purge and drop:The new flashback drop feature provided by Oracle 10g provides the flashback drop feature to speed up recovery of user error operations. In

Oracle OER 7451 in Load Indicator: Error Code = OSD-04500: illegal option specified descriptionOperating System: win7 64-bitOracle: 11gR2 32-bit However, the following errors occur continuously in the alert log:Mon Feb 06 14:38:22 2012Oer7451 in

1. Introduction to shared pool: The location, parts, and functions of the Shared Pool; Ii. Set and view the shared pool size: In 9i, we use the Shared_pool_size parameter to set the size of the Shared Pool. Let's talk about the setting in 10 Gb. In 9

1. Create oracle users and tablespaces in Windows-- Create a data table spaceCreate tablespace oras_data -- Name of the tablespaceLoggingDatafile 'd: \ oracle \ product \ 10.1.0 \ oradata \ oras_data.dbf '-- storage of the tablespace file spaceSize 3

SQL/PLUS Run CommandAppend text;Replace text Change/old text/new textDELETE command DEL n --- Delete rowDelete buffer clear buffer -- delete all contents of the BUFFERAdd a statement INPUT textDisplay the content in the buffer LIST [n/LAST] list

1. Error description:Each generated sqlloder file is in good condition and has the same permissions, but an error is reported when importing the oracle database. The error is:SQL * Loader-704: Internal error: ulconnect: OCIServerAttach [0]ORA-12154:

Restrictions on oracle user logon failures"FAILED_LOGIN_ATTEMPTS" is used to configure the maximum number of consecutive password input errors. If this value is exceeded, the account is locked. 1. Run the following command to query the value of

Scenario: Concurrent request A reduces inventory items not submitted query inventory not changed request B first judge whether inventory is sufficient A not submitted, inventory is sufficient and execution is also set up to reduce inventory. in fact,

After the tablespace is deleted, the total number of "ORA-01219" errors reported after oracle is restarted is resolved as follows:1. running input: sqlplus/nolog 2. log On as sysdba with the "connect sys/password" as sysdba 3. run alter database

Sort BY Chinese pinyin initials and obtain the Chinese pinyin initials. Introduction: sort BY Chinese Initials, strokes, and radicals. [NLSSORT]: 1) SELECT * FROM T_TABLE order by nlssort (NAME, 'nls _ SORT = SCHINESE_PINYIN_M '); 2) SELECT * FROM T_

Sometimes Oracle databases cannot use indexes. There are many reasons for this phenomenon. How can we locate it? This article mainly introduces this part.First, determine the optimization mode in which the database runs. The corresponding parameter

1. group function usage rules: Group functions in mysql can be used at will in select statements. However, if a group function exists in the query statement in oracle, other column names must have been processed by group functions, or the column in

ORA-01103 error parsing 1, Environment Introduction: this is a test library, I Will parameter files, control files, data files all deleted after doing data recovery, but I restored the control file and parameter file back, but the database but how

Create or replace trigger emp -- before indicates the trigger before the operation -- after indicates the trigger after the operation -- up to 12 triggers can be created for each table -- before inset www.2cto.com -- before insert for each row --

ORA-01422 and ORA-01403 error fix AFTER adding a 'after LOGON database' trigger, the following error snippets are found in the log: 1ORA-00604: recursive SQL Level 1 error 2ORA-01422: the actual number of returned rows exceeds the number of