Oracle

Today, when the project starts to access a database, it appearsORA-12505, Tns:listener does not currently know of SID given in Connect Desc.Look back, my database is configured as:Driverclassname=oracle.jdbc.driver.oracledriverurl=jdbc:oracle:thin:@1

A DML lock, also called a data lock, is used to ensure that data is complete when multiuser data is manipulated. DML locks prevent conflicting DML and DDL operations from occurring at the same time.DML locks have row locks,tx and table locks (table

The following is a practical use of the timer in the work, add some comments posted.Simple four steps, you can use the copy directly.--Create a stored procedure create or replace Procedure Pro_nianjia is the Begin update bo_ehr_archive set kxnjxss= (

Oracle Analytic function--listagg Chapter(1) Use Listagg to merge multiple rows of data into one lineExample table:Select from Order by Deptno, enameSuppose there is a requirement that the employee names of the same department in the EMP table be

When the amount of data in the table is increasing, the query data slows down and the performance of the application degrades, so you should consider partitioning the table. After the table is partitioned, the logical table is still a complete table,

1, commonly used functions are divided into five major categories: character functions, numbers and date functions, numeric functions, conversion functions, mixed functions 2. Character functions Character functions are primarily used to modify

Oracle Study case-install Oracle kernel parameter configurationIn Linux, before installing Oracle, one of the key points in the system is to modify the kernel parameters, in addition to checking that the hardware and software of the operating

For complex where condition combinations, where contains multiple indexed fields, consider the use of if statements to discuss the situation;At the same time, remove unnecessary external parameter conditions, reduce complexity, in order to use

1. Create a sequence --Create sequence Create sequence Innerid MinValue 1 MaxValue 99999999999999 Start with 1 Increment by 1 Cache 20 Order 2.--innerid.currval refers to the current sequence

Every time is silly to BASHRC inside write environment variable, feel not wayward. So, after reading this book to understand/etc/oratab this east, refer to the book also wrote a script to set the Oracle environment variable.Create Oraset under/etc/,

1)---The use of cursors with parameters;DeclareCURSOR stock_cur (symbol_in VARCHAR2) isSELECT * from RATE_COMBINE_NR nr WHERE nr.combine_no=symbol_in;Stock_info Stock_cur%rowtype;BeginOPEN stock_cur (' G600000001 '); --Open the cursor;LoopFETCH

Grammar:SELECT * FROM Some_table[Where Condition 1]Connect by [Condition 2]Start with [condition 3];The order in which the connect by and start with statements is placed does not affect the results of the query, [WHERE Condition 1] may not be

Since the current notebook is mostly 64-bit window7 system, however plsql_developer no 64-bit, which caused the trouble of our connection, here teaches you how to connect win7_oracle11g_64 bit to 32 bit plsql_developer.I have practiced many times,

Explore Oracle's database Upgrade nine12.1.0.1 Update 12.1.0.2First, check the current database version and System Information[[email protected] ~]$ lsb_release-alsb Version:: Core-4.0-amd64:core-4.0-ia32:core-4.0-noarch: GRAPHICS-4.0-AMD64:GRAPHICS-

The reason for this problem is that "run with administrator rights" is used when you run the batch process. If the direct double-click Run is no problem.What if I want to run with administrator privileges?The reason for this error is that the

1. Randomly take records from the table SELECT * FROM (SELECT * from staff ORDER by Dbms_random.random)Where RowNum To randomly fetch 3 records from the staff table 2. Generate Random Numbers SELECT Dbms_random. RANDOM from DUAL;produce a random

1-The SID of the imported database, if not definedExport Oracle_sid=database 2-Connect to the database with operating system authentication[Email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Production on Mon Dec 1 17:38:02

Rollup and cube of Oralce advanced SQLIn oracle SQL query, oracle provides some advanced functions to simplify SQL query statements and improve query performance. The following describes the usage and difference of rollup and cube.1. rollupRollup

Oracle performance optimization operation 8: Use HINT to forcibly specify an index When the ORACLE optimizer cannot use a reasonable index, the HINT is used to forcibly specify the index. In the example of "oracle Performance Optimization

Create your own oracle interpretation plan and oracle interpretation plan   1. Explain the plan When an explain plan is used to generate an expected execution plan for a query, the output includes the following: Each table accessed by SQL; Method