PL / SQL Control Structures

2010-10-07  来源:本站原创  分类:Database  人气:113 

--  Simple judgments
if   Determine the conditions   then
...
end if;

--  Double conditional branch
if   Determine the conditions   then
....
else
....
end if;

--  Multiple conditional branch
if   Determine the conditions   then
....
elsif   Determine the conditions   then
....
else
....
end if;

--  Cycle
loop
--  Exit the loop to determine
exit when   Determine the conditions  ;
end loop;

--while   Cycle
while   Determine the conditions   loop
....
end loop;

--for    Cycle
for  Variable loop variable range in reverse  (start..end) loop
....
end loop;
相关文章
  • PL / SQL Control Structures 2010-10-07

    -- Simple judgments if Determine the conditions then ... end if; -- Double conditional branch if Determine the conditions then .... else .... end if; -- Multiple conditional branch if Determine the conditions then .... elsif Determine the conditions

  • PL \ SQL User's Guide and Reference 4 reproduced 2011-04-21

    Chapter IV of PL / SQL control structures A, PL / SQL control structures at a glance According to the structure Theorem (structure theorem), any computer program can be used in the figure basic control structures to represent. They can be any combina

  • oracle PL / SQL basic composition, block structure and basic syntax requirements, data types, variable definitions, operators and functions 2011-10-08

    oracle PL / SQL basic composition, block structure and basic syntax requirements, data types, variable definitions, operators and functions Feature PL / SQL language is the SQL language extensions, designed for application developers with features su

  • PL / SQL programming based learning summary 2010-05-27

    PL / SQL Programming 1. How to write and compile PL / SQL Because PL / SQL is embedded in the Oracle server and Oracle development tool, so Oracle client tools and server can write PL / SQL procedure SQL> edit c: \ plsqlblock1.sql; - to build a docum

  • Oracle PL / SQL study notes 2010-11-11

    Experience writing stored procedures and optimization measures | 2010 to talk about new technology optimization Baidu website 2010-09-25 A, PL / SQL tranches defined syntax: DECLARE / * Definition section - define constants, variables, complex data t

  • oracle PL / SQL basic composition, structure, control statements, branch structure, selection structures, loop loop structure 2010-12-08

    Branch of the branch structure is the basic program structure, branch structure, achieved by the IF statement. Using the IF statement, condition can change the program according to the logic of the process. IF statement has the following form: IF con

  • 19.pl/sql Advanced - control structures (branches, circulation, control) 2010-05-12

    Fun combat tutorial oracle (seventh day) Introduction 1. On the section reviews 2.pl/sql Advanced √ 3.oracle view (with security, and simplify complex query functions) √ 4.oracle trigger √ Desired goals 1. Master pl / sql Advanced usage (paging proce

  • oracle PL / SQL basic composition, structure, control statements, branch structure, choose the structure, loop loop structure 2010-12-08

    Branch structure of the branch structure is the most basic program structure, branch structure, achieved by the IF statement. Using the IF statement, according to the conditions can change the program logic flow. IF statement has the following form:

  • PL / SQL Advanced Control statements 2011-04-17

    • Introduction In any computer language (C, JAVA, pascal) has a variety of control statements (conditional statements, looping structures, sequence control structure) in pl / sql in the existence of such control structures. 1>: Using a variety of if

  • PL / SQL Overview and Control Flow Statements 2010-08-10

    SQL: structured query language (Structured Query Language, called SQL) relational database is used to access a common language, is a fourth generation language (4GL), the characteristics of their non-implementation of the process, that is not specifi

  • PL / SQL (oracle) 2_ control structure 2011-07-04

    A control structure, branch structure 1, if Note: elsif and else If if( Conditions )then ... ... elsif ... ... end if ; 2, case Note: select case statement can omit the condition, when followed either a specific value, can also be one or more conditi

  • PL / SQL Programming - Learning Note 2 - Process Control Statements 2011-08-25

    Three, PL / SQL flow control statements introduced PL / SQL flow control statements, including the following three categories: Control statements: IF statements loop: LOOP statements, EXIT statement sequence statements: GOTO statement, NULL statement

  • PL / SQL conditional control (b) 2010-11-29

    1.IF conditional statement In the PL / SQL statement block, IF statements can contain IF, ELSIF, ELSE, THEN, END IF, etc. keyword, its complete syntax is: IF condition1 THEN ... ... ... ...; [ELSIF condition2 THEN ... ... ... ...;] [ELSE ... ... ...

  • PL / SQL worst practice in 14 cases 2010-03-18

    1. Long the PL / SQL code Impact: maintainability, performance symptoms: In complex enterprise applications, there is frequently hundreds of lines on a million lines of stored procedures or packages. Why is the worst: Too long in the PL / SQL code is

  • 16.PL/SQL block structure and examples 2010-05-07

    Han Shunping. Fun oralce 24 talk. Plsql programming (1) Fun combat tutorial oracle (DAY) Introduction 1. On the section reviews 2.pl/sql introduction √ 3.pl/sql foundation √ Desired goals 1. Understand the oracle of the pl / sql concepts 2. Master pl

  • oracle PL / SQL Programming Notes 2010-08-07

    1. The first paradigm: all the attributes are inseparable entities, and that the table to meet 1NF; The second paradigm: allow more than one property as the main code with the third paradigm: there is no dependence of the transfer function, namely, t

  • Oracle Database 11g PL / SQL Programming 10.1 Introduction trigger 2010-09-08

    http://sns.linuxpk.com/space-52196-do-blog-id-16060.html Database triggers are special stored procedures. Usually do not call them directly, instead of triggering the events from the database. Them in the implementation of command and the implementat

  • PL / SQL page process 2010-10-12

    [Size = large] [/ size] if statement with control structures ① ② ③ loop and use the control statement-goto null; Conditional branch statement Pl / sql provided in the three conditional branch statement if-then, if-then-else, if-then-elsif-else Simple

  • Chapter 5 using Oracle PL / SQL 2011-05-12

    Chapter 4 Oracle synonyms, sequences, views, indexes Chapter 6 Oracle cursor Chapter 5 using Oracle PL / SQL 1, the technical objectives Understanding PL / SQL functions and features Understanding of data types and their usage Understand the logic of

  • Oracle Database 11g PL / SQL Programming Overview 10.1 Triggers 2010-09-08

    http://sns.linuxpk.com/space-52196-do-blog-id-16060.html Database triggers are special stored procedures. Usually do not call them directly, but to the events triggered by the database. They execute the command and the implementation of the action be