Oracle

Precautions for installing oracle11g r2 on windows 7 x64 and windows 8 x64: Install both 32-bit and 64-bit JDK with vc ++ redistributable and.. net framework 3.5 installation path and Temporary Folder path cannot contain Chinese characters. the

RMAN Backup type-backup set and Image copy RMAN Backup type 1: backup set Backup set: it is the default Oracle backup type, back up used data blocks in a data file to one or more files. Such a file is called a backup file. All the backed up files

Create table "JCMS_ADVERT" ("ID" integer not null enable, "SITEID" INTEGER, "NAME" VARCHAR2 (150 CHAR) not null enable, "UPDATETIME" DATE, primary key ("ID"); create Table sequence create sequence seq_advert minvalue 1 maxvalue 9999999999999999999999

The Oracle analysis functions Lead () and Lag () are actually very well understood. Lead () is to take the next record of the current order, relative to Lag () is to take the last row of records in the current order. It is often necessary to

Oracle ----- familiar with the basic use of oracle databases, do not come! 1. create a table employee with the following fields: Id number (4), First_Name varchar2 (20), last_Name varchar2 (20), mgrid NUMBER (4), Job varchar2 (20 ), salary number (7,

In Oracle, when auto-incrementing sequence is reset to initial 1, it is deleted and rebuilt. This method has many drawbacks, functions and stored procedures dependent on it will become invalid and need to be re-compiled. However, there is a clever

Oracle user-managed backups introduces how to manage backups. the following concepts are described: Full-Database Backup: 1. consistent backup (cold backup), that is, backup after the database is closed, because the data file header and the control

[ORACLE Foundation 1] addition and subtraction of oracle DATE can be performed on both DATE and timestamp. You can add the current date to different time types by year, month, day, hour, minute, and second. There are three methods: 1. Use the

The simplest way to manage instance memory is to allow the Oracle Database instance to automatically manage and tune it for you. A simple way to manage memory is to allow oracle to automatically manage and optimize the memory for you! To do so (on

Two temporary tables in the Oracle database. If we do not specify the data table when creating the data table, the table we create is a permanent relational table, that is, the corresponding data in this table will always exist unless it is deleted.

Drop database ORA-01504 problems oracle 11g for win2008dc, drop database. c: \ Users \ Administrator> set nls_lang = AMERICAN_AMERICA.ZHS16GBK C: \ Users \ Administrator> sqlplus "/as sysdba" SQL * Plus: release 11.2.0.3.0 Production on Wed May 8 08:

Oracle copy and postgresql copy introduce oracle copy first. In fact, this command has never been used till now and is also used for data migration. Note that this command is a SQL * PLUS command, it is not from oracle. You can use this command to

Summary of Oracle Client tool connection to database server problems often encounter problems that PL/SQL Developer and other Client-dependent tools cannot connect to the Oracle Database Server. So far, it has not been fully clarified. I will first

Oracle export/import and Character Set Information viewing for data import and export, we should pay attention to the character set issue. In the EXP/IMP process, we need to pay attention to the four character set parameters: the client character

Oracle tune v $ UNDOSTAT a 11g database running on an 18-touch AIX database. During the check, it is found that the data in view V $ UNDOSTAT is very strange, 1st records have never been cut. the start time is 09:52:08 and the end time is 15:20:34.

[Oracle problem set 1] MEMORY_TARGET not supported on this system execution statement: Start Oracle Database (startup) error: ORA-00845: MEMORY_TARGET not supported on this system error cause: because the size of SGA exceeds the size of the

For example, select * from tb_cod_field_desc where table_code_flag = '000000' start with superior_code = 10000110 connect by prior code = superior_code: start... connect... the following is an explanation: start with... in racle... connect by prior

Oralce stops running and cannot solve the problem. First, find "session" in the plsql tool ", you can check that the sid corresponds to "ACTIVE" to check which program is run in SQL text. 1 \ -- Query sid select * from v $ session t1, v $

Use PL/SQL to obtain the statement Create procedure: create or replace procedure created as cursor get_username is select username from dba_users; begin for l_user in get_username loop DBMS_OUTPUT.PUT_LINE ('authorization ('-----------------------');

Custom array and Application of oracle technology ------------------ create or replace type Varchar2Varray is varray (100) of VARCHAR2 (40 ); /---------------- separated by specific symbols and stored in the array create or replace function sf_split_