Oracle

DB Notes (Oracle)A Oracle installation, service startup, database setup, user establishment (skip).Two SELECT statement:(i), single-line function:1. Expressions and null calculations, the result is null, that is, no display (that is, the data is

Oracle resets the self-increment sequence to the initial value of 1 o'clock, and if it is removed and rebuilt, then the functions and stored procedures that depend on it are invalidated and need to be recompiled. The inverse process is used to

A data query uses the SELECT command to extract information from a table in a database.Syntax structure: Simple querySELECT *| Column name | expression from table name WHERE condition ORDER by column nameSyntax parsing:* represents all columns in

Classification statistics are used more often to count the number of items or the number of items under an item.Simple, such as a table tab_testTab_test Records Id Co Name Job 1 Ibm JACK

Sign (?) represents the ORACLE_HOME environment variableegsql> ALTER tablespace TEMP ADD datafile '?/dbs/temp02.dbf ' SIZE 200M;Sign (@) represents the ORACLE_SID environment variableegsql> ALTER tablespace tablespace_name ADD datafile [email

Oracle gets a list of months between a time periodGet a list of months between a time period (example returns a list of months from 2009-03 to 2010-03) SELECTTO_CHAR(ADD_MONTHS(TO_DATE(‘2009-03‘,‘YYYY-MM‘),ROWNUM-1),‘YYYY-MM‘)

When settling the table, it appears.ORA-01658: Cannot create INITIAL zone for a segment in tablespace MAXDATAThis problem occurs because the size of the table space is not enough, you can give him the capacity to expand this will be more than a data

First you need to create a table space, and then create a user name, the user name to give him a table space, and give the user permissions,DBA: Has full privileges, is the highest system privilege, and only the DBA can create the database structure.

Oracle quickly clears table dataA: IntroductionDelete table data generally there are three commands, truncate, delete, drop, but their execution, efficiency and results are different, such as deleting the 500W record level of data, the three are

1) Display definition record type;Declare--Display defines a record type MyrecType Myrec is RECORD (Combine_no VARCHAR2 (10),Department_code VARCHAR2 (11));--Declaring a variable RCD of the Myrec type;RCD Myrec;BeginSelect

The following section explains the functionality of a table in the Oracle database, which stores successive time records, and also stores a tag bit.Now you want to get a result set: When the mark bit is 0 o'clock, take the previous 1 time data, and

Http://www.cnblogs.com/hanyun/archive/2009/05/14/1456772.html1). When using Oracle's To_date function for date conversion, it is possible to intuitively convert in "YYYY-MM-DD HH:mm:ss" format as a format, but in Oracle it causes an error: "ORA 01810

ORACLEBIEE Installation Tutorials1.1.OBIEE Overview1.1.1.BIEE HistoryBiee:oraclebusinessintelligenceenterpriseeditionOracle acquired Siebel at the end of 05 and took its front-end development tool Siebelanalytics as a new platform for Oraclebi.

Date functionSysdate-- Current system Time Select from dual;EXTRACT-- get Current year Select Extract (year from from-- years Select Extract ( month from from– month Select Extract (Day from- - DayTo_date--Convert a string to a dateSELECTTo_date (

1. Restore to a certain momentInsert into Select * from as oftimestamp to_date ('2014-12-29 08:30:22' ' YYYY-MM-DD Hh24:mi:ss 'Where Qual_temp_detail is the name of the data table to be rolled back. The first parameter of the To_date function is

One, the string functionLENGTH (CHAR):SELECT LENGTH ('abc def GH' from dual; -- gets the length of the string that contains the space result:CONCAT (CHAR1,CHAR2)SELECTCONCAT ('ABC','def') fromDual--Connect two stringsResults:'abcdef'SELECT

I. DML data Manipulation languagePrimarily used to retrieve, insert, and modify database information. It is the most commonly used SQL command, such as insert (insert), UPDATE, select (select), delete (remove).　　1. Insert Insertion Statement:Grammar:

Java Oracle Stored Procedure ProblemsPL/SQL is an extension of ORACLE's standard database language. ORACLE has integrated PL/SQL into ORACLE servers and other tools, in recent years, more developers and DBAs have started to use PL/SQL. This article

Specified Date query data base 1. First, introduce the to_char function. TO_CHAR converts a date or number to a string and cannot specify the string length.Use the TO_CHAR function to process the date:TO_CHAR (number, 'format') for example:

ORACLE-005: Create a JOB (1) Jobs are widely used in practical applications. Generally, you can regularly execute certain functions and stored procedures. The following describes how to create and start a JOB. For example, you can use a job to