Oracle

INSTR Usage:INSTR (string,substring,position,ocurrence)Explanation: string: source stringSubString: substring to findPosition: The start position of the lookup. If the starting position is 0, the return value is 0, and when the starting position is

Tom the Great God wrote a to view the use of Oracle database object space.The following shows how to use:– Tool SourceCREATE ORREPLACEprocedure show_space (p_segname in VARCHAR2,

Test Code1 withView_test as (2 3 Select 'A' asId'X' asP_ID,'C' asC_ID,'1' asInd_ex fromDUAL4 5 UNION6 Select 'C' asId'A' asP_ID,'B' asC_ID,'1_1' asInd_ex fromDUAL7 UNION8 Select 'B' asId'C' asP_ID,'A' asC_ID,

Many of these days work around Oracle functions, and here's a summary of the functions that have been used in the work these days. In fact, it is not a summary, is to use these days for Oracle to make a simple list of knowledge. Returning data

Record the oracle12c in the process of learning.ORACLE12C new Features: http://www.cnblogs.com/kerrycode/p/3386917.html--Create a temporary table spaceCREATE Temporary tablespace admin_tempTempfile ' file absolute path '//such as: '

1. Create a new user test on the local database and grant the following basic permissions (try not to authorize more, such as local permissions larger than remote, will cause the export failed, depressed!). ):Grant connect to test;Grant resource to

After successfully installing Oracle 11g in accordance with the methods in Windows 7 64-bit installation of Oracle 11g R2, there are 7 services that have the meanings of seven services, respectively:1. Oracle ORCL VSS Writer service:oracle Volume

CREATE OR REPLACE PROCEDURE pubres_testAsBEGINFor obj in (Select Resource_name,unit_name,resource_code,sum (update_count) update_countFrom Winf_pubres_update_logGroup BY Resource_name,unit_name,resource_code)Loop--Statistical summaryInsert into Winf_

A few days ago because of work need I have to the Oracle database dozens of tables transferred to MySQL, because there is no relevant experience, the Internet simple Baidu after choosing Navcat Premium software work.Navcat Premium for data transfer

Data Synchronization Scenarios:--Create a link to the desired synchronization table with Dblink--------------------------------------------------------------------------------------------------Parameters--dblink1 Name--csys User Name--**** User

1. Link DatabaseReference System.Data.OracleClient;Database link string data source such as: 192.168.5.153:1521/ORCLString linkstr = "User id=" + name + "; Password= "+ Password +"; Data source= "+ oralink;OracleConnection Oracon = new

Accessing other Oracle database data from Oracle Data Create a database link in the local oracle databaseDrop database link mydblink;Create database link mydblink connect to zszq identified by "zszq" using '192. 168.0.175: 192/orcl '; SQL> DROP

Common oracle Functions Many of these days work around oracle functions. Here we will summarize the functions used in these days. In fact, it is not a summary, that is, to list the use of oracle over the past few days. Returns data using a

Obtain the random time of a specified date (oracle function)   /* The relative minimum value of the date string v_begin random date in the format of v_date 'yyyy-mm-dd', in days. The default value is the relative maximum value of the 0v_end random

Oracle11gexp export problem: some tables cannot be exported An issue found during command exp export from oracle is that some tables cannot be completely exported. After checking, it is found that any blank table cannot be exported. In the

Oracle Data Synchronization solution: oracle Data Synchronization Data Synchronization solution:-- Use DBLINK to create a link to the table to be synchronizedBytes --------------------------------------------------------------------------------------

How to query duplicate data and delete duplicate records in Oracle For example, there is a personnel table (table name: peosons) drop table PERSONS; create table PERSONS (PNAME VARCHAR2 (50), CARDID VARCHAR2 (18), ADDRESS VARCHAR2 (100 )); insert

Difficulties and key points encountered during zoolerac installation (1) When using virtual machines to build the RAC environment on a physical machine, many "pitfalls" and key points are encountered.   Physical Machine: Intel (R) Core (TM) i7-5600U

Two ways to achieve self-growth of oracle field creation, and increase of oracle field Creation Other databases, such as mysql, have the function of Automatically increasing table IDs with the insertion of records, but oracle does not. We have two

Oracle FAQs for beginners When beginners are new to oracle, they will encounter two major questions: first, index range scan, and second, index unique scan ), the following two questions are illustrated in detail: 1. index range scan) Copy