Oracle

--Table Space usage QuerySELECT TBS table space name,SUM (totalm) total size M,SUM (USEDM) has used space m,SUM (REMAINEDM) remaining space m,SUM (USEDM)/sum (Totalm) *100 percent used,SUM (REMAINEDM)/sum (totalm) *100 remaining percentageFrom

First, Oracle common related SQL statements1. Connect to the databaseSu-oracle-c "Sqlsplus User/Password Note: First time login with Sqlplus/as SYSDBANote: Close the database: Note: Shutdown can be turned off option, from the mildest to the most

Sometimes you need to restart the Oracle database on Linux.Note Start the database first, and then listen on the startup database.Su oraclesqlplus/nologconnect/as sysdbastartup//exit Sqlplusexitlsnrctl start//shut down the database before opening

Reason and method of Oracle user being lockedBe told that the test user is locked when logging in1, with the DBA role of the user login, unlock, first set the specific time format, in order to see the specific timeSql> alter session set

CREATE TABLE CDPT (ID Number (6),Name VARCHAR2 (30),Constraint pk_id primary key (ID));Change the delay segment creation attribute of the database to false to execute this sentence in SQL plusALTER SYSTEM SET Deferred_segment_creation=false;Create a

1, reduce the burden of the network: through the MV data from a database distributed to a number of different databases, through multiple database access to alleviate the network burden on a single database. 2, build distribution environment: By

The simplest block:Begin Dbms_output.put_line ('hello,world'); End;This occurs when the execution results ( execution succeeds, but the string is not displayed ):The workaround is to execute this statement before executing the BLOCK: set

What is the cause of the large amount of empty data that sometimes occurs when you use the left association?This is because the field in the primary table is empty until the primary table is associated with another table, and then the field

1 , in the installation Oracle before installing the following component packages first, enter the following statements directly. Yum Install binutils*-yYum Install compat-lib*-yYum Install gcc*-yYum Install glibc*-yYum Install ksh*-yYum Install

Oracle View character set and modify character set:To view the character set of the database server:Select userenv ('language' from dual;Login with DBA:To stop the database:ShutdownTo start the database into the Mount state:STARTUP MOUNT;ALTER SET

--1. Query for employees with a higher than 7654 salarySELECT * from emp where sal> (select Sal from EMP where empno=7654);---2. Find employee information for minimum wageSELECT * from emp where sal= (select min (sal) from EMP);------------The name

I. Overview of Oracle Table spacesTablespaces are a logical structure in an Oracle database. From the logical level, the table space contains segments, the objects in the database are organized in the form of segments, such as table segments, index

1. There are two forms of case-when expression--simple case function case sex when'1'Then'male' when'2'Then'female'ELSE'other'END--Case search function Casewhen sex='1'Then'male'When sex='2'Then'female'ELSE'other'END2. When a case is used in a

MySQL imports data into Oracle.To build an Oracle table:CREATE TABLE"Gg_user" ("USERID"VARCHAR2(255BYTE) not NULL, "Ispart"VARCHAR2(255BYTE)DEFAULT NULL, "Actualpositionid" Number( One)DEFAULT NULL, "Beginworktime"TIMESTAMP(0)DEFAULT NULL, "BIRTHDAY"

Common group functions:1.ccount () to find out the total number of records.2.max () to find out a set of maximum values3.min () to find a minimum set of values4.avg () to find the average5.sum () summation--1. Statistics of Employees:Select COUNT

Preface: Learning Oracle Recently, so follow this classic book "Oracle Database 9i/10g/11g Programming Art" to learn.Configuring the Environment How to set up Scott/tiger demo mode correctly Environments that need to be built and run How

This week is working overtime, Flash again Thursday, every day overtime time to go fast. The company bought 3 23-inch display, Dell's, can be arbitrarily rotated. First gave me this project group use, do not know calculate a kind of reward ... It's

1. Standard SQL specification1 One, single if2 1,3 4 ifA=... Then5 .........6 End if;7 8 2,9 Ten ifA=... Then One ...... A Else - .... - End if; the - two or more if - - ifA=.. Then + ...... -Elsif A=.. Then + .... A End if; atThe middle here is "

Job ChainsCreateChainthe Order Create Chain object; define the steps in chain; Increase the rules; enable chain; Create a job that points to this chain. CreateChain ObjectExperiment Description:ENV :CREATE TABLE

Check the version of some packagesRpm-q gcc make binutils openmotif setarch compat_db compat-gcc-32 compat-gcc-32-c++ compat-libstdc++-33 compt-libstdc++- 296If not, install it.1) gz file similar to http://www.cnblogs.com/xiatian1071/p/3593283.html1.