Oracle

The summary of oracle cyclic statements mainly includes the following five types of loops: Exit When, Loop, While, For (Common Loop), and For (cursor Loop). The following are examples (all stored procedures ). 1. Exit When loop: create or replace

Redo log files of storage structure can be divided into online redo log files and archived redo log files. It is the transaction log of a database. The purpose is to restore committed transactions when a failure occurs. Almost every operation you

The following article describes how to use relevant triggers to implement auto-increment IDs in Oracle. The actual steps for implementing auto-increment effects for IDs in the userinfo table are as follows, if you are interested in the actual

Database backup and restoration process 1. New database instance note character set is UTF-82, command line C: \> set ORACLE_SID = EAS (note Instance name is not capitalized Instance name) define default instance C: \> sqlplus/nolog3. user system

Precautions for creating a temporary table in the stored procedure and the demo cannot be used directly in the stored procedure of creating a temporary table in the ORACLE stored procedure, therefore, you can only use dynamic SQL statements to

Oracle (7) exception handling oracle classifies exceptions into pre-defined exceptions, non-pre-defined exceptions and custom exceptions three pre-defined exceptions are used to handle common oracle errors non-pre-defined exceptions are used to

ORACLE basic commands and user management 1. connection command connection: conn [ect] user name/password @ network server [as sysdba/sysoper] If you log on to sys, because sys can have two roles, therefore, you must log on as the "connect user name/

Basic Analysis of PL/SQL SQLSQL (Structured Query Language) is the basic operating Language of relational databases. It is an interface for applications to interact with databases. It integrates Data Query, Data Manipulation, Data Definition, and

Description of % a in RMAN backup FORMAT the oracle document describes % a as follows: [SQL] % a Specifies the activation ID of the database. rman backup and save, query % a [SQL] RMAN> backup tablespace users format '/home/oracle/think _ % a'; www.2

In Linux, Oracle executes the SQL script and garbled characters appear in Chinese. To solve this problem, first confirm the character set of Oracle. After sqlplus logs on to Oracle, it executes the statement:[SQL] select userenv ('language') from

Database cursor (Oracle) the concept of cursor is a memory Workspace of SQL, which is defined by the system or user in the form of variables. A cursor is used to temporarily store data blocks extracted from the database. Why use a cursor? The data

Oracle Database new installation connection string problem cutover newly installed database, Client Login no problem, apache/cgi-bin program problems, sqlnet. the log is as follows: Fatal NI connect error 12170. version information: www.2cto.com TNS

Common functions of Oralce SQL language (iv) Conversion FunctionsA Conversion Function is mainly used to operate on multiple data types. It is used to convert data from one data type to another, common conversion functions include the following two

Familiar with Oracle SQL language is an advanced non-procedural query language, users can use SQL as a tool for communication between the client and the server to access, query, and update databases, the syntax structure of the Insert statement in

When I started to contact oracle, I felt very complicated. I had to create a sequence and trigger even when the primary key increments. After I got to know it, I felt that the design was very flexible and practical. The following code has

Oracle Stored Procedure paging processing knowledge point link 1. oracle Paging2. Use cursor to create a stored procedure [SQL] -- create a stored procedure (startpoint start point, number of getnum retrieved) create or replace procedure copylimit

Group functions and group statistics in Oracle 1. commonly used group functions in SQL include COUNT (): obtain the number of all records -- SELECT COUNT (empno) FROM emp; MAX (): obtain the maximum value in a group -- select max (sal) FROM emp; MIN

Oracle does not have the permission to edit the view. Today, an operation is as follows: delete all tables under the zzb tablespace, and then import new tables and data, after viewing the view in another tablespace, most of the results are

Profile management user password and unlock user use profile Management user Password account lock 1) Lock SQL> create profile lock_account limitfailed_login_attempts 3 password_lock_time 1; ---- create a profile named lock_account, three logon

Create auto-increment column 1 in oracle first create a sequence: create sequence h75510010_uhz_phonelist_seq -- sequence name (AUTO_ADD is a series name, just name it) ­ www.2cto.com increment by 1 -- start with 1 each time -- start from 1 --