Oracle

Triggers are blocks of code that are executed automatically when a particular event occurs. Similar to stored procedures, but users cannot call them directly. Triggers are a technology provided by many relational database systems. In Oracle systems,

In the development of Oracle databases, it is often a matter of time, so the date function of Oracle data is collected specifically. is for future investigation. Add_months (d,n) Date d plus n months Last_day (d) The date of the last day of the

A well-designed, performance-capable database engine can easily serve thousands of users at the same time. And the "weak" database system with more users to access the system will greatly reduce its performance. In the worst case, it could even

Installing Oracle under Linux is a daunting thing, much more complicated than installing the Linux operating system itself. If you are able to successfully install Oracle, you can also learn some Linux technologies. This article describes the method

A while ago participated in an Oracle technical meeting held by the municipal information Office, which mainly introduced Oracle's integration plan, which is the Oracle Cloud computing solution. To be honest, I've been a bit biased about cloud

Nine Incremental backups With incremental backups, RMAN allows users to back up only blocks of data that have been modified since the last incremental backup. Incremental backups have the following somewhat: (1) Less use of disk or tape (2)

Because of the row link can only increase db_block_size to clear, and db_block_size after the creation of the database can not be changed, so there is no more than the purge of the row link, mainly for the row migration to talk about in the actual

There are many backup methods for Oracle databases, including industry-recognized cold backups, hot backups, and so on, but regardless of which backup method is used, the purpose of the backup is to recover the system at the lowest possible time and

First, the demandThe database and application are not on the same host, so you need to install an Oracle Instant client or an Oracle client. But the client is rather large.Second, install Oracle Instant ClientDownload the Oracle Instant Client

Oracle Lock table row-level lock table-level lock ----row is locked exclusively ----Other users cannot modify this line until a row's lock is released----use the commit or the rollback command to release the lock ----Oracle by using INSERT, UPDATE,

Oracle Wallet Preliminary study1.  What isWalletA Datastructure used to store and manage security credentials for A individualentity.from Oracle10gr2 starts by using Oracle Wallet to log in to the database without using a password ( non-operating

The Data definition language (Language, DDL) is a language in the SQL language set responsible for data structure definitions and database object definitions, consisting of Create, alter, and drop three grammars. database objects include tables,

Oracle SQL Language Query statement-beyond OCP proficient in Oracle video tutorial training 29This course introduces:Oracle Video tutorial, wind Brother this set of Oracle Tutorial training is the > 4th 5 sets: Oracle SQL language query statement.

--View the structure of the tableDesc YGB;SELECT * FROM User_tab_columnswhere table_name= ' YGB ';--New Table YGBCREATE TABLE YGB (BH Number (3),Eid VARCHAR2 (6) Constraint Eid_p primary key,ename VARCHAR2 (10),Bdate Date,Sex char (1),City Varchar2 (

Oracle Video Tutorial GoalsOracle Video tutorial, wind Brother this set of Oracle Tutorials Training Learning Audit function, audit related parameters and views, audit level and permissions, Audit function installation/migration, audit function data

Oracle 11G RAC Database installation (eight) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary

1. The various parts of the sub-program:Declaration section, executable part, exception handling section (optional)2. Sub-Program classification:A. Procedures-performing certain operationsA. Syntax for creating a procedure:CREATE [OR REPLACE]

Oracle 's system is too large, for beginners, it is inevitable that there is a feeling. After a semester of learning to have some in-depth understanding of Oracle learning, because previously learned Some basic knowledge of Oracle, so learn to get

Oracle Database-practical operations (3) PL/SQL Oracle ---- PL/SQL PL/SQL is a programming Language that combines Procedural Language and Structured Query Language (SQL ). PL/SQL is unique to Oracle and is an extension of SQL. Different database

Scalable lgwr is an exciting feature introduced in 12cR1, because LGWR writes logs in the OLTP environment often become the main performance bottleneck of the system. If the LGWR process can be like DBWR (DBW0 ~ As long as multiple processes (LGNN)