Oracle

SelectDeptno,job,avg(SAL) fromEmpGroup byDeptno,jobOrder byDeptno;SelectDeptno,job,avg(SAL) fromEmpGroup byCube (deptno,job)Order byDeptno;SelectDeptno,job,sum(SAL),Grouping(DEPTNO),Grouping(Job) fromEMPGroup byRollup (deptno,job)Order

GrammarSelect ... from tablewhere filter conditionsThe constraints of the root node of start with query resultsConnect by connection conditions;ExampleCREATE TABLE Test (ID number,parent_id number,Name VARCHAR2 (100));Assume that the root node ID is

Oracle starts from scratch and is overwhelmed. The best way to master a skill is to learn how to use it, then learn it in depth, first look, then technology.One, what is a database? Why do I need a database?A database is essentially a list of

Graphic:650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7D/E9/wKiom1byaTrTaGaeAAAynMsaJSQ000.png "style=" float: none; "title=" 1.png "alt=" Wkiom1byatrtagaeaaaynmsajsq000.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7

"IT168 comment" In many cases, we will need to insert a large amount of data into a table, and want to complete the work in as short a time as possible, here, and you share some of my usual experience in doing a lot of data insert.Premise: Before

--① Creating a directoryCreate or ReplaceDirectory Oracle_test as 'd:\\testtmp'; --② Stored ProceduresCreate or Replace procedure proc(Stuid Tb_student.stuid%type, Stuname tb_student.stuname%type, stuage tb_student.stuage%Type ascou Number;--Insert

I. VARCHAR2 (10) and number should be converted why type?When Oracle turns into MySQL:VARCHAR2 (10) can be turned into varchar (10)Number depends on what type of data is stored in Oracle:1, if the integer type, then MySQL, with an int can be;2, if

Declare --Defining VariablesV_enamevarchar2(5); V_sal Number(7,2); begin --Executive SectionSelectEname,sal intoV_ename,v_sal fromEmpwhereEmpno=&AA; --Display the user name in the consoleDbms_output.put_line ('the user name

Flash-back technology was introduced in oracle10g, but this does not mean that all tables will be successful, and when there is not enough disk space, Oracle uses disk space in the Recycle Bin, and the bitmap connection index and referential

Conversion from row to Column--- Create table tb (name varchar (10), subject varchar (10), result int); insert into tb values ('zhang san', 'China', 74 ); insert into tb values ('zhang san', 'mat', 83); insert into tb values ('Li si', 'China', 80 );

Advantages and disadvantages of using SQL GUID and auto-increment columns as primary keys [reprinted], sqlguid All databases in our company use GUID as the primary key. Many people are used to using int as the primary key. So here we will summarize

How to import Oracle12c database to 11g, oracle12c11g The packages backed up from oracle 12c (expdp) are restored to 11 GB. We all know that there will be compatibility issues. Sure enough, an error is returned: ORA-39142: Version 4.1 (in the

OracleEBSLOV Speed Optimization I. symptom When the SQL statements of our EBS LOV are complex, or the data volume is large, the LOV pop-up display speed, or directly fill in the ticket number and move it to another input box (when the Validate

Create a tablespace in oracle and assign user permissions. 1. create temporary tablespaces (temporary tablespaces are mainly used for sorting operations in the database [such as creating indexes, order by and group by, distinct,

Oracle Database 10g basic learning (1), oracledatabase Oracle was overwhelmed from scratch. To master a skill, the best way is to first learn how to use it, and then study it in depth. First, there will be technology.   1. What is a database? Why

Oracle 12C database imported to 11 GB The packages backed up from oracle 12c (expdp) are restored to 11 GB. We all know that there will be compatibility issues. Sure enough, an error is returned:ORA-39142: Version 4.1 (in the dump file forks. expdp)

Oracle Study Notes series ------ usage of basic functions of oracle basic operations, oracleexists usage   -- CREATE an accout account table create table account (id NUMBER (9) not null, recommender_id NUMBER (9), login_name VARCHAR2 (30) not null,

Detailed tutorial on installing and configuring Oracle databases on CentOS, centosoracle I. basic configuration 1. Remaining hard disk space: 10 Gb or aboveAlthough the 10 Gb Installation File of Oracle is only over 800 MB, the installed oracle +

Oracle learning notes series ------ basic oracle operations and basic oracle operation statements   -- CREATE a table create table employee_souvc (id NUMBER (4), name VARCHAR2 (20), gender CHAR (1), birth DATE, salary NUMBER (6, 2 ), job VARCHAR2 (30

Oracle client ORA-12541: TNS: no listeners, ora-12541tns 1. Question description: If you are setting the oracle client to add a local network service, you may see the dialogue that show you the message (Oracle client ORA-12541: TNS: No listener ).