Database Administrator

Create procedure procedue_name[@ Parameter data_type] [output][With] {recompile | encryption}AsSQL _statementOutput: this parameter can be returned. With {recompile | encryption} Recompile: Indicates re-compiling every time this stored procedure is

In Oracle 9i, you can easily export data as files or import data from files. The Oracle Management Server (OMS) can be easily implemented. Many instructions are needed throughout the operation, but there are not many complete guidance materials.

When logging on to phpPgAdmin: If you always get a "Login failed" and confirm that you have used the correct username and password and can log on normally in pgadminIII! Solution: Modify php. in the ini configuration file, set extension = pgsql. so

In the most recent project implementation, Oracle network problems were encountered, which were found during the redflag HA switchover test. Although I found the oracle network configuration file in my personal exploration, I don't know how they run.

1. install LINUXI installed LINUX 4.4 compiled by Oracle (5 is also available, but it does not support Chinese characters and garbled characters)1. If the most important role of this server is to install ORACLE, allocate a file system directly to

In a Linux operating system, it is troublesome to use the SQL * Plus tool of Oracle: After you use the SQL Plus command to log on to the SQL * Plus console, in Bash, the used up and down keys suddenly become ^ [[A ^ [[B ^ [D ^ [[C "garbled ". If you

Oracle executes SQL statements to open, parse, execute, and close a cursor. After learning about the several phases of the cursor, We have figured out the SQL Execution process. This is the first content to be introduced in this article. In java

Before Oracle 11gR2, we usually use start with and connect by to recursively display the tree structure. See the following script. Select lpad ('', 2 * level-1,'') | ename, empno, mgrFrom empWhere empno is not nullConnect by prior empno = mgrStart

Environment MySQL 5.1 + command line tool Problem MySQL table field settings Default Value Solution -- SQL: Create table test (I _a int NOT NULL DEFAULT 1,Ts_ B timestamp NOT NULL DEFAULT NOW (),C_c char (2) not null default '1'); -- The

In some cases, you need to relocate multiple Oracle data files and log files or migrate them to new partitions or locations, such as insufficient disk space or special requirements. In this case, you can migrate multiple data files or log files in

Lab Environment 1. Create a linux Virtual Machine RedHat5.0 system under vm8 2.10201 _ database_linux32 Database Lab Purpose 1. Master the manual Oracle database creation   OK. Why do we need to create a database manually? A: Because DBCA databases

My process is as follows: Create or replace package body proc_bodyProcedure init (start_date date, end_date date) isFor rec in (here is a query associated with several tables [R query]) loop......End loop;End;End proc_body; I have created several

Summary of 10 GB flash back in Oracle 1. flashback query (undo)Select current_scn from v $ database;Select * from t as of scn;Time and scn conversion functions:Scn_to_timestamp ()To_timestamp ()Timestamp_to_scn () 2. flashback table (undo)Select row_

GUID (Global unique identifier) is a globally unique identifier, which consists of the ID numbers on the NIC (each Nic has a unique ID number) and a 16-byte binary value generated by the unique number of the CPU clock. The GUID format is

Software Environment Windows 2000 + Oracle9iHardware environment CPU 1.8G + RAM 512 M Now we have two tables:T1 -- large table 10000 T1_FK_IDT2 -- small table 5000 T2_PK_IDT1 is associated with the primary key ID of T2. The simulation data is as

There are many ways to perform backup, recovery, and data reorganization in the Oracle database. The simplest and quickest is the import and Export function. Oracle has two tools (Export Unility) and Import Unility. Export Unility can create a

There are many methods to enable and disable Oracle by using SHELL scripts. In this example, we compile a simple script to call the three scripts that come with Oracle10g. Now let's start by simply editing the three scripts that come with Oracle.

The following error is reported when you execute the mysql command after installing mysql in Linux5.6: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2) 1. Check/etc/rc. d/init. d/mysqld status to see

The permission system of Oracle is divided into 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 grant

Recently, I was engaged in the secondary development of sqlite3. When I saw the transaction in the API, I came up with the idea of testing whether the transaction was enabled or not to affect the time required for data insertion. According to the