11th Day of Oracle Learning

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 good to use, 19 inches better than before. The new office decoration is almost, every day the company has pictures, feeling or quite a grade, but also bought a 5000-piece coffee machine ...

At night passing the barbecue stall, casually eat some, 60 pieces ... Last time Eat and Lo Mei also about 50 yuan, now things are too expensive ... My concept of consumption still remains ten years ago. Say 10 years ago, is not 2006 years? At that time still in school looking forward to the future, life is full of possibilities ...

Still struggling to see some oracle tonight.

1, with: This seems like MSSQL, equivalent to temporary table

2, analysis function: seems to be MSSQL "open window"? The original sum () can only get a summary, using the over, to get the statistical process (line of accumulation)

Over (PARTITION by)

Over (ORDER by)

3. RANGE: Logical Offset

Unbound, following, do not understand, first probably look at it

4, RANK, Dense_rank, First, last, First_value, Last_value, LAG, lead, row_number

Rank and Row_number are some of the more common ones.

5, Row to column:

DECODE, PIVOT, UNPIVOT

6. Data level: connect_by

11th Day of Oracle Learning