Oracle

DescriptionCopy the following command to the CMD command line to run, file stands for file nameData importImp zzbweb/[email protected] file=e:\zzbweb.dmp fromuser=zzbweb touser=zzbweb rows=yData exportExp Vote/[email protected] file=f:\vote.dmp rows=

SELECT DISTINCTT.id,P.palias,CNameC.currency_unit,T.company_name ISP,--operator nameT.code Buessies,--Downstream customer nameT.country_code,--Country codeT.price,--PriceT.country,--Find out the country' 1 ' gamecode,To_char (t.receive_time, '

In the 1.sccot.emp tableEnquiries about the number of companies, as well as the number of employees employed in 80,81,82,87 year, results similar to the following formatTotal 1980 1981 1982 1987---------- ---------- ---------- ---------- ----------14

A view is a table that is exported from one or more base tables, and is a "private table" of users that are extracted from an existing base table and composed of several subsets. base table: The definition of a base table refers to the establishment

descriptionA database trigger is a stored PL/SQL program that is associated with a table. Whenever a particular data manipulation statement (Insert,update,delete) is emitted on a specified table, Oracle automatically executes the sequence of

3. External connectionAn outer join is a result set in which a record in a join table that does not conform to a join condition is added on the basis of an inner connection. The outer joins are divided into left outer connection, right outer

%TYPE is used in the declaration of a variable to obtain the field type in the table;%rowtype is used to declare a row type based on a table;Example:%rowtype useDECLARECURSOR Pdct_curIs SELECT * from ProductInfo;CUR_PRODCRD

When installing Oracle, it is possible that the installation failed because we did not allocate enough swap space. The process steps are as follows:Swap space is 2G[[email protected] oracle]# free total used free shared buffers cachedmem:203900      

The first time you install Oracle, there is no problem at all,But when I went to configure Oracle_home, I entered the database configuration Assistant by mistake,Then configure the existing database, there is a problem, pop up the above dialog box,

1. Creation of three filesExp.list content:user name and password forOracle DatabasePwdExp.log is primarily used to store log information when the database is automatically backed upexp.sh#!/bin/SH#找到数据库的路径export oracle_base=/u01/app/Oracleexport

In the Oracle database, connection queries are divided into 3 types: cross-connect, inner-join, and outer-link. The cross join result is a superset of all the other connection results, and the result of the outer join is the superset of the inner

1. Create a tableNo constraintCREATE TABLE T_user (ID number,--type is number typeName Varchar2 (),--varchar2 () can varyGender char (2),Birthday Date Default sysdate is the current day)Plus constraintsCREATE TABLE T_user2 (ID number,Name VARCHAR2

The purpose of the UNION directive is to combine the results of two SQL statements to see the results of the query you want.For example:SELECT Date from Store_informationUNIONSELECT Date from Internet_salesNote: In the Union usage, the field types

1. Common functions1) Character functionLower all converted to lowercase select lower (' HELLO ') from dual; -->helloUpper all converted to uppercase Select upper (' Hello ') from dual; HELLOConcat Connect two strings of select concat (' Hello ', '

I contacted Oracle in 2005, has been more than 10 years, from a layman to today, to become a just door to the layman, all the way to the ups and downs without words. Today do not talk about grammar, do not talk about semantics, do not talk about

1. Title: Find employees who pay more than the average salary of the department.Select ename from EMP E1 where sal> (select AVG (SAL) from EMP E2 where E1.deptno=e2.deptno);2. Title: Find employee information for the top three employees in the

1.oracle sign-in and logoutGo to cmd command line:Login to normal user--1) sqlplus scott/169500 Note: Scott is the user name (this is the Oracle comes with the user) 169500 is the password2) Sqlplus drawdownEnter user name: ScottEnter Password: 16950

Create a temporary table spaceCREATE Temporary tablespace test_tempTempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf 'SIZE 32MAutoextend onNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;Create a user table spaceCREATE tablespace

Original address: http://www.cnblogs.com/252e/archive/2012/09/13/2682817.htmlQuery and delete duplicate records of the SQL statement  1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the  select

Usage to_char (sysdate, ' yyyy-mm-dd HH24:mi:ss) turns the time into a stringUsage to_date (' 2015-08-12 15:53:37 ', ' yyyy-mm-dd HH24:mi:ss ') turns the string into timeUsage to_number to turn a string into a numberUsage Trunc is responsible for