Oracle

Oracle's ROWID can be divided into two types: Physical ROWID and logical ROWID. The index organization table uses the logical ROWID, and other types of tables use the physical ROWID. SQL> create table test_rowid (id number, row_id rowid );  The

Tips for SQL Developer 1. Set the logon password of plsql developer by default. Choose 'tools '--> 'preferences'. In the 'oracle 'column of the window, select the 'store with password' option in 'logon History,Log out of PLSQL and select the

Batch deletion of ORACLE table stored procedures often requires deletion of some tables during database management, but manual deletion is time-consuming and laborious. You can modify and use the following stored procedures according to the

Configure tnsnames in oracle # tnsnames. ora Network Configuration File: C: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. MYSCOTT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =

Common oracle and sqlserver functions: decode (c1, A, y1, B, y2 ....) // c1 is the prerequisite, A is the comparison object, y1 is the result object, B is the comparison object, and y2 is the result object. Equivalent to case when (..) and (..) then

Advanced usage of group by in oracle simple group by usage select c1, sum (c2) from t1where t1 <> 'test' group by c1having sum (c2)> 100; www.2cto.com rollup (multiple columns)-volume summary, from the last summary field to the volume summary, until

Postgres Formatting Function provides a set of effective tools for various data types (date/time, int, float, numeric) convert to formatted string, and convert from formatted string to original data type in turn. Note: The second parameter of all

ORACLE 11g Automatic Memory Management: in oracle 11g, the SGA and PGA components can be automatically allocated based on the workload by using the memory_target parameter. Oracle recommends using automatic memory management to simplify memory

Solution for accidental deletion of oracle log files: oracle log files are deleted (mainly for those software such as 360 security guard, QQ computer manager, and Kingsoft guard that use logs as garbage, when using them, be careful, or remove the

Create a simple trigger exercise environment in Oracle: PLSQL Developer 7.1.5 + Oracle 11.2.0 problem: Use PLSQL Developer in Oracle to create a simple trigger. Solution: Step 1: Find the Triggers in the My Objects expanded list on the left of PLSQL

Resolving oracle 11g reporting ORA-01034 and ORA-27101 errors the database version I locally installed is ORACLE 11G R2, when connecting with plsql, the following ora-12514 error is reported:However, when using sqlplus in cmd to connect a user

Redo write is triggered in four cases. 1. When LGWR is idle, it checks every three seconds to see if any data is written to redelog from redo buffer. If yes, A background process automatically writes data to it. 2. When a process needs to allocate

1. Oracle ROLLUP and CUBE usage in addition to the most basic syntax, Oracle group by statements also support ROLLUP and CUBE statements. For Group by ROLLUP (A, B, C), group by is performed on (A, B, C), and then group by is performed on (A, B,

Preparation: Modify the startup Item/etc/inittab rpm-qa | grep binutils. If not, install: rpm-ivh *. create a group at rpm www.2cto.com. The user groupadd oinstallgroupadd dbamkdir-p/u01useradd-g oinstall-G dba-d/u01/oracle oraclepasswd

Navicate9.0 + connection to Oracle 11g error Description: When the connected host is localhost, this port has been monitored, but it is actually already monitored,The ORA-12737 set CHS16GBK error occurs when you change localhost to the current IP

Resolution of ora-01779 errors when optimizing update, given that update from is more efficient, but because oracle checks key values, a ora-01779 error is reported, by using BYPASS_UJVC to skip the Oracle key determination, the same effect is

ORA-00205: error in identifying control file, check alert log for more info Problem Environment: oracle10gR2 solaris10 operation: the following command is directly executed without creating pfile1 SQL> create pfile from spfile; 2 SQL> shutdown

Oracle built-in IO test package dbms_resource_manager.CALIBRATE_IO oracle 11g started, launched the built-in IO test package, the principle is basically the same as the above mentioned Orion tool. Here is an example of specific use SQL> select group_

How to uninstall oracle: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services; 2. Start-> Program-> Oracle-OraDb10g_home1> Oracle Installation Products-> Universal Installer uninstalls all

Create a tablespace in oracle, user and import/export // create a temporary tablespace create temporary tablespace test_temp tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf 'size 32 m www.2cto.com autoextend on next