Oracle

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

The following error is reported during the installation of ORACLE 11G Due to configuration reasons:After following the installation prompt, when PL/SQL DEVELOPER is enabled to connect to the database, the ORA-12514: TNS: The Listener cannot identify

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

If PLSQL select into is null, the following error is returned: select column into t_prop In the stored procedure... If no value is found, an error is returned. The processing method is to use an aggregate function, for example, [SQL] create or

Version: 11g port: 1521 Installation File:/install/linux.x64_11gR2_database_1of2.zip, linux.x64_11gr2_database204 f2.zip www.2cto.com installation process: the installation process is centos without a graphical interface. Tool used: ssh + xmanager.

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

View oracle tablespace usage 1 select 2 B. file_id File ID, 3 B. tablespace_name tablespace name, 4 B. bytes/1024/1024 | 'mb' number of bytes, 5 (B. bytes-sum (nvl (. bytes, 0)/1024/1024 | 'mb' used, 6 sum (nvl (. bytes, 0)/1024/1024 | 'mb'

Important Oracle SQL statements commonly used at work 1. view the default tablespace of the current user: SQL> select username, default_tablespace from user_users; 2. view the role of the current user: SQL> select * from user_role_privs; 3. view the

Common Oracle HINT usage 1. /* + ALL_ROWS */indicates to select the overhead-Based Optimization Method for the statement block and obtain the optimal throughput to minimize resource consumption. example: SELECT/* + ALL + _ ROWS */EMP_NO, EMP_NAM,

Due to the lock mechanism, when execution of a DML or ddl SQL statement is blocked, you need to find out why the SQL statement is blocked. The following describes the common diagnostic methods: suppose there is A table: table t (id int primary key,

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,

OERR: ORA-12519 TNS: no appropriate service handler found client connection intermittent failure, error ORA-12519 Cause: the listener cocould not find any available service handlers that are appropriate for the client connection. action: Check the

Count (1), count (*), order by 1, 2, 3, 4, difference 1 to create NULL data; 2. Use the column name to COUNT and check result 3. Use 1 2 3 4 5 * to COUNT and check that all data is the same as all functions. www.2cto.com 4 order by 1 do use the

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 client PLSQL connection failure solution I wrote in my blog last week that the oracle client is connected to the server http://www.bkjia.com/database/201206/137699.html This article solves the troubles of installing on your own book. Www.2cto.

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