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

  1. Oracle Learning notes of the course

    Oracle Learning notes of the course ... ----------------------------------- Oracle course :--- Learning notes : ============================= ...

  2. 【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 ...

  3. 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 [root@rac1 ~]# gre ...

  4. 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 ...

  5. [ 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 ...

  6. 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 ...

  7. 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 ...

  8. 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 ...

  9. 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 ...

  10. 【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

  1. 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 ...

  2. 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 ...

  3. 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 ...

  4. 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 ...

  5. 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 ...

  6. 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 ...

  7. 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 ...

  8. ( 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 ...

  9. 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 ...

  10. DBS:TestSys

    ylbtech-DBS:TestSys 1. Return to the top 1. -- ============================================= -- The test system -- 2018-4-12 ...