Oracle Learning Article Five: Group functions, grouping statistics

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

Linux Oracle Import exports a single table (without a foreign key constraint)

EXPDP:Sql> Create directory Dir_tables as '/home/oracle/tables ';Sql> Grant Read,write on the directory dir_tables to user name;EXPDP system/system password @sid tables= user name. Table name Directory=dir_tables dumpfile=tables.dmp

9th Day of Oracle Learning

I have to work overtime on weekends ... Do a lot of learning, and continue to watch the tutorial tonight, multi-table query1, Cartesian product: Multi-table should pay attention to2, outside the connection: Before a record, that is (+) This writing,

Oracle Job Chain

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

Oracle Tools SQL

Querying tables in the lock tableselect     l.session_id sid,      l.locked_mode,     l.oracle_username,      l.os_user_name,     s.machine,     s.terminal,      o.object_name,     s.logon_time,      s.serial#  from     v$locked_object l,     

Oracle stored Procedures (1)

DescriptionCreating a stored procedure is much like writing a normal PL/SQL program, such as including the life part, the execution part, and the exception part. But there are a lot of differences between the two implementations, such as: Creating a

7th Day of Oracle Learning

Go home every day to play until 9:30 to say ...Today, another class in NetEase Cloud class, from a simple query began to talk about1, distinct to heavy, as if no difference2, alias, there is no difference3, arithmetic, same4, the connector, has seen

Oracle data types

Oracle text and format string mismatch resolutionDate-Time type for OracleRemember to use the To_date () method when inserting data into the date type of Oracle.such as insert into Cuslogs (STARTTIME) VALUES (to_date (' 2009-5-21 18:55:49 ', '

Oracle Custom row-to-column function

--row to column custom function, only for TABLE1 table--Paramtype is a parameter type that is used to determine that param1 and param2 are condition parametersCreate or Replace functionMy_concat (Paramtypeinch integer, param1inch varchar2,

Oracle creates table spaces and users

Oracle Tablespace and user creation1. Plsql, log in with Administrator account2. Create tablespace test datafile ' D:\test.ora ' size 1000m;--creating table space, test for tablespace name3. Create user test identified by test default Tablespace

oracle-copy table structure and table data

1. Copy table structure and table dataCREATE TABLE Table_new as SELECT * from Table_old2. Duplicate table structureCREATE TABLE Table_new as SELECT * from Table_old where 1<>13. Copying the specified fields of a tableCREATE TABLE Table_new as select

Oracle sorts in a specified order

Prior to the online search by the order in the specified sequence of methods, according to Charindex to deal with the sorting, but the Oracle found no, because Oracle has no charindex function, and then use InStr instead of charindex, and then on

Oracle operations.

/*** Copy any row in the Oracle table and change the corresponding sequence* /DeclareCursor Dept_cursor is a select * from Scene_pic WHERE picid= ' 63563908576556815641 ';BeginFor Dept_rs in Dept_cursorLoopDept_rs. picid:= ' 63563908576556815642

Java calls Oracle paging stored procedures

Java programs Packagecom.test;Importjava.sql.CallableStatement;Importjava.sql.Connection;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Types;ImportCom.jdbc.BaseJdbcDAO;Importoracle.jdbc.OracleTypes; Public classTest {/***

Oracle Build Table Exercise 2

--Create TableCreate TableCOURSE (CNOVARCHAR2(5) not NULL, CNAMEVARCHAR2( -) not NULL, TNO Number not NULL) tablespace USERS pctfreeTenInitrans1Maxtrans255Storage (initial 64KNext1M minextents1Maxextents Unlimited);--Add comments to the

Oracle Archive logs

Archive Log (Archive log) a non-active redo log backup. By using the archive log, you can keep all the redo history, when the database is in Archivelog mode and log-switched, and the background process arch will save the contents of the redo log to

Oracle Learning 1th, 2 days

Did not expect May full one months not to write essays, I always so, three minutes of heat, it is difficult to stick down. May almost no weekend, are working overtime, evening also often overtime, but fortunately, do not feel tired, but the Dragon

Oracle updates a large amount of data too slowly, and can be implemented by cursor examples

DECLARE CURSOR city_cur isSelect t.new_customer_id,t.old_customer_id fromCITSONLINE.CRM_CUSTOMER_TMP6 Twhere t.new_customer_id!=t.old_customer_idOrder BY new_customer_id;BeginFor my_cur in City_cur loopUpdate Platform.crm_service_customer_bak SSet s.

Oracle when the case is used at query time.

Select COUNT (1), Features_level from (SELECT i.features_level, I.features, t.baseamine_id, T.column_name, V.column_value, v.detail_id,(case when i.features = ' count ' and v.column_value = ' NG ' then 0 when ( I.features = ' metering ' and v.column_

Oracle SQL Error

Select T.YYDM,T.YYDJ,T.jsny,T.xzlbzh xzlb/*,(Select Item_nameFrom TB_DIC_FYSHJS_BBLBwhere item_id = T.xzlbzhand Valid_flag = ' 1 ') xzlbmc*/From (select YYDM,(select YLJGMC from tb_dic_ddyljg where YLJGDM = YYDM) YYMC,(Select YLJGLBMCFrom [email

Total Pages: 2147 1 .... 2120 2121 2122 2123 2124 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.