Oracle

  SQL code -- Trigger -- 1. DML trigger DML statements (DELETE, INSERT, UPDATE) /* A dml SQL statement may have multiple or only one row. The statement trigger triggers each SQL statement. The trigger is executed only once. The Row-Level Trigger is

  The permission system of the oracle database includes system permission and object permission. Database system privilege allows users to execute specific command sets. For example, the create table permission allows users to create tables, and the

1. Patch preparation There are four main points:1) use Telnet to log on to the application server and check the Unix server type. Currently, there are three types of server (ibm aix, SUN Solaris, and hp ux.2) view the version number of the program

[Oracle]-[TWO_TASK]-The Role Of The TWO_TASK environment variable is the two connection strings currently configured (one local database and one remote database ): [oracle@liu admin]$ more tnsnames.oraBISAL = (DESCRIPTION = (ADDRESS = (PROTOCOL =

Oracle Database creation and date format usage Install oracle Instance name orcl, system password system/* Database creation steps:1. Install the oracle database tutorial, enter the Instance name orcl, and finish creating the instance database.2. in

This article to tell you about the solution of ORA-28002: Password 7 days after the expiration method, you can look at the students who need to refer to oh, good time not to say more let's see it. Symptom description:Log on to oracle 11gERROR: ORA-28

New users ask me about SQL statements or instances for creating users, roles, authorization, and tablespace in Oracle. Let's take a look at this article. Each oracle user has a name and password, and has tables, views, and Other Resources created by

Starting from 11 GB, oracle supports cross-platform table space transfer.View the list of supported platforms. If the endian format of the source and target databases is inconsistent, You need to convert SQL col platform_name Solaris

I. SQL tuning class 1: List several table Connection MethodsHash join/merge join/nest loop (cluster join)/index join 2: How to view SQL Execution plans without using third-party toolsSet autot onExplain plan set statement_id = & item_id for &

Today I learned about the latest popular Ruby on Rails. I feel that it is a code generator linked to Oracle.DatabaseI checked the data for half a day. Finally, I found a solution. ^ ______ ^1. Install the driverHttp://rubyforge.org/projects/ruby-oci8

A table connection refers to the association between tables in an SQL statement to retrieve relevant data from one or more tables, in general, the table and table connections can be divided into four types: equal connection, external connection,

[Document of the institute of fire station building school] This article does not discuss some commonalities in SQL injection, such as using substr functions and classic injection, but from the perspective of oracle Database, try to show some SQL

The tutorial of helping customer House (www.bkjia.com) uses ORACLE stored procedure and JOB to realize automatic backup of data tables. 1. Create a stored procedure Create or replace procedure data_auto_backupV_tablename varchar2 (200 );V_year

How does an ORACLE database view partition table information? I wonder if you have summarized this knowledge. Next, we will first create two tables TEST and maid to perform the experiment. The script is as follows:Create table maid ( DATE_CD NUMBER (

Note that (SID) indicates the SID Name specified during database installation, and (HOME_NAME) indicates the last Oracle Installation name of the value specified by ORACLE_HOME during installation, in Windows, the default value is similar to

Last week, I deleted the production data because of a temporary embarrassment. The delete statement is used, and commit is returned quickly. So --- "has a cup. ---------------------------------------------------- The following two statements are

You can use the following SQL statement in PL/SQL to query which tables in the current database are locked and which users are locking these tables: SELECTA. OWNER, -- user to which the OBJECT belongsA. OBJECT_NAME, -- OBJECT Name (table name)B.

ORACLE locks have the following modes:0: none1: null2: Row-S Row sharing (RS): Share table lock3: Row-X (RX): used for Row Modification4: Share lock (S): blocks other DML operations5: S/Row-X dedicated shared rows (SRX): block other transaction

SQL statement for querying and deleting duplicate records1. Search for redundant duplicate records in the Table. duplicate records are determined based on a single field (Id ).Select * from table where Id in (select Id from Table group by Id having

Session: a Session is called in a computer, especially in a network application ".Session: In computer terminology, Session refers to the time interval between an end user and the Interaction System. It usually refers to the time between the user's