Oracle

Oracle architectures include: Instances (Instance), database files, user processes, server processes, and other files.1.ORACLE instance (instance)1). To access the database, you must first start the instance, allocate the memory area when the

How to configure Oracle data source today:1, the need to install Oracle client, if the error check, the anti-virus software all exit and then reinstall;2, after the installation is completed, run ODBCAD32 (64-bit), in the ODBC interface can find the

Many posts on the internet areCommands to start and close related services# su–oracle$ crs_start–all--Start all CRS services$ crs_stop–all--Stop all CRS services$ crsctl Start CRS--Start CRS service$ crsctl Stop CRS--stop CRS service$ srvctl Start

1, first to the Oracle website download Instant Client, if there is an old version, you do not have to download Download back is a compressed file, extracted after the folder called: D:/instantclient_11_2. Put it in your favorite directory. For

Recently contacted Oracle, the idea of this database is very good, the learning process, encountered a lot of small problems. Perhaps the same hint, at different levels, means different solutions.When I use the create table Chem_dict_hello as select

Today, we meet a statistic that asks for all the days of the month, and if the result of one day is 0, it needs to be shown, namely:Date Trade Count transaction amount2009-4-01 1 102009-4-02 2 202009-4-03 0 02009-4-04 5 50At first I used the left

ORACLE11G modified the log system, not the use of Oracle9 Alert_$oracle_sid.log log, modified to Diag Alert and Diag trace two directories to save the XML format and text format of the log, the two directories are placed in/ Oracle/oracle/diag/rdbms/

Environment: MyBatis + oracle11g R21. Use Direct path insertion ("/*+append_values */" in the following SQL statement) and use keyword "union ALL": INSERT INTO/*+append_values */ T_ Uid_code (C_uid_code, C_serail_len,

First build the table:--Student Table (school number, name, gender, date of birth, grade, telephone, home address)CREATE TABLE Student (Stuno Number (5,0) primary key,--study No.Stuname VARCHAR2 (+) NOT NULL,--NameSex char (2) The default (' Male ')

The full execution order of the SQL SELECT statement:1. The FROM clause assembles data from different data sources;2. The WHERE clause filters the record rows based on the specified criteria;3. The GROUP BY clause divides the data into multiple

Today, we summarize the task Queue Manager for Oracle, which is also easy to query later.There are two ways to do a timed mission.One is: Operating system timing, win timed tasks, Unix crontabOne is: database-level timing, she's more efficient,There

Not NULL non-null field +not nullUnique onlyPrimary key primary key (ensure data cannot be duplicated)FOREIGN key foreign keyCheck mustDrop purge completely removedCascade Delete: Delete A department, the staff in the department then delete the

1.select * from Dba_users; --Querying all users in the database2.GRANT SELECT on TableName to username;--authorization query (delegate the query rights of the table TableName to UserName)Grant insert on TableName to username;--authorization

Symptom: The Oracle database for the Windows operating system, which uses a sqlplus connection (without specifying the instance name), connects quickly, and it takes about thirty or forty seconds for the program to connect or to use the connection

There is no automatic growth type in Oracle, but there are sequences that can replace the auto-growth type;Sequence: is a database object provided by Oacle to produce a series of unique numbers.L automatically provide a unique valueL Shared objectsL

Cursor classificationAn implicit cursor:For select: Into ... Statement, only one data can be fetched from the database at a time, and for this type of DML SQL statement, the implicit cursorSelect Update/insert/delete operationTo display a

Oracle Stored procedures:Grammar:CREATE [OR REPLACE] PROCEDURE procedure_name(Arg1 [Mode1] datatype1,arg2 [Mode2] datatype2,...)is [as]PL/SQL BLOCK;Mode is used to specify input and output parameters: In for input parameters, out for output

　　This blog is their own in the study and work on the way to accumulate and summarize.Convert Arabic numerals to Chinese characters, method custom function　　　　Create or Replace function Formate (valinchNumber )returnVarchar2 isRes VARCHAR2 (6);

Http://www.dba-oracle.com/t_find_size_schema.htmQuestion: How does I find the size of a schema in my database?Answer:  It depends on what you define "size". If you want the total disk space consumed by the schema (including indexes, tablespace free

Orange + soda = orange soda, ∑ (? д?ノ) Dentetsu good boring!!!Turkey + Grill = roast turkey,? (´?`?) Not bad.Wm_concat () + table field query = (?ω?) What would it be? The Wm_concat () function, which separates the column values by the ","