Oracle

In normal project development, the paging stored procedure uses a large number of stored procedures. top is often used in the SQL Server paging stored procedure, and RowNum is often used in Oracle. Now, there is a UserInfo table, where one field is

Batch File [backup. bat] p.s: Never name this batch file exp. bat smartly; otherwise ......, If you are interested, try it.@ Echo offREM ============================================== ====================REM backup data under the rsdlouter account

Expdp oracle exports the backup and deletes the backup seven days ago. The backup is retained on the first day of each month and every Monday. Use oracle expdp to export the database and delete the backup from the past seven days. However, the

SQL1:Copy codeThe Code is as follows:-- 1. view the table space name and size.SELECT t. tablespace_name, round (SUM (bytes/(1024*1024), 0) ts_sizeFROM dba_tablespaces t, dba_data_files dWHERE t. tablespace_name = d. tablespace_nameGroup by t.

In principle, the Recycle Bin is a data dictionary table that stores information about database objects deleted by users. Objects deleted by a user are not deleted by the database and still occupy space. Unless the user Purge manually or the

1. query the number of connections to the current process of the database:Copy codeThe Code is as follows:Select count (*) from v $ process; 2. view the number of connections in the current session of the database:Copy codeThe Code is as

Oracle provides two listener service registration methods: Dynamic and Static. The status of the dynamically registered service in lsnrctl status is ready, and the static service is unknown.In versions earlier than 11g2, the listener is configured

If Oracle has two users A and B, if A wants to access the table owned by B, the statement should be:Copy codeThe Code is as follows:SELECT * from B. TABLENAME. I want to ask, can I modify the Oracle settings to change the language in which A

Copy codeThe Code is as follows:-- Created on 2010/11/04 by WANGNANDeclare-- Local variables hereI integer;TYPE t_table is table of VARCHAR2 (10) index by VARCHAR2 (2 );V_t_table t_table;TYPE t_pg3 is table of asis. PG3_AGENTCD_CONVERSION %

The following error is always reported when you manually configure the EM of Oracle11g:WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violatedORA-06512: at "SYSMAN. EMD_LOADER", line4986ORA-06512: atline1.No solution was found

Applicability:When oracle sorts the query results, the column to be sorted has a null value, and the NULL value must be specified at the beginning or end of the column.Keywords: Nulls First; Nulls LastDefault Value: the default value of null is the

To sum up the basic knowledge of oracle, oracle is composed of instances and databases. The structure is as follows: Oracle databases consist of instances and databases: * A database consists of data files (including oracle Data, indexes, table

When deleting a user in Oracle, the following statement is prompted: ORACLE cannot delete the current connected user:SQL codeSQL>Copy codeThe Code is as follows: select username, sid, serial # from v $ session;Username sid serial #-------------------

In this article, the B-tree (B-tree) Hash k-d tree (k-d tree) Point Quadtree (Point Quadtree) This article describes the structure of Oracle indexes. You can understand the underlying data structure of Oracle indexes to better understand the

1. query the names of products with prices higher than the average price:SELECT item_name FROM ebsp. product_market_price WHERE item_price> (select avg (item_price) FROM ebsp. product_market_price2. oracle9i or a later version allows you to insert

Total combination set:Group by with rollup/cubeGrouping setsSubqueries are executed in the following ways: Standard subqueries and associated subqueriesStandard subquery: Nested subqueryScalar Value QueryCase with thenUse exits to querySelect

Oracle client NLS_LANG settingsOracleWindowsMicrosoftUnixBash1. Composition of the NLS_LANG ParameterThe NLS_LANG parameter consists of the following parts:NLS_LANG = _. The meanings of NLS_LANG are as follows:LANGUAGE:-Oracle message

1. intersect is the intersection of multiple query results;2. query the SQL statements recorded in the table within two basic periods;Select * from shengjibiao t where t. createtime between to_date ('2017-7-26 ', 'yyyy-MM-dd') and to_date ('2017-7-29

Author: peace. zhaoExample of cursor if andCreate or replace procedure peace_ifIsCursor var_c is select * from grade;BeginFor temp in var_c loopIf temp. course_name = 'OS' thenDbms_output.put_line ('stu _ name = '| temp. stu_name );Elsif temp.

Mathematical functions1. Absolute ValueS: select abs (-1) valueO: select abs (-1) value from dual2. INTEGER (large)S: select ceiling (-1.001) valueO: select ceil (-1.001) value from dual3. Round (small)S: select floor (-1.001) valueO: select floor (-