Oracle

First, IntroductionWhen we need to connect to a remote Oracle database server, we need to install the Oracle client on our own machine.Second, installation steps and ConfigurationReference: http://blog.csdn.net/luiseradl/article/details/7085222The

CREATE OR REPLACE PROCEDURE prc_query (p_tablenameinchVARCHAR2,--Table name P_strwhereinchVARCHAR2,--Query Condition P_ordercolumninchVARCHAR2,--sorted column P_orderstyleinchVARCHAR2,--Sort Method P_curpageinch outNumber,--Current Page

The Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field merge if you have an Oracle Wm_concat (column) If you are interested in the use of

1. Delete User table spaceOracle has been in use for a long time, adding many user and tablespace. Need to clean up.For a single user and tablespace, you can do this using the following command.Step One: Delete userDrop UserxxcascadeNote: Delete the

Creating tables and primary foreign keysCREATE TABLE sc_district ( ID number () not NULL, parent_id number (Ten), NAME VARCHAR2 (255 BYTE) Not NULL); ALTER TABLE sc_district ADD ( CONSTRAINT

Flashback table Test_drop to before drop;Test_drop: The watch that was mistakenly deletedThe blogger wrote this profound lesson with a heart of remorse:1) do not casually play drop table;2) This command is really able to recover, looks intact;3)

Oracle Paging stored procedure: CREATE OR REPLACE PROCEDURE fgk.prc_page (p_tablenameinchVARCHAR2,--Table name P_strwhereinchVARCHAR2,--Query Condition P_ordercolumninchVARCHAR2,--sorted column P_orderstyleinchVARCHAR2,--Sort Method P_curpageinch

9. TIMESTAMP with Time ZONEContains all the fields in the TIMESTAMP data type, plus two additional fields: Timezone_hour and Timezone_minute. This data type contains information about the time zone that is supported. This data type can be used in

18, NCLOBYou can use a character set defined by the database international character set to store character-based data that is only Unicode type. You can store up to 4GB of data, which is larger than the maximum data that can be stored in the ORACLE1

Create or Replace procedure Testwzm (V_GDJDM in varchar2) isv_id VARCHAR2 (10);V_xlname varchar2 (100);V_count number (4);Beginv_count:=0;Defining cursorsDECLARE CURSOR line_cur isSelect Line_code,line_name from Ods_yx.line where GDJDM=V_GDJDM and

The previous article recorded the C # Implementation of SQL Server 2005 and Oracle two database synchronization tool, today when the tool is copied to the server running when the synchronization of Chinese characters into garbled, Baidu after a few

paging function (Pagenation Class)Package + Implementation of paging function:Paged SQL statement + pagination Tool class Pagenation details + pagination principleOne, paged SQL statement:SELECT * FROM (Selectt.*,row_number ()-Over (order by ROWNUM

Trigger implementation function: When inserting a row of data into table A, insert a related data into table B at the same time.---Create a test sample tableCREATE TABLE person (PID number (10));Create table Task (TID number (10));---Create an

Fortunately, I was recommended to participate in the Oracle Yep program, although compared with you, my actual experience and ability still have a lot of shortcomings, but at least a kind of encouragement to myself, adhere to the interest, adhere to

ORA-01012: not logged on, ora-01012logged On the ORA-01012 of this error, Xi Feifei blog ORA-01012: not logged on which has made some introductions, the reason is not much said, look at his description:   Symptom description:   1) finally found the

Oracle12cRAC modify SCAN Configuration Check the SCAN modification in 12c. The modification includes two aspects: (1) modify the SCAN name. (2) modify the IP address of SCAN.   If SCAN in/etc/hosts is used, you only need to modify the hosts file. If

Principles and usage of oracle packagesPackagePackage definition:A package is an encapsulation package for objects such as related procedures, functions, variables, cursors, and exceptions. It consists of two parts: specification and

Constraints in OracleConstraint type CONSTRAINT_TYPE in Table ALL_CONSTRAINTS:C (check constraint on a table) -- constraints, such as not null, checkP (primary key) -- primary keyU (unique key) -- unique key constraintR (referential integrity) --

10gR2Clusterware Installation Steps1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to install the Oracle

Let's talk about OracleAll subqueries in one example. Problem:The employee names, jobs, and salaries that are higher than the salaries of all salespeople are queried. Analysis:ANY can represent ANY, but this problem requires higher salaries than