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

-- 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

  Oracle physical database structure Overview   The physical structure of Oracle is actually composed of a variety of files, Database-related items include: Data file ):These files are the main files of the database, including data tables, indexes,

  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

Oracle 10 Gb supports Silent Installation on the command line, which greatly facilitates Linux systems that do not have a graphical interface installed.The following uses Fedora Core 6 as an example to describe how to install oracleoracle 10 GB on

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

-- Delete the content in brackets FunctionDelmatch (StrIn Varchar2,FirstmatchIn Varchar2,AftermatchIn Varchar2)Return Varchar2 IsP1Integer;P2Integer;DelstrVarchar2(4000 );BeginP1: = instr (STR, firstmatch );IfP1> 0ThenP2: = instr (STR, aftermatch

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

Stored Procedure creation Syntax: Create or replace procedure stored procedure name (param1 in type, param2 out type) As Variable 1 type (value range ); Variable 2 type (value range ); Begin Select count (*) into variable 1 from Table A where column

Document directory What is a flashback recovery zone? Why flash back to the recovery zone? Set the flash recovery zone  What is a flashback recovery zone? As explained in the Oracle official documentation: Flash recovery area The Flash

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

In the recent development process, we need to take the maximum value of the horizontal column in Oracle. Here we will introduce several Oracle functions for you: For more information, see the blog. If you have any help, please leave a trace! Oracle

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

Microsoft Windows 2000 [version 5.00.2195](C) Copyright 1985-2000 Microsoft Corp. C:/Documents and Settings/Administrator> sqlplus/nolog SQL * Plus: Release 9.2.0.6.0-production on Wednesday August 1 11:42:37 2007 Copyright (c) 1982,200 2, Oracle