Oracle

Oracle single row function classification single row function is mainly divided into five types: character (VARCHAR2) function, NUMBER function, DATE function,The conversion function www.2cto.com is mainly used to operate string data, for example :.

Using (dynamic statement) [SQL] -- create test table create table t01 (id integer, name varchar2 (10); www.2cto.com -- create test data insert into t01 (id, name) values (1, 'A'); insert into t01 (id, name) values (2, 'B'); insert into t01 (id, name)

Periodically execute Oracle job tasks to create a data table and create a process so that the process runs once a minute. 1) create a table. SQL> create table test (mydate date); Table created. (2) create a custom process. Www.2cto.com SQL> create

Oracle uses recursive performance prompts that when you use start with connect by nocycle prior for Recursive data search, www.2cto.com, then the performance of the following two sections of code must be significantly different. Please note that the

An in-depth understanding of Oracle table (2): An example of what drives a table is made by comparing two dictionaries: a dictionary with an index directory (dict a) and a dictionary with no (dict B) how do you compare the similarities and

Oracle knowledge-tracking SQL statements 1. First, find the session information SID of a machine you want to track, SERIAL # select SID, SERIAL # from v $ session where lower (terminal) like '% yf07 %'; www.2cto.com 2. Enable tracking: exec

In oracle, the v $ session_longops view describes the operations that DBAs often need to monitor databases that take a lot of time, such as backup recovery, collection of statistics, and sorting. This view mainly shows the status of database

Oracle Database automatic backup compression below bat is the bat script for automatic backup of oracle Database under window, which can be used to back up the. dmp file of the database and compress it. Set a scheduled task to be executed every

There are a lot of learning materials on the Internet. Despite my determination to study oralce, there are still countless learning materials I can find. The popular fully open-source video "Han shunping-playing oralce" is almost done, take notes

Today, due to the working relationship, we need to design a backup solution for ORACLE. Because the database is large, it is not suitableThe daily backup is saved, So we designed the overwriting backup for 7 files every week. The specific steps are

Oracle custom function accumulation 1. Determine if it is a number www.2cto.com create or replace function IS_NUMBER (string VARCHAR2) return integer is begin if (LENGTH (TRIM (TRANSLATE (string, '+ -. 0123456789 ', '') is null) then return 1; else

1 create Database type SQL code CREATE or replace type STR_SPLIT as table of varchar2 (50) 2 create function www.2cto.com SQL code CREATE OR REPLACE FUNCTION SPLITSTR (P_STRINGIN VARCHAR2, P_DELIMITER IN VARCHAR2) RETURN STR_SPLIT pipelined is

Oracle re-build EM: The oracle11gx64 on wi7x64 cannot be accessed by IE8, and I re-build EM, but it still cannot. After restarting the OracleDBConsoleorcl service, I can use Firefox to access the address https: // hostname: 1158/emAfter the host

Finding the query statements "V $ SQLAREA" and "V $ SQL" with the worst performance in Oracle databases is a very useful view, you can find the SQL statements that require optimization in the worst execution efficiency. The value in the "DISK_READS"

With the continuous development of software technology, system performance becomes more and more important.System performance is measured by system response time and concurrency.There are two possible causes for poor SQL statement performance:1.

Oracle parameter-based cursor declare cursor mysor (proname varchar2) isselect * from sys_pro_monitor where pro_name = proname; c_row mysor % rowtype; begin open mysor ('Pro _ RPT_KPI '); loop fetch mysor into c_row; exit when mysor % notfound; dbms_

Oracle creation trigger call with parameters stored procedure Background: when inserting data into a data table, the defined stored procedure is called to parse the inserted data in xml format. The Stored Procedure contains parameters. solution:

Oracle online redo log recovery (redo log) Non-current online log File fault recovery www.2cto.com 1. ORA-00313 error when starting the database. ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1:

Oracle Data Guard, RAC, Data Gurad, and Stream are three tools in the Oracle high availability system. Each tool can be used independently or in combination. They have different focuses and different application scenarios. RAC is designed to solve

When you uninstall oracle10g from a cainiao oracle Database Under win7 64bit, an error is reported. today, I installed oracle 10 GB on Windows 7 and found an error during uninstallation. The error is as follows: I installed the 32-bit Oracle10.2.0.1.