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
Oracle databases have three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup.
1. Export/Import (Export/Import)
The Export
Copy command of SQL * Plus
Copying data between data tables is one of the tasks that Oracle DBAs often face. Oracle provides a variety of solutions for this task. The SQL * Plus Copy command is one of them. The SQL * Plus Copy command uses SQL *
1. Environment: Fedora, mysql-5.0.18.tar.gzNOTE: If mysql has been installed during system installation, use rpm-e ******* -- nodeps to forcibly uninstall mysql.2, enter the mysql folder decompression, # tar zxvf mysql-5.0.18.tar.gz,Enter the
In many cases, we need to terminate all Oracle processes ). When the database is "locked" and you cannot enter Server Manager to terminate the database, you can use the kill command in UNIX to terminate all Oracle processes. This is one of the
During the Oracle Installation Process today, the entire process was relatively smooth with reference to the information downloaded from the Internet to install oracle on RHEL5, but encountered some problems, although not very serious, however,
I learned how to install mysql + php + apache2 in freebsd and linux.
Version: mysql: 4.0.26 apache: 2.0.59 php: 4.4.2
Freebsd:
-- MySQL
Pw groupadd mysql
Pw useradd mysql-g mysql
./Configure-prefix =/usr/local/mysql
Make
Make install
Chown-R
By default, MySQL supports three engines: ISAM, MyISAM, and HEAP. The other two types are InnoDB and Berkley (BDB ).ISAMISAM is a well-defined and time-tested data table management method. It is designed to take into account that the number of
1. Oracle Database NameThe database name is the "ID number" of the database, used to identify a database. DB_NAME is used in the parameter file.The database name must be used to install the database, create a new database, create a database control
It may be a little difficult to install mysql on Unix/Linux. the operating system I use is FreeBSD5.2.1. If other operating systems may have different installation methods, handle them as appropriate.I won't talk about installing FreeBSD. I just
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
Recently, the Oracle 10g RAC migration under the virtual machine, after the migration is completed, the Oracle cluster resource VIP cannot start normally, received the CRS-0233: Resource or relatives are currently involved with another operation
The project has a need to store images to the database. You need to create a new table to take this opportunity to learn how to create an Oracle table and set the auto-increment of primary keys in the table.
First, create the tables required for
Installation Background: due to the need of Graduation Project, Oracle 10g is installed on CentOS6.2 platform, mainly referring to the documents I think are more reliable on the Internet. It turns out that this is also true, here are my installation
Two users, jytest and jytest1, both have dba permissions. In jytest1, a user creates a table named test.
Create user jytest identified by "jytest"
Default tablespace users temporary tablespace temp;
Grant dba to jytest;
Grant resource to
On the Internet, find information about the successful installation of Oracle11g on the LUbuntu 12.10 desktop. Recorded.
1. Install DependenciesSudo apt-get install gcc make binutils libc6 libc6-dev lesstif 2 RPM libmotif3 libstdc ++ 5 libaio1
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
Today, when logging on to Oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i, using vm login on the server db and API have restarted the login or error, and then on the
1. Download the Windows version of mongodb, including the 32-bit and 64-bit versions (of which the linux version is also available). Download the version based on the system conditions. : Http://www.mongodb.org/downloads. here I download mongodb-win3
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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.