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
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
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,
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
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
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 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 ', '
--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 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
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
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
/*** 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
--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
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
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
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_
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