Oracle

*The 1,java Web project can be deployed to Tomcat, or it can be mapped to a project's actual directory by configuring Server.xml, so there is no project under Tomcat's WebApps directory, the following is the configuration in Server.xmlContextPath= "/

--Create a stored procedureCREATE OR REPLACE PROCEDURE xxxxxxxxxxx_p (--parameter in represents the input parameter, The--out represents an output parameter, and the type can use a legitimate type in any

First open the Control Panel-Administrative Tools-Data source (ODBC), add a data source driver for Oracle's user DNS, and fill in data source, Server Name, user, test for connectivity.Then, open the Access database, select the table that you want to

1, has been started/not loaded (Nomount). Launches the instance, but does not mount the database.This mode is used to recreate the control file, restore the control file, or recreate the database.2, Loaded (Mount). Mount the database without opening

1. Basic grammar Create or replace procedure Update_emp_sal(Name in Out type,Name in Out type, ...) isBeginEnd Update_emp_sal; 2. Write a simple example to modify the Ename field of the EMP table Create or replace procedure Update_emp(V_empno

RowNumber is a query of the dataset after adding a pseudo-column (continuous) to use it to produce a page based on an Oracle database, with statements similar to formulas that are directly applied as follows:Select * from (Select from

Today Nagios Monitor discovers an Oracle database server is heavily swap-out, causing some Nagios monitoring item timeout alarms Viewing the server, the swap space is set to 32G, 19G is used, the usage is very high, and the vmstat shows that Si is

Decodedecode (condition, value 1, translation value 1, value 2, translation value 2,..., default) The function is the same as the If...else If...else in the program.NVLformat: NVL (string1, Replace_with)function: If string1 is null, the NVL

Decode (expression, search_1, result_1)Returns result_1 if expression results =search_1 results, similar to if elseDecode (expression, search_1, Result_1, search_2, result_2)Decode (expression, search_1, Result_1, search_2, Result_2, ....., Search_n,

　　Debugging the code today and discovering a bug that uses RowNum's Between......and usage in Oracle in a paged query is summarized as follows:Reference: http://blog.csdn.net/lg312200538/article/details/4587455For Oracle's rownum problem, a lot of

Oracle's data import and export must be created in two locations for the same user to be fully imported (local import of new databases requires Rebuild permissions). So the import will have to follow the following steps:Assume that the server-side

Oracle Advanced Query 1. eliminate duplicate rowsIf several rows are the same in the Oracle query results, you can use DISTINCT to remove duplicate rows. Code Demonstration: Remove duplicate rows in DISTINCT SQL> SELECT DISTINCT DEPTNO FROM EMP;

Sequential (learning notes), sequential learning notesFunctions of Sequences  In many databases, users are provided with a Sequence of auto-increment columns, which can be automatically numbered based on specified rules. Complete Sequence creation

Oracle string row column (string aggregation technology) 1 String Aggregation Techniques String Aggregation technology On occasion it is necessary to aggregate data from a number ofrows into a single row, giving a list of data associated with

Oracle Partition Table Technology (PartitionedTables)    Since Oracle 8 (around 1997), the concept of Partition Table & partition index (Partitioned Tables & Indexes) has been introduced to adjust large Tables and large Indexes to improve

Trigger 1 (learning notes), trigger (learning notes) Syntax: CREATE [or replace] TRIGGER trigger_name: CREATE a TRIGGER and set the TRIGGER name. If or replace is selected, the TRIGGER is replaced if it already exists. [BEFOR | AFTER]: refers

Two forms of ORA-01502oracle database index In the current project, when we run the batch, there is an SP always reports the error "ORA-01502: index 'wbill _ 102. PK_A_NOTWEB_ACT_PROVINCE_M 'or partition of such index is in unusable state ". The

How to modify the username and password of an oracle Database Change the user name and password of the oracle database (Linux is used as an example). For more information, see. I. Preparations before modification: Use ssh to connect to the server as

Create a tablespace (learning notes) and create learning notes Create a tablespace: Generally, it is created by the Administrator and logged on as the administrator during creation. Table space name: prefix with TBS _. You can also customize the

Oracle performance optimization operation 12: Merge multiple scans with Case statements We often have to calculate different aggregation based on multiple sets of data tables. For example, the following example uses three independent queries: