Oracle

First, download the Oracle database or my blog from the official websitewebsite address : Oracle DatabaseBlog Address : BlogSecond, the installation databaseNote: A 10g database is only valid on XP operating systems.It is recommended to install it

1. Install Oracle Oracle software is free and can be downloaded to the website to download the appropriate installation package. However, if commercial use is required to purchase license. Official online for various platforms, both 32-bit and

--1 CREATE VIEW Show_max_sal_name_view display the highest wage employee name and his salary create or replace view Show_max_sal_name_view asselect Ename,sal from SC Ott.emp where sal= (select Max (sal) from scott.emp), select * from

A NOT NULL constraint is a non-null constraint that often adds a non-null constraint when creating a table to guarantee that the field must enter a value(1) Add NOT NULL constraint when creating tableGrammar:CREATE Table table name (field type not

PhenomenonTake Sql/helper as an example, open a different SQL window and manipulate the same table as shown below.Window 1: Get a set of query results when you perform an update task, followed by a query. The result is right.Window 2: While in

1 Start-run-services.msc 2Locate the service Oracleoradb10g_home1tnslistener and ORACLESERVICEORCL Note the ORCL service name. these two areOracleThe two services that are required to start are automatically started by default the two services are

Log in to the connection using the Sqlplus toolStart-"Run cmd-" c:\users\admininstrator> sqlplus Please enter your username: [email protected] As SYSDBA enter password:rootsql> or direct input sqlplus sys/[ Email protected] as SYSDBA enterQuerying

Build table:SELECT * FROM fruit;create table fruit (id varchar (+) NOT NULL, name varchar () default "NOT NULL", price varchar () default ' NOT NULL, area varchar (+) default ' NOT NULL, PRIMARY key (ID)) INSERT into fruit (id,name,pri Ce,area)

ORA-01555 snapshot is too old, is a common error in the database, such as when our transaction needs to use Undo to build a CR block,And at this time the corresponding undo no longer exists, this time will be reported ORA-01555 error.Environment is

ORACLE queries one data table and then inserts two of the other tables by traversingGrammarThe first type:By using the Oracle statement block-- Specifies that all departments of the document can view DECLARE cursor table_dept is Select Id,uname

This article is only used for learning communication, commercial use, please support the genuine! Reprint Please specify: http://www.cnblogs.com/mxbs/p/6217151.htmlCreation of a databaseOpen "All Programs"-"oracle-oradb10g_home2"-"configuration and

Where Features:1. used to filter the data2, can be compared, logical operation3. Where needs to be placed behind from=========================================================First, the comparison operationThe comparison operation contains:> = 1,

/*merge into detailed introductionThe merge statement is a new syntax for merging the UPDATE and INSERT statements oracle9i.With the merge statement, another table is queried based on the join criteria of one table or subquery,The connection

One, operatorArithmetic operators: +-*/Can be used in SELECT statementsJoin Operators: | | Select Deptno| | Dname from Dept;Comparison operators:> >= =! = Logical operator: not and ORSet operators: Intersect, Union, union all, minusRequirement: The

Now there is a demand, the database of a hand to lose the ' birthplace ' field, in accordance with a certain standard interception display on the report, for example, if the ' birthplace ' of the content is: ' Shandong province Weifang Changle

--basic commands for creating triggersCreate or Replace TriggerTD afterDelete onSSbeginDbms_output.put_line ('Delete succeeded');End;--basic commands for creating triggersCreate or Replace TriggerDD AfterInsert onSS forEach row--no variable to

The original is here: Poke6 parametersThe first one is the string enteredThe second one is the regular expressionThe third one is the substituted characterThe fourth is to identify a regular expression match starting from the first few characters.

Group to re-query, and execute a function: Select group field, aggregate function from table name where Condition GROUP by Group FieldSelect group field, aggregate function from table name where Condition GROUP by Group Field having filter

1. Create a tableSQL code 650) this.width=650; "class=" star "src=" Http://1395573703.iteye.com/images/icon_star.png "alt=" Favorite Code "style=" border:0px; "/> Create Table Test ( ID VARCHAR2 (10), Age Number ); 2.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8B/77/wKioL1hO3NryZF4zAA0MYiOFZzY423.jpg-wh_500x0-wm_3 -wmp_4-s_3260271067.jpg "style=" Float:none; "title=" 20,161,212 Monday based on Windows 2012 deployment Oracle 12.1.0.2 RAC Adventures.