🗊Презентация Writing executable statements

Категория: Информатика
Нажмите для полного просмотра!
Writing executable statements, слайд №1Writing executable statements, слайд №2Writing executable statements, слайд №3Writing executable statements, слайд №4Writing executable statements, слайд №5Writing executable statements, слайд №6Writing executable statements, слайд №7Writing executable statements, слайд №8Writing executable statements, слайд №9Writing executable statements, слайд №10Writing executable statements, слайд №11Writing executable statements, слайд №12Writing executable statements, слайд №13Writing executable statements, слайд №14Writing executable statements, слайд №15Writing executable statements, слайд №16Writing executable statements, слайд №17Writing executable statements, слайд №18Writing executable statements, слайд №19Writing executable statements, слайд №20Writing executable statements, слайд №21Writing executable statements, слайд №22Writing executable statements, слайд №23Writing executable statements, слайд №24Writing executable statements, слайд №25Writing executable statements, слайд №26Writing executable statements, слайд №27Writing executable statements, слайд №28Writing executable statements, слайд №29
Скачать
Вы можете ознакомиться и скачать презентацию на тему Writing executable statements. Доклад-сообщение содержит 29 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1


Writing Executable Statements
Описание слайда:
Writing Executable Statements

Слайд 2


Objectives After completing this lesson, you should be able to do the following: Identify lexical units in a PL/SQL block Use built-in SQL functions in PL/SQL Describe when implicit conversions take place and when explicit conversions have to be dealt with Write nested blocks and qualify variables with labels Write readable code with appropriate indentation Use sequences in PL/SQL expressions
Описание слайда:
Objectives After completing this lesson, you should be able to do the following: Identify lexical units in a PL/SQL block Use built-in SQL functions in PL/SQL Describe when implicit conversions take place and when explicit conversions have to be dealt with Write nested blocks and qualify variables with labels Write readable code with appropriate indentation Use sequences in PL/SQL expressions

Слайд 3


Lexical Units in a PL/SQL Block Lexical units: Are building blocks of any PL/SQL block Are sequences of characters including letters, numerals, tabs, spaces, returns, and symbols Can be classified as: Identifiers: v_fname, c_percent Delimiters: ; , +, - Literals: John, 428, True Comments: --, /* */
Описание слайда:
Lexical Units in a PL/SQL Block Lexical units: Are building blocks of any PL/SQL block Are sequences of characters including letters, numerals, tabs, spaces, returns, and symbols Can be classified as: Identifiers: v_fname, c_percent Delimiters: ; , +, - Literals: John, 428, True Comments: --, /* */

Слайд 4


PL/SQL Block Syntax and Guidelines Literals Character and date literals must be enclosed in single quotation marks. Numbers can be simple values or in scientific notation. Statements can span several lines.
Описание слайда:
PL/SQL Block Syntax and Guidelines Literals Character and date literals must be enclosed in single quotation marks. Numbers can be simple values or in scientific notation. Statements can span several lines.

Слайд 5


Commenting Code Prefix single-line comments with two hyphens (--). Place multiple-line comments between the symbols /* and */. Example:
Описание слайда:
Commenting Code Prefix single-line comments with two hyphens (--). Place multiple-line comments between the symbols /* and */. Example:

Слайд 6


SQL Functions in PL/SQL Available in procedural statements: Single-row functions Not available in procedural statements: DECODE Group functions
Описание слайда:
SQL Functions in PL/SQL Available in procedural statements: Single-row functions Not available in procedural statements: DECODE Group functions

Слайд 7


SQL Functions in PL/SQL: Examples Get the length of a string: Get the number of months an employee has worked:
Описание слайда:
SQL Functions in PL/SQL: Examples Get the length of a string: Get the number of months an employee has worked:

Слайд 8


Using Sequences in PL/SQL Expressions Starting in 11g: Before 11g:
Описание слайда:
Using Sequences in PL/SQL Expressions Starting in 11g: Before 11g:

Слайд 9


Data Type Conversion Converts data to comparable data types Is of two types: Implicit conversion Explicit conversion Functions: TO_CHAR TO_DATE TO_NUMBER TO_TIMESTAMP
Описание слайда:
Data Type Conversion Converts data to comparable data types Is of two types: Implicit conversion Explicit conversion Functions: TO_CHAR TO_DATE TO_NUMBER TO_TIMESTAMP

Слайд 10


Writing executable statements, слайд №10
Описание слайда:

Слайд 11


Data Type Conversion
Описание слайда:
Data Type Conversion

Слайд 12


Nested Blocks PL/SQL blocks can be nested. An executable section (BEGIN … END) can contain nested blocks. An exception section can contain nested blocks.
Описание слайда:
Nested Blocks PL/SQL blocks can be nested. An executable section (BEGIN … END) can contain nested blocks. An exception section can contain nested blocks.

Слайд 13


Nested Blocks: Example
Описание слайда:
Nested Blocks: Example

Слайд 14


Variable Scope and Visibility
Описание слайда:
Variable Scope and Visibility

Слайд 15


Writing executable statements, слайд №15
Описание слайда:

Слайд 16


Qualify an Identifier
Описание слайда:
Qualify an Identifier

Слайд 17


Determining Variable Scope: Example
Описание слайда:
Determining Variable Scope: Example

Слайд 18


Writing executable statements, слайд №18
Описание слайда:

Слайд 19


Operators in PL/SQL Logical Arithmetic Concatenation Parentheses to control order of operations Exponential operator (**)
Описание слайда:
Operators in PL/SQL Logical Arithmetic Concatenation Parentheses to control order of operations Exponential operator (**)

Слайд 20


Operators in PL/SQL: Examples Increment the counter for a loop. Set the value of a Boolean flag. Validate whether an employee number contains a value.
Описание слайда:
Operators in PL/SQL: Examples Increment the counter for a loop. Set the value of a Boolean flag. Validate whether an employee number contains a value.

Слайд 21


Programming Guidelines Make code maintenance easier by: Documenting code with comments Developing a case convention for the code Developing naming conventions for identifiers and other objects Enhancing readability by indenting
Описание слайда:
Programming Guidelines Make code maintenance easier by: Documenting code with comments Developing a case convention for the code Developing naming conventions for identifiers and other objects Enhancing readability by indenting

Слайд 22


Indenting Code For clarity, indent each level of code.
Описание слайда:
Indenting Code For clarity, indent each level of code.

Слайд 23


Quiz You can use most SQL single-row functions such as number, character, conversion, and date single-row functions in PL/SQL expressions. True False
Описание слайда:
Quiz You can use most SQL single-row functions such as number, character, conversion, and date single-row functions in PL/SQL expressions. True False

Слайд 24


Summary In this lesson, you should have learned how to: Identify lexical units in a PL/SQL block Use built-in SQL functions in PL/SQL Write nested blocks to break logically related functionalities Decide when to perform explicit conversions Qualify variables in nested blocks Use sequences in PL/SQL expressions
Описание слайда:
Summary In this lesson, you should have learned how to: Identify lexical units in a PL/SQL block Use built-in SQL functions in PL/SQL Write nested blocks to break logically related functionalities Decide when to perform explicit conversions Qualify variables in nested blocks Use sequences in PL/SQL expressions

Слайд 25


Practice 3: Overview This practice covers the following topics: Reviewing scoping and nesting rules Writing and testing PL/SQL blocks
Описание слайда:
Practice 3: Overview This practice covers the following topics: Reviewing scoping and nesting rules Writing and testing PL/SQL blocks

Слайд 26


Writing executable statements, слайд №26
Описание слайда:

Слайд 27


Writing executable statements, слайд №27
Описание слайда:

Слайд 28


Writing executable statements, слайд №28
Описание слайда:

Слайд 29


Writing executable statements, слайд №29
Описание слайда:

Скачать

Похожие презентации
Mypresentation.ru
Загрузить презентацию