Oracle

DeclareCursor Cur_test is select Inte_param_inteuuid from Sjzx_interface_param Group by Inte_param_inteuuid; Declares a cursor cur_test, where inte_param_inteuuid is the data to which the cursor is queriedBeginFor the C in Cur_test Loop//Loop

Sql> Select COUNT (*) from V$session #当前的连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Select value from v$parameter where name = ' processes '--the maximum number of connections allowed for the databaseSql> Select

--oracle--There are three ways in a relational database: one-to-many, many-to-many--sql Statement Classification:--DQL (data Query Language): SELECT--DML (Data Manipulation language): Insert/update/delete/merge--DDL (data definition Language):

I. Oracle functional dependency and Paradigm theory 1. Function dependency1) Non-trivial dependencies: in the Relationship R (U), for subsets X and Y of U, if X->y,y does not belong to a subset of X, it is called X->y is a non-trivial dependency.2)

At work, it is found that Oracle does not provide a string cutting function, find a better way to cut on the internet, record:1. New data typeCREATE OR REPLACE TYPE str_split as TABLE of VARCHAR2 (500);2. New Cut functionCREATE OR REPLACE

1. Run the command with the Oracle User:dbca2. Go to the Configuration page3. Creating a Database4. Select the Custom database5. Configuration database name6. Cancel configuration management (see personal needs)7. Configure the database password8,

First, the same version number is guaranteed. Then know the administrative user and password of the system.1, import the same way as exported.EXP username/Password @ instance name File=d:\815.dmp full=yPauseExp Ecology/[email protected]

Oracle 11g exports less empty tablesWhen using the EXP command, there will be fewer tables, because in the 11g version if a table is empty, in order to save space, the default is not to allocate space for the table, in the export of the empty table

Original address:Https://www.cnblogs.com/hoobey/p/6010804.html #11g安装Https://www.cnblogs.com/qq1272850043/p/6377916.html #12c安装Monitoring configuration: listener= (DESCRIPTION = (address_list = = (protocol=tcp) (Host=. 1.104 ) (Port=1521 = (

Modifying table column names in Oracle, using SQL statements Operations on Fields Operation method Update Field Name ALTER TABLE table_name Rename column column_old to column_new; Add Field

Application system running, often need to perform some tasks regularly, such as: Regular update summary data, periodic update status data, etc., currently treesoft database management systemAdd "Scheduled Tasks" function, directly through the page

Ideas:Randomly sorts the values taken out first, and then randomly sorts the results of each fetchExamples are as follows:SELECT * FROM (select T.code fromtbizops_province t ORDER by Dbms_random. RANDOM ()) where rownum SELECT * FROM (select T.code

ObjectiveThe data in the table1 Conditional Expression 1.1 database universal conditional expressionGrammar:Case columnWhen column value 1 then show value 1When column value 2 then show value 2When column value 3 then show value 3ElseDefault

Because of the work required, the data needs to be imported to the Oracle database on the remote server through the local Oracle client. A lot of Oracle clients from CSDN are in Lite, missing imp.exe files, which makes it impossible to import data.

Reference Address: https://www.cnblogs.com/zhaideyou/articles/5845271.htmlAfter Oracle is installed, there is a default database in which we can create our own database, in addition to the default database.For beginners, to avoid trouble, you can

1, first find the operation record of the tableSELECT * from V$sqlarea a where a.sql_text like '%tb_acct_sysdate% ';2, find the sql_id corresponding to the UPDATE statement from the above recordSELECT * from V$sqltext A,v$sqlarea b where

(a) What is a constraintConstraint is a mandatory requirement at the table levelThere are five types of constraints: NOT null: Non-empty Unique: the only PRIMARY Key: Primary key FOREIGN Key: Foreign key Check: Checking

Don't say much, just go dry.1, query the current user to create the following table statementSelect Dbms_metadata.get_ddl (' TABLE ', ' ux_future ') from dual;2, query other users to create the following table statementSelect Dbms_metadata.get_ddl ('

When I first learned to create TABLE, I didn't notice it. You can specify a default value after learning. Then wrote the following statement:　　When I checked, I found out that the results were like this.I am wondering if there is, I clearly specify

Oracle 10g is slowly exiting, but there are also places to use. Let's take a look at the case here:Database 16:58 A large number of 4031, causing the database to be unusable, take the corresponding time of the AWRFound that the shared_pool has been