Oracle

Basic concept of oracle: Database vs Instance is the most confusing term for oracle users, especially those with ms SQL server experience. The two concepts www.2cto.com are actually quite simple to understand. Let's take the notepad notebook as an

Use sum to convert rows and columns. The original table www.2cto.com is expected to display each IDX_CODE column in the table in the query results. The result table is as follows: create table test (IDX_DATA_ID NUMBER (12) not null, org_no NUMBER (2)

PL/SQL attribute type description PL/SQL two attribute types Description: www.2cto.com % type reference the type of a variable or database column to declare the variable % rowtype to indicate the record type of a row in the table. The www.2cto.com

Oracle query conditions are case-insensitive. For example, if the storage name job is queried, JOB_REPORT_COUNT_INFO and job_clearinvalid can be displayed. The conditions for www.2cto.com are =. You can write upper (pro_name) in this way) = upper

Oracle entry to master Part 3-query 2 Table query (2) www.2cto.com using logical operation symbols problem: Query employees whose salary is higher than 500 or whose position is MANAGER, at the same time, must their first letter of name be uppercase

Oracle: bitmap index and deadlock-1 B-tree index are more suitable for indexing the OLTP environment of Dynamic tables, while bitmap index is more suitable for using complex query data warehouse environments in Large static tables. Bitmap index

Oracle has the following requirements to obtain the date after a certain interval: 1) display the time after the current 1.5 days. 2) display the time six hours later. 3) display the time six months later. 4) display the time after the current 10

The process executes DDL statements to prompt ORA-01031 errors [SQL] -- create test user create user hat identified by hat default tablespace doldolphin; www.2cto.com -- grant permissions grant connect, resource to hat; -- view the role permissions

View oracle job information view related Oracle job information www.2cto.com 1. View related dba_jobs all_jobs user_jobs dba_jobs_running contains information about running Oracle job 2. View related information www.2cto.com SQL> SELECT JOB,

When Oracle PL/SQL compares the two fields to determine whether they are the same in Oracle PL/SQL to determine whether the two fields are equal or not, it often appears that the field values are obviously not equal (a blank, is not null), but TRUE

Redo01.log, redo02.log, and redo03.log are online files, which are first stored in logs. After full storage, they are stored in redo02.log and then in redo03.log. After the storage is complete, they are stored in redo01.log cyclically (covering: the

In linux, emca re-build EM in oracle. If you change the machine name, you can re-create EM. Generally, you do not need to re-configure emca to re-create EM [oracle @ dev ~]. $ Cd/u01/app/oracle/product/11.2.0/dbhome_1/bin www.2cto.com recreate an EM

Oracle uses log recovery and archive mode to modify archive Mode Modify logs // view the archive mode www.2cto.com archive log list; // view the archive parameter show parameter db_recovery // log archive path: F: \ oracle \ product \ 10.2.0 \

Transaction locks in Oracle (locked tables and locked sessions) Today I learned another trick to view the transaction locks caused by abnormal session exits in Oracle Database: 1. view the locked table SELECT B. owner, B. object_name,. session_id,.

Oracle sorts Chinese characters before oracle 9i by default. several new options are added for 9i: www.2cto.com sorted by Chinese pinyin: SCHINESE_PINYIN_M sorted by Chinese radicals: SCHINESE_RADICAL_M sorted by Chinese strokes: SCHINESE_STROKE_M

Oracle obtains the table storage location and creates the tablespace C: \ Users \ Administrator> sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Friday March 1 17:16:09 2013 Copyright (c) 1982,201 0, Oracle. all rights reserved. enter the User

Oracle Database Data export dump: Java code www.2cto.com in linux [root @ infodb111 ~] # Su-oracle [oracle @ infodb111/] $ mkdir/oracle/dump_dir [oracle @ infodb111/] $ sqlplus/as sysdba SQL> create directory dump_dir as '/oracle/dump_dir '; SQL>

Oracle commit detailed usage commit working process before commit is submitted Oracle generates a revocation record in the SGA undo segment buffer, the undo record contains the old value www.2cto.com for updating and deleting table rows. Oracle

Update the stored PROCEDURE of blob fields [SQL] CREATE OR REPLACE PROCEDURE (p_table_name IN VARCHAR2, -- table name p_blob_field_name IN VARCHAR2, -- blob column name p_where_condition IN VARCHAR2, -- primary key p_id IN VARCHAR2, -- id

The Oracle log file is accidentally deleted to solve the problem of the Directory www.2cto.com 1... 2 1.1 accidentally deleting the log file... 2 1.2 Oracle cannot connect... 2. General solution... 2 2.1 SYS log on to the database... 2. 2.2 shut