Oracle

Guest El Installation Security-delete Operating System Default Account oracle Installation in windows will add a system administrator account in the oracle account, at the same time, log on to oracle under the system management account, the user

What should I do if oracle forgets the password of sys/system/scott? I. Forget the login password of a user other than SYS and SYSTEM. Log On with SYS (or SYSTEM) USER: conn sys/PASS_WORD as sysdba; use the following statement to modify the USER's

Adding a shared disk to a VM supports ORACLE 10g rac. Because the original ASM shared disk capacity is small, it is impossible to mount the archive log and backup files. so I decided to add a disk. 1. Add a virtual disk to node 1 and place it in the

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 Database system user forgot password How to Do D: \ oracle \ ora92 \ bin> sqlplus/nolog SQL * Plus: Release 9.2.0.1.0-Production on Thursday August 16 11:32:22 2007 Copyright (c) 1982,200 2, oracle Corporation. all rights reserved. SQL>

In Oracle8i or a later version, you can create two types of temporary tables: 1. Session-specific TEMPORARY table create global temporary () on commit preserve rows; 2. TEMPORARY table www.2cto.com create global temporary () on commit delete

Oracle multi-table insert all statement: SQL code create table ORDERS (CUSTOMER_ID NUMBER, SUM_ORDERS NUMBER); create table small_customers (CUSTOMER_ID NUMBER, SUM_ORDERS NUMBER ); create table medium_customers (CUSTOMER_ID NUMBER, SUM_ORDERS

In oracle, the question of processing comma-separated fields using regular expression functions is really not easy to write. Its actual meaning is based on a scenario: www.2cto.com, for example, in an oracle table, there are two fields A1 B1 1 A, B,

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 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: \>

Plsql connection oracle database reported ora 12154 error today encountered a problem, using sqlplus can connect to a remote database, but the use of plsql is not connected, the error "ORA-12154: TNS: the specified connection identifier www.2cto.com

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 (

Oracle open port (cannot be connected through port ing) problem Oracle 9I is installed on Win2003, WIN2003 only opens port 1521, then remote telnet port 1521 can pass, but the database connection fails. The reason is as follows: www.2cto.com the

Solution after the dbf File of Oracle is deleted by mistake: www.2cto.com deletes the dbf file of the Oracle database by mistake. An error is prompted when the database is started or shut down. Startup prompts when starting the database: ORA-01157:

A solution that prompts "ORA-01788: This query block requires a connect by clause" when creating a remote materialized view on Oracle 11g maps a table on the remote server to a local materialized view, use the following statement: www.2cto.com ----

Select statement field connection (oracle), such as employee name, employee position, birth date, and so on in the employee basic information table. If the three fields in the current view are displayed in the same field, there is a delimiter in the

The character set name is not recognized problem after RMAN migration solves a test machine. Due to unknown system problems, the operating system needs to be re-installed, and a database is running on the machine, you need to create a database and

In Linux, a raw device is used to create an oracle tablespace. Today, a test is performed to create a tablespace in linux: 1. create logical volume: run # lvcreate-L 100 M-n vg30 vg02. bind the logical volume to the bare device as the root user:

Oracle Real-Time query resource consumption SQL 1. first, use the top command to view the pid Number with more resources in production. Note: For the oacle of the top Command user, follow the pid www.2cto.com 2. query the current time-consuming

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 (?,