Oracle

The following describes how to debug a function. Other debugging operations are the same.1. Generally, there are two places to debug the program in pl/SQL Dev: 1). New-> test window: www.2cto.com2) Right-click the program to be debugged and choose

Full Learning Guide for pl/SQL 3 large loops 1 loop overview each loop consists of two parts: the loop boundary and the loop body. The cyclic boundary consists of pl/SQL reserved words. Code located outside the loop body should not know the internal

OracleDBConsoleorcl cannot be started _ solution to error code 2 run cmd as Administrator Enter command mode input: emctl start dbconsole www.2cto.com prompt: Environment variable ORACLE_SID not defined. please define it. enter set ORACLE_SID = ORCL

Today, I happened to find an oracle client graphical management and development tool. When I saw this interface, I found this tool online, after reading Baidu encyclopedia, I was surprised to find that this product was fully supported by many

In Oracle, using ADO objects to access and access ADO is short for Active Data objects. It is called ActiveX Data Objects. Using an ADO object, you can use an ODBC driver or an ole db connection string to access and access any database. Ole db is a

Summary of Oracle10g listener there are many reasons why Oracle 10g listener cannot be started. In this article, we will summarize the causes for listener failure, next let's take a look at this part. 1. ora-01034: Oracle not available, ora-27101:

Oracle distinguishes materialized views from tables before 9i at the beginning of 10g. Many functions do not distinguish between tables and materialized views. After 10g. Many features differentiate tables from materialized views. The common comment

WMSYS. the usage of the WM_CONCAT function is provided by the WMSYS. the following is an example of how the WM_CONCAT function can complete row-to-column conversion: 1. prepare data: SQL code create table testtable (id number, name varchar2 (30);

The usage of DBMS_ SQL in ORACLE is applicable to select operations. If dynamic SQL statements are used, perform the following steps: open cursor ---> parse ---> define column ---> excute ---> fetch rows ---> close cursor; perform the following

The Association of SQL tuning and shared pool structures introduces three types of computer resources that affect performance: Memory, CPU, and I/O. By adjusting SGA and PGA to make full use of physical MEMORY, making full use of CPU through

Oracle Data Pump: impdp and expdp 1. Create a logical directory. This command does not create a real directory in the operating system. It is best to create a directory as a system administrator. Create directory dpdata as '/opt'; 2. Check the

When debugging the Oracle EM service on the local machine, the following interface is often displayed: "the security certificate of this website is faulty ". You often directly click "continue to browse this website (not recommended)" to enter the

Oracle Regular Expression functions: regexp_like, regexp_substr, regexp_instr, regexp_replace SQL code Oracle can't do without these four functions: 1. Regexp_like 2. Regexp_substr 3. Regexp_instr 4. Regexp_replace www.2cto.com can be used to guess

Address oracle Database ora-00054: resource busy and acquire with NOWAIT specified error I found a midway card and then forcibly terminated pl/SQL developer after using the pl/SQL developer client to call the Stored Procedure for operations, oracle

Materialized View and task scheduling data synchronization 1. materialized view (materialized view) www.2cto.com create materialized view TEST_MATERIAL_VIEW (materialized view name) refresh force on demandstart WITHTO_DATE ('02-11-2012 14:24:59 ',

Oracle changes database character set encoding UTF8 first: connect sys/orcl as sysdba; www.2cto.com shutdown immediate; startup mount; alter session set SQL _trace = true; alter system enable restricted session; alter system set job_queue_processes =

The execution permission of oracle stored procedures is an essential tool in the database system. stored procedures are a set of SQL statements pre-compiled to implement a complex function. I will not talk about its advantages. Let's talk about the

After oracle changes the ip address, the orcale service cannot be started. Today, the virtual machine is configured with an ip address, so that the virtual machine and the host are in the same network segment, and then webservice is used

Flash back in oracle-recovering the accidentally deleted table in oracle is not directly deleted after the table is dropped, but saved in the recycle bin of the current user. (If the recycle bin is full, it will be cleared in the first-in-first-out

Oracle-commonly used monitoring SQL statement 1. monitoring instance waiting: select event, sum (decode (wait_time, 1) prev, sum (decode (wait_time, 0) curr, count (*) from v $ session_wait group by event order by 4; 2. contention for rollback