Oracle

Oracle note (16) link to the database design paradigm: Oracle note (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

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

In Oracle, use SQL _TRACE to trace SQL Execution. When you execute an SQL statement very slowly, do you want to ask Oracle how to execute this statement? The SQL _TRACE tool provided by Oracle allows you to know exactly what the SQL statements you

The extension of the oracle insert statement sends a shotgun to a table: (1) insert into table_name [(column [, column...])] select_statement can only insert one table at a time, but the performance is higher than writing multiple insert statements.

During the course of this semester, the teacher asked us to install the Oracle9i database and practice the installation of the two classes. So it was easy to install, but our data center already has oracle, so the teacher asked us to uninstall it

The usage of the trunc function is summarized. During this period, the roaming and call data of the previous month will be counted. Use the trunc function. Trunc (datetime [, fmt]); 1. select trunc (datetime, 'yy') from dual; ------------------------

What should I do if I forget the password of an ORACLE user? What should I do if I forget the database in use? I only remember the administrator password. Modify the following statement (the blue part is the typed command): SQL * Plus: Release 11.1.0

Overall structure of the oracle databaseDatabase Structure In fact, I introduced the database structure in the previous article about tablespace, but the figure is just a simple hierarchy. This picture looks quite complicated, just focus on several

Oracle PASSWORD expiration and lock settings query settings of the DEFAULT profile PASSWORD Expiration parameter SQL code select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME '; www.2cto.com PROFILE RESOURCE_

ORA-01843: Invalid month issue execute the following script create table myemp (EMP_ID NUMBER, EMP_NAME VARCHAR2 (10), sal number, Joined_date DATE, DEPT_NO NUMBER ); www.2cto.com insert into myemp values (3, 'three ', 1500, To_Date ('01-MON-2007', '

Common processing methods for NULL values in Oracle sorting 1. Oracle determines by default that null is the maximum value when processing Order by. Therefore, if it is ASC, it is placed at the end, DESC ranks first in descending order. 2. The nvl

Oracle executes a scheduled task every day to create a test table SQL> create table a (a date); www.2cto.com has been created. Create a custom process SQL> create or replace procedure test as 2 begin 3 insert into a values (sysdate); 4 end; 5/the

1. Original data column: mobile phone number, date, quantity 2. decode query result column: mobile phone number, total number in December October 1, and total number in December October 2... Total number of December 2012 select distinct recommender,

Oracle row-specific function listparts () This is an Oracle row-to-column function: listparts () www.2cto.com first look at the sample code: SQL code with temp as (select 'China' nation, 'guangzhou' city from dual union all select 'China' nation,

The NTILE function of the oracle analysis function divides the ordered result set in a data partition, groups it into buckets, and assigns a unique group number to each group. This function is useful in statistical analysis. For example, if you want

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 $

Oracle recursive operations (Tree operations) start with org_id = '1' connect by prior parent_id = son_id 1. preface oracle recursive operations are often used in the directory structure on our web pages. It is said that they are frequently asked

User test lacks create session privilege logon denied solution: create a user test in the oracle database. If the permissions assigned to test are insufficient, the user test lacks create session privilege logon denied will be prompted when you log

Resets the oracle sequence from the specified number. The SQL code www.2cto.com declare n number (10); v_startnum number (10): = 10000001; -- the number of v_step numbers (10): = 1; -- step tsql varchar2 (200); v_seqname varchar2 (200): = 'mip _

Oracle Data Block Structure Analysis oracle data block is the smallest unit of database storage, generally N times the operating system block. Its structure is: www.2cto.com block header --> empty row --> data, which is actually a vertical row