Oracle

Stored procedures are in a large database system, a set of SQL statements to complete a specific function, stored in the database, after the first compilation after the call does not need to compile again, the user by specifying the name of the

In Oracle, the control file is the file used when the database is mounted, the control file is lost or corrupted, and the instance crashes, where the parameter file records the location of the control file;After the instance starts to Nomount, if

1. Start-> Settings-> Control Panel-> Management Tool-> Service stop all Oracle services.2. Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer Uninstall all Oracle products, but Universal Installer itself cannot be

[sql]/*第1步：登录  */以sys/sys超级用户登录pl/sql    /*第2步：创建临时表空间  */create temporary tablespace user_temp    tempfile ‘E:\oracle\product\10.2.0\oradata\wu\user_temp.dbf‘size 50m    autoextend on next 50m maxsize 20480m    extent management local;   

The connections between Oracle tables are divided into three types:1. Inner connection (natural connection)2. External connection2.1. Left outer connection (the table on the left is unrestricted and the results of all conditions are queried)2.2.

The database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data, because the reasonable design, if the data

A view is a very important database object in the form of a normal table, and we can query the data from the view.In fact, it is a virtual table built on a table that does not store real data in the view, but simply saves a SELECT statement, and

Java program Operation database, encounter deadlock: java.sql.sqlexception:ora-00060: Deadlock detected while waiting for resourceSteps to resolve:1. Find the Oralce Object (table) for the deadlock:Select object_name,machine,s.sid,s.serial#From

Resume oracle.sh in/etc/profile.d/The contents are as follows in Nls_lang setup encoding1 oracle_home=/usr/lib/oracle/12.1/client642 c_include_path=/usr/include/ oracle/12.1/client643 ld_library_path= $ORACLE _home/lib4# RememberThis was the client

Oracle left and right connections+ On the left side of the equals sign, the right connection gets all the records of the right table, even if the left table does not match.+ On the right side of the equals sign, the left connection gets all the

1. Create a stored procedure for sending messagesCREATE OR REPLACE PROCEDURE send_mail (p_recipient VARCHAR2,--Mail recipientP_subject VARCHAR2,--Mail headerp_message VARCHAR2--Message body) is--The following four variables should be assigned

Reference article: http://tutorialforlinux.com/2016/03/09/ how-to-install-oracle-11g-r2-database-on-ubuntu-14-04-trusty-lts-64bit-easy-guide-managing-db-troubleshootings/Reference article: http://m.oschina.net/blog/318293I. Get the resource bundle,

The system global Area (SGA), also called the shared global zone. 1. Data buffer (Cache):Used to store data read from a disk data file for all users to share. After the user modifies the data, the modified data is first saved in the database

1. Query the current date and timeSelect from dual;2. Check the last day of this monthSelect from dual;3. How many months before and after querySelect add_months (sysdate, from dual;4. Check the specific date of the week of the following week

Dual is a virtual table that makes up the syntax rules for SELECT, and Oracle guarantees that there will always be only one record in dual. We can use it to do a lot of things, as follows:1. To view the current user, you can execute the following

1, to have a unique index or primary key as a precondition, reduce the number of data conflicts, such as the example of red places: 2, when there is in the query, try to use exists, this can improve query efficiency: CREATE TABLE tf_f_user_diff1

Oracle: Turn on monitoring--lsnrctl startOracle: Start/Close Database--sqlplus/nolog--conn/as SYSDBA--startup (Open)--shutdown (OFF)Oracle: Create a table space1. Create a temporary table space--create temporary tablespace XXX (name) tempfile ' xxxx.

Today I restored a copy of the database (there is no invalid object on the server), restored after the local there are more than 30 invalid objects, was very depressed, then I found the database after the restoration of missing tables!At first I

Beginners to learn Oracle will generally use Sqp*plus to play the Oracle code, but ORACLE10 is not to copy the paste operation, so need to use DOS to operate, more simple, of course, Sql*plus also has its own advantagesTo use DOS, first configure

The user presses, the string decomposition in the Oracle programming can use in the word, the word parsing, then may implement the word search merger, is the basic code.The code below, the author retains ownership.Create or Replace function