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 :.

I think everyone is familiar with the use of the alter database open resetlogs command of ORACLE_RESETLOGS command. Have you ever wondered why this resetlogs option should be used? When will it be used? What is its mechanism? What are their roles?

ORACLE array definition Fixed Array www.2cto.com declare type type_array is varray (10) of varchar2 (20); -- one-dimensional array, string type var_array type_array: = type_array ('ggs ', 'jforward', 'wsb ', 'csl', 'dd', 'bb'); begin for I in 1 ..

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

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 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

Processing of Oracle string segmentation 1. create or replace type t_ret_table is table of varchar2 (20); 2. use a custom function to implement 1. Use the function to return an array. using create or replace function f_split_string (var_str in

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

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

Use the SQL code www.2cto.com, such as the Oracle _ TABLE name_field name_comment, to view all the tables in the ORACLE database: SELECT table_name FROM user_tables; -- view all the tables of all users in the ORACLE database select user, table_name

Three Common oracle functions TRIM, TRUNC, and DECODE are used. Today, three functions TRIM, TRUNC, and DECODE are met. The experience is recorded for future reference. 1. TRIM function: used to remove spaces at the beginning and end of a string

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 parses xml strings using stored procedures. Background: There are two data tables in the database: t_xml and t_parse. The former is to store the main nodes in the xml document into the para_name field as strings, the latter is used to parse

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:

Explain the following example of an Oracle execution plan: www.2cto.com [html] SQL> explain plan for 2 select. name, B. name 3 from t1 a, t2 B 4 where. id = B. id 5 and. id = '1'; Explained. SQL> set lines 200 SQL> set pagesize 0 SQL> select * from

Analysis of OCP question _ 043: flashback logs to flash back to the database, oracle needs to record the before image of the data block to a new log. This log is named flashback database logs flash back log, and Flash Back log is always recycled,

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