Oracle

1. Basic StructureCREATE OR REPLACE PROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) IS |Variable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND stored procedure nameNote: is can also be changed to 2. SELECT INTO STATEMENTSave the result of the

Use the exp;impcommand to export and import racledata databases and execute them in the environment of the local or sqlplus.exe command. The exp command can export data from the remote database server to a local dmp file, and the imp command can

Today, I will share with you the solution for oracle Database rman remote recovery. If you do not want to go to the reference page, the specific method is as follows. I want to implement data guard between two sets of rac. Because datafile,

Dmp File Import and Export Steps -- The path of the datafile is provided at will, but the subsequent file name is dbf LOGGING DATAFILE 'd: \ OracleDateFile \ DTBS. dbf' SIZE 32 M AUTOEXTEND ON NEXT 32 m maxsize 2048 M Extent management

Case when usage, simple Case FunctionUse a simple CASE expression to determine the return value. Syntax: CASE search_expression WHEN expression1 THEN result1 WHEN expression2 THEN result2 ... WHEN expressionN THEN resultN ELSE default_result Search

A database transaction is a unit operation. Either all operations are successful or all operations fail. In Oracle, a transaction starts from executing the first data governance language (DML) statement until it executes a COMMIT statement, commits

Data Query is one of the most important functions in database operations. Sometimes the performance of database queries is directly related to the database operation efficiency and database selection. I will not talk about the principle below, but I

　　LieHuo. Net database integrationOracle and Microsoft are both major database manufacturers, and there are also a lot of enterprises adopting the two products. This article compares Oracle and SQLServer images. Database images are used to move

Before Oracle9i, Chinese characters were sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i.1. Set the NLS_SORT parameter valueSCHINESE_RADICAL_M is sorted by Ministry (First Order), strokes (Second

Oracle SQL Execution flowchart _ SQL Execution Process1. SQL statement execution steps:1) analyze the syntax and analyze whether the syntax of the statement complies with the specifications, to measure the meaning of each expression in the statement.

The Lag and Lead functions can retrieve the data of the first N rows and the value of the last N rows of the same field in a query. This operation can be achieved through table join for the same table, but LAG and LEAD are more efficient.Copy

Copy codeThe Code is as follows:Create or replace procedure Test5 (o_cellphone in varchar2) isV_cellphone cc_quiz_stat.cellphone % type;V_name cc_quiz_stat % rowtype;V_state cc_quiz_stat.state % type;BeginDeclareCursor cur_cc isSelect * from cc_quiz_

What should we do when defining the field name and alias with the same name as the oracle keyword?In fact, it is very easy to add "", such as "group" to this keyword"See the following example:Copy codeThe Code is as follows:SQL> DROP TABLE k;Table

Recently, many projects require batch operations. The client passes a set of IDS separated by commas (,) to the database, and the stored procedure needs to separate them and process them one by one.The previous processing methods are as follows:1.

The idea of Oracle paging stored procedures is the same as that of SQL Server, but I have made some changes here because of the differences in Oracle syntax and rules, the Oracle paging Stored Procedure looks a little different. Smile!Cursor

I. Creation and use of stored procedures1. Create a package and create a stored procedure in the programCreate or replacePACKAGE NCS_ICP_TJ/* Lfx@ncs-cyber.com.cn *//* TODO enter the package Declaration (type, Exception error, method, etc.) here )*//

Inner join ).External Connection:Full join, left join, and right join ).Cross join ).The outer join and the inner join are different. The query results returned by the outer join include not only the rows that meet the conditions, but also the left

In the development of oracle databases, due to time issues, the weekly chapter is too large, so the date functions of ORACLE Data are specially added to favorites. It is for another day's query.Add_months (d, n) date d plus n monthsWhat month does

1. Understand oracle External tablesExternal table definition: The structure is stored in the data dictionary, and the table data is stored in the OS file.Purpose: query the OS file data in the database and load the OS file data to the

Conversion of date and time in c shell perl php: seconds and human readable date scalar localtime and seconds since '00: 00: 00 1970-01-01 UTC'Scalar localtime 26-byte string and seconds since '00: 00: 00 1970-01-01 UTC'(The number of seconds since,