оператор if sql

Throughout the remainder of this course you will learn the purpose of and see examples of many of these statements. You may be wondering, “where are the rest of the SQL statements?” DDL statements such as CREATE, GRANT, DROP etc. Well, these are DDL statements and cannot be coded directly within PL/SQL. Use the EXECUTE IMMEDIATE statement to embed DDL statements. Mini-Workshop

Shown here is a list of commonly used statements that can be used within a PL/SQL program. Refer to the Oracle 10g PL/SQL User's Guide and Reference for a complete list and description of each statement.

(Examples or comments displayed on slide, if any).

To some extent, this is a reference chapter. You’ll see relatively large lists of statements, datatypes and symbols. I recommend that you do not attempt to remember each one as you progress through this chapter. We’ll incorporate them into examples in the remainder of the course. However, do use this lesson to acquire a solid grasp of the basic format of the IF, CASE, loop statements, and a good understanding of arrays. But here again, you’ll see these statements used throughout the rest of the course.

(Examples or comments displayed on slide, if any).

The fundamental language elements in PL/SQL for Oracle 10g including:

Lesson 2: PL/SQL Programming for Oracle 10g: Language Fundamentals

SkillBuilders | Oracle 10g PL/SQL Programming | Lesson 2: PL/SQL Language Fundamentals