Oracle

Brief introduction:Greenplum is a database repository based on the MPP architecture developed by PostgreSQL database, which is suitable for OLAP systems, and supports the storage and processing of 50PB (1PB=1000TB)-level massive data.Background:One

Create a sequenceCreate sequence Sq_teacher_tnoStart with 10 from which numberIncrement by 1 number per growthMaxValue 999999999999999 Maximum allowable valueCycle/nocycle whether the loopCache/nocache 20 is cached--Create a sequenceCreate sequence

This theme green/colorEnd of function Be sure to return a value that matches the declaration using the return statement--Syntax:Create[or Replace] function [(parameter list)]Return data typeIs|as (is or as is fully equivalent)[local variable

Create a logical directory that does not create a real directory in the operating system, preferably with system, etc.ManagementCreated by the administrator.Create directory Dpdata as ' D:\test\dump ';Second, view the Management Manager directory

Oracle Use Java source Calling external programsDemandOracle calls third-party external programs. Oracle uses SQLULDR2 to quickly export large quantities of data and then use WinRAR to compress and send messages.Original codeJava sourceCreate or

Oracle 11g installation1. Unzip the downloaded package, then enter the package and click Setup.exe to start the installation.2. Appear as follows: Generally, the small check is canceled, click on the next step,Pop this back dot ' yes '3. After

SELECT * from v_$circuit; view logical loops, share server connections, use Easy connect to displaySELECT * from V_$dispatcher; General configuration of threeOperation in SqlplusShow Parameter DispaAlter system set dispatchers= ' (PROTOCOL=TCP)

In order to transform the Sqlsugar ORM into a oraclesugar orm, I would like to take a day off, with the experience of not looking at any Oracle data directly strong, but from the configuration plsql and some grammatical differences brought a lot of

Using NVL (A, B) General function, statistical employee annual income, NVL () acting on any type, ie (number/varchar2/date)General function: The parameter type can be number or varchar2 or date typeSelect ENAME,SAL*12+NVL (comm,0) from EMP;650) this.

Oracle Database Overview 1.1Oracle structure Diagram1.1 How to access the databaseA. this machine accesses the IPC UDP protocol directly via sock(socket) , does not require networkB. establishing a connection to an Oracle server via TCP1.2

What subqueries do: things that are unknown to the query conditionProblems with known query conditions: For example: Query employee information for payroll of 800An issue with an unknown query condition: For example, to inquire about employee

MySQL's variable is required to implement line numbers, because MySQL Wood has rownumber.The variable definition in MySQL can be usedSet @var =0OrSet @var: =0can be used = or: = both, but if the variable is used in other statements, such as: Select

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.First look at the current process of the target user, note is serial# instead of serial, the introduction of the Internet Missing #:Select sid,

Find employee information for unit 20th in the EMP tableSELECT * from emp where deptno = 20;The query name is Smith's employee, the string uses ' ', the content is case sensitiveSELECT * from emp where ename = ' SMITH ';Summary: Which of the

Query Employee information (number, name, salary, annual salary), sorted by monthly salary, ascending by default, sorted by Oracle built-in check rule if monthly salary is the sameSelect empno,ename,sal,sal*12 from emp order by SAL ASC;Query

Usually we develop the use of 32-bit PC, so the installation is also ORACLE32-bit client. However, the general server is 64-bit, and the 64-bit Oracle client is installed, and you may encounter version problems if you are deploying an application

How to use ForAll and bulk collect:1. Using ForAll is more efficient than for, because the former switches only once to the context, while the latter switches between multiple contexts in the same number of cycles.2. Using Bluk collect to fetch a

The job's interval is set to sysdate+1 results A lot of customers this time will eventually become a mess of eight bad,or import, or manual execution, and so on, there will be automatic change, and many,Felt somehow, andToday, the Internet search,

Java code Create sequence Person_seq Start with 1 Increment by 1 Order--sequentially Nocycle--no loops, no repetition. ; INSERT into person values (Person_seq.nextval,null, ' Iteye); Delete from person; Update person

Oracle Starter Case:1. Create an entity class student and override the ToString method Packagecn.happy.entity; Public classStudent { PublicInteger getId () {returnID; } Public voidsetId (Integer id) { This. ID =ID; } PublicString GetName () {