Oracle

  Create or replace procedure proc_emp (ENO in number, Sal out number) -- stored procedure with Input and Output Parameters As Emp_records EMP % rowtype; -- declares a record type to store the result set. Begin Select * into emp_records from

Oracle logs include online redo log and archived log. Online redo log:A database must have at least two groups of redo logs, and each group of redo logs must have at least one member (for security reasons, we recommend that each group of redo logs

-- Create a data table spaceCreate tablespace mytablespaceDatafile 'd:/mytablespace. dbf'Size 32 mAutoextend onMaxsize unlimited; -- Create temporary tablespaceCreate temporary tablespace temptablespaceTempfile 'd:/mytempspace. ldf'Size 32

First, let's talk about the trigger concept: the trigger is a special database object caused by the execution of DML statements. Therefore, the insert, instead of update, and delete triggers are required. The basic usage is shown below:-- Create or

Installing oralce in windows is not difficult for most people. As long as the system hardware and software configurations meet the minimum requirements, the installation can be completed. From the security point of view, the installation in Linux

-- TableCreate Table Test (names varchar2 (12 ),Dates date,Num int,Dou Double ); -- ViewCreate or replace view vi_testSelect * from test;   -- SynonymCreate or replace synonym AAFor dbusrcard001.aa;   -- Stored ProcedureCreate or replace

  Introduction to solution objects   Schema is a set of Logical Data Structures (or schema objects.Each database user has a solution with the same name. Solution objects can be created and operated through SQL statements.   The object types that can

Basic Oracle Stored Procedure syntax 1. Basic StructureCreate or replace procedure(Parameter 1 in number,Parameter 2 in number) IsVariable 1 integer: = 0;Variable 2 date;Begin End stored procedure name 2. Select into statementSave the result of the

Http://www.blogjava.net/liaojiyong/archive/2007/10/26/156094.html 1. Start the database:Oracle @ suse92: ~> Sqlplus/nolog SQL * Plus: Release 9.2.0.4.0-production on Fri Jan 20 02:29:37 2006 copyright (c) 1982,200 2, Oracle Corporation. all rights

Create or replace package sqlexp_pack is -- Author: yanlei -- Created: 11:25:09 -- Purpose: Oracle Export -- SQL export text string Function sqltotext (sqlstr in varchar2) return long; -- SQL Export File Function sqltofile (sqlstr in

-- Constraint (primary key, non-null, unique, check, foreign key, default)-- Create constraints when creating a table-- Method 1: Write the constraint directly behind the fieldCreate Table student(Sno int primary key, -- primary keySname varchar2 (20

Source: http://www.oracle.com.cn/archiver? Tid-120728.html How to merge strings of multiple rows of records, my colleague once suggested that I use function to implement it, but multiple similar fields in my report need to be merged, so I want to

Oracle spfile exampleOracle tips by Burleson ConsultingDon BurlesonFrom: http://www.dba-oracle.com/tips_oracle_spfile_example.htm The following is from the bestselling bookOracle 10GGrid & Real Application Clusters-oracle10GGrid computing

Recently, I encountered a problem in determining the value of attendance materials. After several discussions on the Forum, I finally got a solution. The URL of the Forum is as follows: Http://topic.csdn.net/u/20090415/15/4d934ccf-134d-4a3d-846e-cc71

-------- Creating physical standby database --------------------------------------- Settings for the primary database -------------------------------- 1. Enable forced LoggingAlter database force logging; 2. Create a password fileOrapwd file = orapw

I. Hardware requirements1. Check physical memory requirements (> = 256 MB)[Root @ centos ~] # Grep memtotal/proc/meminfoMemtotal: 1554748 KB 2. Check Virtual Memory RequirementsRam 1-2 GB: swap 1.5 * RamRam 2-16 GB: swap = RamRam> 16 GB: swap 16

Oracle user access control 1. PermissionsOracle Database Security is divided:System SecurityData security System permission: database access permissionObject permission: operations on the Content of database objects Schema: a collection of objects.

DDL statementDatabase objects: tables, views, sequences, indexes, synonymsNaming rules for database objects:-It must start with a letter.-No more than 30 characters-A-Z, A-Z, 0-9, _, $ ,#-Duplicate names of objects in the same schema and other

Restrictions on the Use of sequence objects in OracleNextval and currval are valid only in SQL statements and not directly in SPL statements. (However, SQL statements using nextval and currval can be used in SPL routines) The following restrictions

This document describes how to create an Oracle Auto-increment field. Description: sets the ID of the pipe_test field in the test record table to an auto-increment field. Pipe_test table structure SQL> DESC pipe_test; Name type nullable default