Oracle

Link: Oracle notes (1) Oracle introduction and installation: http://www.bkjia.com/database/201209/154049.html#oraclenote (2) SQLPlus command example (3) Scott user's table structure example (4) simple query, limited query, and data sorting

In Oracle Database, the storage of null values mainly verifies the storage of null values of the number and varchar2 data types. First, we will introduce the structure of row piece, A rowpiece (not including cluster table and chain row) includes row

When installing oracle software in the oracle tar mode, if the operating system is the same, you can directly install the software tar. It should be noted that tar can be used only when all minor versions of the system are the same. Www.2cto.com can

Oracle rollup operations-group by group, and calculate the total rollup for use with goup by, group by group, and calculate the total. Provides information aggregation (similar to "subtotal"). ROLLUP greatly facilitates rollup operations during data

Oracle 11g restart uard undo restore environment: OS: centos5.5db: oracle11g datauardversion: 11.2.0.2.0 shrink data file size in primary ALTER DATABASE DATAFILE '/oracle/oradata/skatedb/undotbs03.dbf 'resize 1024 M; www.2cto.com will receive an

In Oracle, how can I use SQL to check whether the field contains Chinese Characters? Today, a colleague's data migration program has a problem. I didn't consider Chinese encoding characters. Because the migrated table has tens of millions of data,

Oracle function-based indexes, such as executing the following SQL statement: select * from emp where upper (ename) = 'King', even if an index is created on the ename, the emp table will be scanned in the entire table, And the ename field in the

Oracle cold backup operation manual 1 There are three standard backup and recovery modes for Oracle cold backup: Backup Recovery (physical) and Import/Export (logical ), backup recovery can be divided into non-archive mode (Nonarchivelog-style) and

The Oracle file system structure is as follows: the Oracle file system is mainly divided into the following four parts: 1> control file (. CTL) 2> data file (. DBF) 3> log file (. LOG) 4> the first three file systems of other files www.2cto.com are

Address oracle Database ora-00054: resource busy and acquire with NOWAIT specified error I found a midway card and then forcibly terminated pl/SQL developer after using the pl/SQL developer client to call the Stored Procedure for operations, oracle

Oracle FUNCTION [SQL] www.2cto.com create or replace function FUNC_AAC00215_18 (prm_aac002 varchar2) return varchar2 is ll_ I number (4): = 18; ll_row number (5): = 0; var_aac002 varchar2 (18); ll_sfz18 number (3); ll_sfz varchar2 (3); var_sfz18

Oracle database link connects to different database platforms in mssql, which is generally called a heterogeneous database service. Different vendors have different implementation technologies: in SQL SERVER, it is called a LINKED SERVER, use ODBC

Oracle 11g modified Chinese Character Set installed Oracle 11g found that Chinese characters are stored in the database and then changed garbled characters, use the following method to modify the database character set www.2cto.com D: \>

The execution permission of oracle stored procedures is an essential tool in the database system. stored procedures are a set of SQL statements pre-compiled to implement a complex function. I will not talk about its advantages. Let's talk about the

Basic knowledge of oracle Database PL/SQL 1) Overview: the programming language formed by oracle procedural expansion in the standard SQL language is a unique feature of oracle, languages that support application development. Www.2cto.com 2) Syntax:

Materialized views implement two-way synchronization of Oracle database tables there are many ways to achieve cross-Database Synchronization of Oracle database tables, such as triggers, Materialized View (MV), Stream, www.2cto.com Materialized View (

Common commands for Oracle to view table structures to obtain tables: www.2cto.com select table_name from user_tables; // select table_name from all_tables for the current user's table; // select table_name from dba_tables for all users; //

Date conversion in Oracle and Java date conversion in java date conversion to date summary in oracle: 1. Date attribute in Entity class is defined as String type. 2. Write the column corresponding to the date in the SQL statement as to_date (?,

Uninstalling an Oracle database is not as simple as deleting other software. Especially for new employees, when the database is deleted and re-installed, it is often re-installed, some inexplicable errors will be reported, or the installation will

Exp + parfile export the qualified record exp parfile = d:/test. par file = d:/back. dmp filesize = 2000 M log = d :/**. the purpose of logfilesize is to prevent some operating systems from supporting files larger than 2 GB, and the I/O performance