Oracle

Oracle notes (14) user management links: Oracle notes (1) Oracle introduction and Installation http://www.bkjia.com/database/201209/154049.html ; Oracle notes (2) SQLPlus command http://www.bkjia.com/database/201209/154051.html Oracle note (3) Scott'

Flashback six major technologies: flashback transaction query and flashback table environment: [SQL] 15:25:40 hr @ ORCL (^ ω ^) select * from v $ version where rownum = 1; BANNER implements Oracle Database 10g Enterprise Edition Release

Processing Solution for archiving logs due to too small flash_recovery_area: [SQL] 14:13:26 sys @ ORCL (^ ω ^) select * from v $ version where rownum = 1; www.2cto.com BANNER issue Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod the

SQL connection introduction (natural connection, internal connection, external connection) oracle: natural connection (natural join) :( natural join is not supported in SQL server) the natural connection automatically identifies columns with the

ORA-28002: the password will expire within 10 days solution [SQL] solution: [SQL] 1. query this user's perfile file select username, profile from dba_users where username = 'Scott '; www.2cto.com 2. select * from dba_profiles where profile =

The simple implementation of column-to-row aggregation is required in the ORACLE WM_CONCAT listparts function project. The associated data is automatically aggregated by a specific field. Example: 1 B11 B21 B32 B42 B53 B6to www.2cto.com 1 B1, B2, B32

ORACLE is successfully installed on Redhat 5 in the morning in the archive mode of ORACLE. The archive mode is not enabled during database creation. SQL> select name, open_mode, log_mode from v $ database; NAME OPEN_MODE LOG_MODE --------- begin ----

Restart the Oracle database command to restart the database (two database instances and listening services need to be started) execute the following command to require oracle users. If the current user is root, switch to the oracle user first. The

Oracle spool learning summary common spool settings set colsep ''; // set echo off, a domain output separator; // display each SQL command in the start script. The default value is onset feedback off; // display the number of records processed by

ORA-01810: format code appears twice (the to_date () function in Oralce is used to convert a string to a date object) The to_date () function in Oralce is used to convert a string to a date object, the specific format is to_date (string,

Oracle query statistics by day, week, month, quarter, and year // select count (dataid) as daily operation count by day, sum () fromwheregroup by trunc (createtime, 'dd') // select to_char (date, 'iw'), sum () from where group by to_char (date, 'iw')

The difference between Oracle DBConsole and Oracle Service SID indicates the name of the oracle instance. Generally, the SID is: ORCL oracleDBConsole is the service of SID corresponding to the OEM db console of the database. if the SID

Delete archive log _ ORA-00257: archiver error. Connect internal only, until freed problem ORA-00257: archiver error. Connect internal only, until freed this issue is because the archive log is full. Solution: www.2cto.com SQL> select * from V $

Create a tablespace in the Oracle database and specify a tablespace for the user. The SYS user logs in as a DBA under CMD: run sqlplus/nolog www.2cto.com in CMD and then onn/as sysdba // create temporary tablespace Java code create temporary

Oracle and MySql functions for string truncation Oracle: 1. truncates the string before a character (excluding the character) in the string select Substr (P. SCHEDULE_CODE, 1, Instr (P. SCHEDULE_CODE, '(', 1)-1) from M_SUB_TASK_SCHEDULE_LOG P; 2.

Oracle tool: show_space introduction create or replace procedure show_space (p_segname_1 in varchar2, p_space in varchar2 default 'manual', p_type_1 in varchar2 default 'table', p_analyzed in varchar2 default 'n ', p_owner_1 in varchar2 default user)

Steps for processing SQL statements in Oracle Database SQL statements are as follows: www.2cto.com 1. parsing 1. When parsing SQL statements, run the syntax check first. Check whether the statement complies with the specification. 2. At this stage

Oracle 10gr2 environment variable configuration script, rhel5 passed the test #! /Bin/bash www.2cto.com ### the script to install oracle10g on rhel5 !! # Show notes! Echo-ne "The script is writed by xtao @ sinoinfo! \ N "SPATH

Connect by prior start with is often used when a table has a recursive relationship. For example, we often store a complex directory tree in a table. You can also store some departments in a table, and these departments are affiliated with each

ASM: How to Handle ORA-15063 errors [SQL] www.2cto.com idle> startup ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ORA-15032: not all alterations shortmed