Oracle

TYPE Type_cursor is REF cursor[RETURN Return_type];Cursor_name Type_cursor;Type type_cursor: Defines the types of variables such as I in int iIs ref CURSOR: Equivalent to a data type, but a data type that refers to a cursor. type int iThis variable

Oracle 10g Advanced Replication instances (multi-agent replication)Objective:Configured three times, two is one way. The last time is finally two-way. Also a little bit of success in the joy. Joy? Joy does not. It's such a simple thing that I feel

1,sql Server sequence creation and useBeginif EXISTS (SELECT * from sysobjects WHERE name = ' event_seq ') DROP SEQUENCE event_seqendcreate SEQUENCE Event_seqminva LUE 1MAXVALUE 999999999999999999START with 1INCREMENT by 1CACHE 20; --Goselect Next

The system does not have much time to write blog, but also want to always write to insist, it is nothing to write down the accumulated knowledge points#ORACLE#jdbc. Driver=oracle.jdbc.driver.oracledriver#jdbc. Url=jdbc:oracle:thin: @IP: Port:

Today, I saw someone write a custom aggregation function, so mindedly want to understand, on the Internet to find information. Introduction to custom aggregate function custom aggregation function interfacesOracle provides a number of pre-defined

When I recently used oracle9i, I encountered problems with database backup and recovery, which are often related to the use of exp and IMP commands. For the problems encountered, a simple summary.The background of the problem is the need to import

1 , format the SQL Plus interface:L Overall Settings:SET Number -- set Number of rows SET Number -- set Number of columnsL single-Column settings:ColumnName for Numeber -- character class Char,varchar2, example: A10 ColumnName for 9... 9 --

1. Create/* Step 1th: Create Tablespace */Create Tablespace XybiDataFile ' E:\oracle\oradata\zzxe\xybi_d01 ' size 100M;/* Step 2nd: Create a temporary tablespace */Create temporary tablespace xybi_tempTempfile ' E:\oracle\oradata\zzxe\xybi_t01 '

Oracle cursors Use the full solutionThis document contains almost every aspect of Oracle cursor use, and all passes the test--Cursor cursor_name is select_statement--For loop cursors--(1) Defining cursors--(2) Defining a cursor variable--(3) using

SQLServer2008 new linked server for OracleA view of Oracle 10g has recently been used in SQLServer2008 to make use of Oracle-provided views in SQL Server by establishing linked servers.    Premise: SQL Server requires client installation of Oracle 1.

The basic syntax of Wm_concat Select Proj_id,max (scale_valus) as Scale_valusFrom (select a.proj_id,Wm_concat (A.scale_valu) over (partition by a.proj_id ORDER by A.ym) as Sccale_valusFrom S_proj_ees_scale Awhere a.ym between ' 201601 ' and ' 20

--table backups in the Oracle database:--BACKUP statement: After the backup, you can delete all the data sources for this table, but then someone will manipulate the table's data, but remember to restore the data table after the operation is

Here, let's move on to the question left in section 2.6: What if the string to be queried contains "_" or "%"? Start today's study.2.7 How to use escaped (escape) operatorsThis task can be accomplished with an escape keyword. In order to practice,

1, check whether to start the flash back deleteSQL> show Parameter recyclebin; NAME TYPE VALUE--------------------------------------------------------------------- --------recyclebin

--CREATE TABLE SpaceCreatetablespace imarkdatafile'E:\oracle\product\10.2.0\oradata\orcl\imark.dbf'size 500Mautoextend on Next100M MaxSize Unlimited logging extent management local AutoallocatesegmentSpaceManagement auto;--Create userCreate

1: Common functionsTo_date () function to convert a string to a date formatSelect To_date (' 2015-09-12 ', ' YYYY-MM-DD ') from dual; --The subsequent date format to match the previous conversionTo_number () function to convert a string to a number

When the data in the table does not need to be, you should delete the data and free up the space occupied; Delete the data in the table has delete and truncate two kinds of ways, the following are described separately;One, DELETE statement(1)

--oracle built-in functions: single-line functions, aggregate functions--1. Absolute value, take redundancy, judge the data positive and negative function,SELECT ABS (+), ABS ( -100), ABS (' + ') from DUAL;SELECT mod (5,2) mod (8/3,5), mod (' Ten ',

Sequence: is a database object provided by Oacle to produce a series of unique numbers.L automatically provide a unique valueL Shared objectsL mainly used to provide primary key valueL Loading sequence values into memory improves access efficiencyTo

Oracle custom exception 1. The error box is displayed: Sample Code: Declare v_count number; begin select count (*) into v_count from dept; if v_count Execution result:   2. console display: Sample Code: Declare v_count number; my_exp