Oracle

I. Process (stored procedure) A procedure is a subroutine that can perform a specific operation. Create or replace a subroutine that is saved in the database by using the creates or replace.Example 1: declaring a stored procedure that

Java reads the Oracle database BLOB field data file and saves it to a local file ******Package Com.bo.test;import Java.io.fileoutputstream;import Java.io.inputstream;import java.sql.Connection;import Java.sql.drivermanager;import

15/03/21 use functions for yearly, monthly, weekly, daily data summariesSuppose a sales schedule sale_detail contains a country (country), sales time (sale_time), sales ( Sale_money ) .. waitThe SUM function sum() and grouping clauses need to be

Vmware Server can vmware-workstation-full-the virtual machine from the official website http://www.vmware.com/cn/or from the network address 10.0.1-1379776 version, as well as the official CentOS website www.centos.org download out, of course you

After the Oracle database is installed, start the database as SQL Developer: The result is a small box prompting you to enter the full PathName for Java.exeFor this workaround:Locate the Java.exe file under the Oracle path that you installed, and

We look back at the files that were generated when the database was backed up.rman> backup database; starting backup at 2015/07/08 00:58:27using  channel ora_disk_1channel ora_disk_1: starting full datafile backup 

Rman> CONFIGURE RETENTION POLICY to redundancy 2;Rman> CONFIGURE RETENTION POLICY to RECOVERY WINDOW of;Enable control file automatic backup and backup storage location configurationRman> Configure Controlfile autobackup on;View configuration

Oracle Build table, build primary key, self-increment--Build a tableCREATE TABLE Test (ID Number (4) Not null primary key,Name VARCHAR2 (25))--SequenceCreate sequence Test_sequenceIncrement by for each increase of severalStart with 1-counting

This is a system that WIN8 64 bits a second. Then there's a 64-bit oracle11g,oracle11g. Download page:http://www.oracle.com/technetwork/database/enterprise-edition/ downloads/index.html, find a suitable database for their own system, you need to

Original link--http://blog.csdn.net/qq525099302/article/details/47146393Why use a function to get sequence values see here--Create a function to get the next value of the sequence Create or replace function Get_seq_next (seq_name in varchar2)

1, first download PL/SQL, installation, cracking;Here to provide a self-made plsql11 version of the Green Chinese cracked version:Http://down.51cto.com/data/2075386http://download.csdn.net/detail/abc2536465230/8939917The two are the same.2, download

After the instance has been allocated the memory structure, loads the control file, then wants to open the database, needs to do the control file, the data file, the online redo log maintains the mutual state consistency, the database can open. When

Due to database migration, the original Oracle backup file needs to be imported into the new Oracle database, EXP export, imp error, found that the string length is too long error. Find out, the original database is the GBK character set (Oracle in

Database theory in the database user and database schema is not necessarily linked, detailed database schema interpretation can be found here:Http://stackoverflow.com/questions/2674222/what-is-purpose-of-database-schemaA database schema is

The decode () function is one of the most powerful functions of Oracle PL/SQL and is currently available only to Oracle Corporation, where SQL implementations of other database vendors do not yet have this function. Baidu Experience:

Aggregation functions can be performed in either analytic or non-analytic mode. Aggregate functions in non-analytic mode reduce the result set to fewer rows of data. However, in analytic mode, the aggregate function does not reduce the number of

First, SQLLDR import txt1. Preparationa). txt fileThis is to be saved as unsigned UTF-8.b). Oracle Build Table2. Write the control file Input_test.ctlLOAD DATACHARACTERSET ' UTF8 '--Character Set settingsINFILE ' D:\input_test.txt '--The text data

Solution to the ORA-31684: object type already exists error when importing data with impdp Data Pump in oracle When importing data using the impdp Data Pump in oracle, if a user has been created before the import, an error is prompted: ORA-31684:

Java-based Oracle database self-built tool Library When I learned how to operate Oracle databases in Java, I suddenly thought that I could create a tool class like php, which could greatly reduce the complexity of the Code. It can also improve work

Oracle connection configuration and instance backup and recovery, oracle instance Background: It is impossible for a team to build their own local database for project development. In most cases, the database on the server is used in a unified