oracle for in It is more convenient for data processing of circulation
Because our usual operations often encounter cyclic data operations
Here's an example of the establishment
1.
begin
for item in 2..10 loop
dbms_output.put_line('the reuslt is '||item);
end loop;
end;
The output is as follows :
the reuslt is 2
the reuslt is 3
the reuslt is 4
the reuslt is 5
the reuslt is 6
the reuslt is 7
the reuslt is 8
the reuslt is 9
the reuslt is 10
2. Database related operations
The table created is as follows :
CREATE TABLE "APPSERVERUSER"."FIRSTCLASS"
( "ID" VARCHAR2(20 BYTE),
"NAME" VARCHAR2(20 BYTE),
"USERID" VARCHAR2(20 BYTE)
)
On going for loop The operation of the loop is as follows :
begin
begin
for i in (select id from firstclass) loop
dbms_output.put_line(i.id);
end loop;
end;
Pay attention to the i Be similar to oracle Of record It's a record
So when we use it, it should be :i.id
The output of the operation is as follows :
the firstclass id is :1
the firstclass id is :2
the firstclass id is :3
the firstclass id is :4
the firstclass id is :5
Flexible use of operation statements can provide many convenient ways for our daily operation .
end;
oracle for in Learn more about articles
- Oracle Learning notes of the course
Oracle Learning notes of the course ... ----------------------------------- Oracle course :--- Learning notes : ============================= ...
- 【oracle】 Introduction learning ( One )
Always wanted to learn oracle But they didn't make up their minds . I borrowed books this time , Be sure to learn oracle. Study at present <Oracle From entry to mastery > Tomorrow Technology Of Oracle 11g edition The basic theory of relational database Data model ...
- Oracle 12c Build learning
Oracle 12c Build learning Vm workstaton10 install linux 6.4 install oracle12c Oracle 12c Only support 64 Bit system 1 Environmental inspection [[email protected] ~]# gre ...
- Oracle data guard Study
Oracle data guard Study : Think twice about your notes Data guard 1data guard structure : data guard It's a collection , By a primary database ( Production database ) And one or more standby ...
- [ turn ]oracle Learning experience of implementing methodology
This week, new colleagues in the Department will share with us oracle Implementation methodology , This time focuses on the project kick-off meeting , And emphatically introduces oracle Different from us . It's a good harvest , A brief summary of several points worth learning from : 1. details ...
- ORACLE opatch Command learning practice
opatch yes ORACLE Developed to install , uninstall , testing patch Conflict . management ORACLE Tools for all patches that have been installed , Of course, it's a command tool .opatch Command tools are generally located in $ORACLE_HOME/OPat ...
- Oracle Database basic learning ( 3、 ... and ) Oracle Four table structures
Oracle Four tables emp dept salgrade bunus Structure , Remember that it's good for later SQL Sentence learning Employee list (emp) No. Field type describe 1 empno NUMBER(4) Express ...
- Oracle database Based on learning ( One ) SQL Basic knowledge
Oracle Starting from scratch , At a loss . To master a skill , The best way is to learn how to use it first , Then learn more about , First there's the look , And then there's technology . One , What is a database ? Why do you need a database ? A database is essentially a list of information , Or is it a ...
- Oracle Latch Learning from 【 original 】
Latch Detailed explanation - MaxChou This paper aims at learning , Most of the content comes from the Internet . What is? Latch Serialization The database system itself is a multi-user concurrent processing system , At the same time , There may be multiple users operating the database at the same time . Multiple ...
- 【Oracle A collection of tutorial resources 】Oracle Database free learning resources summary
Oracle Our products are very rich , There are many kinds of learning resources , This article will introduce Oracle The official free course is arranged by brother Feng Oracle Video tutorial : 1.Oracle Help center Oracle The help center is also called Oracle Document center , this ...
Random recommendation
- iptables What can be done
Preface In these two blog posts, we have analyzed iptable The principle of and in openwrt The example inside http://www.cnblogs.com/tanhangbo/p/4550455.html http://www ...
- go Language conditional sentence if else
Example : if a < 5 { return 0 } else { return 1 } About conditional statements , The following points need to be noted : Conditional statements don't need brackets to contain conditions (): No matter how many words are in the sentence ...
- php Turn on openssl Methods
windows Lower opening method : 1: First check php.ini in :extension=php_openssl.dll Whether there is , Remove the preceding comment if it exists ‘:’, If it doesn't exist , Then add extensio ...
- Oracle in any and all Different usage of
about any,all Usage of , What the book says is rather tongue twister , Difficult to understand , If we give examples, it will be clearer . any Example : select * from t_hq_ryxx where gongz > any (selec ...
- You have to master 8 individual DOS command
One ,ping It is used to check whether the network is smooth or the network connection speed . As an administrator or hacker living on the Internet ,ping Command is the first thing that must be mastered DOS command , The principle it uses is : Machines on the Internet have a unique identity IP ...
- Git in README.md in MarkDown Syntax example
turn http://blog.csdn.net/brokge/article/details/38388757 brief introduction Markdown The grammar is simple and clear . It's easy to learn , And it's more powerful than plain text , So a lot of people use it to blog ...
- About JavaScriptSerializer Problems in use
Beginners C# My classmates , Do you have any questions like this : I have problems that I don't understand , Just search everywhere , It's hard to find out the answer , But I found the lack of references , If you lack a reference, add it , The result is not found in the add ! Isn't it irritating ? terms of settlement : Look at the goal framework of the project , If ...
- ( Two )Activity Boot mode
One . The standard model (standrard) 1. When creating a new Activity when , By default, it's standard mode , It can also be done through AndroidManifest The file display specifies its launchMode by standard <?x ...
- PageHelper Use of paging plug-ins
Hello everyone ! Today I write ssm Project implementation of paging when used pageHelper Paging plug-ins , There are some mistakes in the process of using , So write an essay to record the whole process 1. background : In the process of project development , In order to achieve all the functions . 2. The goal is : Implement paging ...
- DBS:TestSys
ylbtech-DBS:TestSys 1. Return to the top 1. -- ============================================= -- The test system -- 2018-4-12 ...