Paged Query format:SELECT * FROM(SELECT a.*, ROWNUM RNFrom (SELECT * from table_name) AWHERE ROWNUM )WHERE RN >= 21The most internal query, select * FROM table_name, represents the original query statement without paging. ROWNUM = 21 control the
The maximum number of Oracle connections is set to 150, and sometimes the program runs off a little. Of course 150 may not be set enough, but usually the headache is to quickly restore the database services, the best way is to restart the database,
First, the table space is described as followstemporary table Space : is in the large data volume sorting, the group operation is used, normal these are done in memory, but in the case of big data processing, memory is not enough to use the
MySQL timed script (event), Oracle-like job I have 2 tables: Tb_push_data and Tb_push_data_log now need to back up tb_push_data eligible data to the table at intervals Tb_push_data _log www.2cto.com----------------------------------------------------
Select t.recd_id from (select recd_id, ROWNUM RN from RT_TICKETS_BIS_RECD) t where T.rn = (select round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD); 1) Select Round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD
Create tablespace user1 datefile "size 20M//creating a table space named User1Autoextend scalability of on//data filesAutoextend off//offAutoextend on next 5m//Specify the growth range of the data fileAutoextend on next 5m maxsize 500MTo see if the
After the Oracle database is started, you can view all the parameters used by the Oracle database by using the select * from V$parameter statement . For Oracle 's parameter files, it is divided into spfile binaries and pfile text files, and now the
1. Create a TriggerCreate or Replace Trigger trigger_name_xxxAfter delete or update or insertOn table_name_yyy for each row[Declare var_name_zzz TYPE_NAME_TTT;]BeginIf Delete Then.....;End If;If Update then.....;End If;If Insert Then.....;End If;End2
#1, select the most efficient table name order The Oracle parser always processes the table from the back of the from right to left, so the from rightmost table will be treated as the driver table precedence, and when there are multiple table
View the current user's table space[SQL]View Plaincopy
Select Username,default_tablespace from user_users;
Modify the user default table space[SQL]View Plaincopy
Alter user username default tablespace new table space;
With as syntax – for an alias with the TMP as (SELECT * from Tb_name)– for multiple aliases with the TMP as (SELECT * from Tb_name), TMP2 as (SELECT * from Tb_name2), Tmp3 as (SELECT * from Tb_name3), ...
123456789
--相当于建了个e临时表with
1. According to rowID to divideSELECT * from T_xiaoxi where rowID in (the Select Rid from (select RowNum rn,rid from, select rowID rid,cid from t_xiaoxi ORDER BY cid Desc) where rownum9980) Order BY cid Desc; execution time 0.03 seconds 2.
Oralcesql creates calendar information for a specified period of time
The creation start time is 2010 and the end time is 2100.
Create table temp_calendar as selectMin (to_char (day, 'yyyymm') month,
To_char (min (decode (weekday, 1, day), 'dd') w_7,
Oracle session and connection Optimization
1. Modify the Oracle session and maximum number of connections
1. view the maximum number of connections
SQL> show parameter processes;
NAME TYPE VALUE--------------------------------------------------------
Oracle backup terminology
Terms
Full database backup: includes all data files and at least one control file (remember that all control files in the database are the same)
Partial database backup: It may include zero or multiple tablespaces, zero or
Oracle data file structure
Oracle data structures are divided into physical and logical structures.
Physical Structure: data block of the Operating System-> data file datafiles
Logical Structure: Minimum database block --> extent -->
REGEXP_SUBSTR function (convert) and oraclesubstr function in Oracle
REGEXP_SUBSTR function in Oracle Instructions for using the REGEXP_SUBSTR function in Oracle: The questions are as follows:In oracle, a statement is used to split '17, 20,23' into
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
Query the size of a table with a lob field in the Oracle databaseNote: Because the lob field has an independent lob segment for storage, for a table with a lob field, you cannot only query dba_segments.The following scripts are from:How to Compute
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service