🗊Презентация Declaring PL/SQL Variables. (Lecture 2)

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

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

Слайд 1


Declaring PL/SQL Variables
Описание слайда:
Declaring PL/SQL Variables

Слайд 2


Objectives After completing this lesson, you should be able to do the following: Recognize valid and invalid identifiers List the uses of variables Declare and initialize variables List and describe various data types Identify the benefits of using the %TYPE attribute Declare, use, and print bind variables
Описание слайда:
Objectives After completing this lesson, you should be able to do the following: Recognize valid and invalid identifiers List the uses of variables Declare and initialize variables List and describe various data types Identify the benefits of using the %TYPE attribute Declare, use, and print bind variables

Слайд 3


Use of Variables Variables can be used for: Temporary storage of data Manipulation of stored values Reusability
Описание слайда:
Use of Variables Variables can be used for: Temporary storage of data Manipulation of stored values Reusability

Слайд 4


Requirements for Variable Names A variable name: Must start with a letter Can include letters or numbers Can include special characters (such as $, _, and # ) Must contain no more than 30 characters Must not include reserved words
Описание слайда:
Requirements for Variable Names A variable name: Must start with a letter Can include letters or numbers Can include special characters (such as $, _, and # ) Must contain no more than 30 characters Must not include reserved words

Слайд 5


Handling Variables in PL/SQL Variables are: Declared and initialized in the declarative section Used and assigned new values in the executable section Passed as parameters to PL/SQL subprograms Used to hold the output of a PL/SQL subprogram
Описание слайда:
Handling Variables in PL/SQL Variables are: Declared and initialized in the declarative section Used and assigned new values in the executable section Passed as parameters to PL/SQL subprograms Used to hold the output of a PL/SQL subprogram

Слайд 6


Declaring and Initializing PL/SQL Variables Syntax: Examples:
Описание слайда:
Declaring and Initializing PL/SQL Variables Syntax: Examples:

Слайд 7


Declaring and Initializing PL/SQL Variables
Описание слайда:
Declaring and Initializing PL/SQL Variables

Слайд 8


Delimiters in String Literals
Описание слайда:
Delimiters in String Literals

Слайд 9


Types of Variables PL/SQL variables: Scalar Composite Reference Large object (LOB) Non-PL/SQL variables: Bind variables
Описание слайда:
Types of Variables PL/SQL variables: Scalar Composite Reference Large object (LOB) Non-PL/SQL variables: Bind variables

Слайд 10


Types of Variables
Описание слайда:
Types of Variables

Слайд 11


Guidelines for Declaring and Initializing PL/SQL Variables Follow naming conventions. Use meaningful identifiers for variables. Initialize variables designated as NOT NULL and CONSTANT. Initialize variables with the assignment operator (:=) or the DEFAULT keyword: Declare one identifier per line for better readability and code maintenance.
Описание слайда:
Guidelines for Declaring and Initializing PL/SQL Variables Follow naming conventions. Use meaningful identifiers for variables. Initialize variables designated as NOT NULL and CONSTANT. Initialize variables with the assignment operator (:=) or the DEFAULT keyword: Declare one identifier per line for better readability and code maintenance.

Слайд 12


Guidelines for Declaring PL/SQL Variables Avoid using column names as identifiers. Use the NOT NULL constraint when the variable must hold a value.
Описание слайда:
Guidelines for Declaring PL/SQL Variables Avoid using column names as identifiers. Use the NOT NULL constraint when the variable must hold a value.

Слайд 13


Scalar Data Types Hold a single value Have no internal components
Описание слайда:
Scalar Data Types Hold a single value Have no internal components

Слайд 14


Base Scalar Data Types CHAR [(maximum_length)] VARCHAR2 (maximum_length) NUMBER [(precision, scale)] BINARY_INTEGER PLS_INTEGER BOOLEAN BINARY_FLOAT BINARY_DOUBLE
Описание слайда:
Base Scalar Data Types CHAR [(maximum_length)] VARCHAR2 (maximum_length) NUMBER [(precision, scale)] BINARY_INTEGER PLS_INTEGER BOOLEAN BINARY_FLOAT BINARY_DOUBLE

Слайд 15


Declaring PL/SQL Variables. (Lecture 2), слайд №15
Описание слайда:

Слайд 16


Base Scalar Data Types DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND
Описание слайда:
Base Scalar Data Types DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND

Слайд 17


Declaring PL/SQL Variables. (Lecture 2), слайд №17
Описание слайда:

Слайд 18


Declaring Scalar Variables Examples:
Описание слайда:
Declaring Scalar Variables Examples:

Слайд 19


%TYPE Attribute Is used to declare a variable according to: A database column definition Another declared variable Is prefixed with: The database table and column names The name of the declared variable
Описание слайда:
%TYPE Attribute Is used to declare a variable according to: A database column definition Another declared variable Is prefixed with: The database table and column names The name of the declared variable

Слайд 20


Declaring PL/SQL Variables. (Lecture 2), слайд №20
Описание слайда:

Слайд 21


Declaring Variables with the %TYPE Attribute Syntax Examples
Описание слайда:
Declaring Variables with the %TYPE Attribute Syntax Examples

Слайд 22


Declaring Boolean Variables Only the TRUE, FALSE, and NULL values can be assigned to a Boolean variable. Conditional expressions use the logical operators AND and OR and the unary operator NOT to check the variable values. The variables always yield TRUE, FALSE, or NULL. Arithmetic, character, and date expressions can be used to return a Boolean value.
Описание слайда:
Declaring Boolean Variables Only the TRUE, FALSE, and NULL values can be assigned to a Boolean variable. Conditional expressions use the logical operators AND and OR and the unary operator NOT to check the variable values. The variables always yield TRUE, FALSE, or NULL. Arithmetic, character, and date expressions can be used to return a Boolean value.

Слайд 23


Bind Variables Bind variables are: Created in the environment Also called host variables Created with the VARIABLE keyword Used in SQL statements and PL/SQL blocks Accessed even after the PL/SQL block is executed Referenced with a preceding colon
Описание слайда:
Bind Variables Bind variables are: Created in the environment Also called host variables Created with the VARIABLE keyword Used in SQL statements and PL/SQL blocks Accessed even after the PL/SQL block is executed Referenced with a preceding colon

Слайд 24


Declaring PL/SQL Variables. (Lecture 2), слайд №24
Описание слайда:

Слайд 25


Printing Bind Variables Example:
Описание слайда:
Printing Bind Variables Example:

Слайд 26


Printing Bind Variables Example:
Описание слайда:
Printing Bind Variables Example:

Слайд 27


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

Слайд 28


Composite Data Types
Описание слайда:
Composite Data Types

Слайд 29


Quiz The %TYPE attribute: Is used to declare a variable according to a database column definition Is used to declare a variable according to a collection of columns in a database table or view Is used to declare a variable according the definition of another declared variable Is prefixed with the database table and column names or the name of the declared variable
Описание слайда:
Quiz The %TYPE attribute: Is used to declare a variable according to a database column definition Is used to declare a variable according to a collection of columns in a database table or view Is used to declare a variable according the definition of another declared variable Is prefixed with the database table and column names or the name of the declared variable

Слайд 30


Summary In this lesson, you should have learned how to: Recognize valid and invalid identifiers Declare variables in the declarative section of a PL/SQL block Initialize variables and use them in the executable section Differentiate between scalar and composite data types Use the %TYPE attribute Use bind variables
Описание слайда:
Summary In this lesson, you should have learned how to: Recognize valid and invalid identifiers Declare variables in the declarative section of a PL/SQL block Initialize variables and use them in the executable section Differentiate between scalar and composite data types Use the %TYPE attribute Use bind variables

Слайд 31


Practice 2: Overview This practice covers the following topics: Determining valid identifiers Determining valid variable declarations Declaring variables within an anonymous block Using the %TYPE attribute to declare variables Declaring and printing a bind variable Executing a PL/SQL block
Описание слайда:
Practice 2: Overview This practice covers the following topics: Determining valid identifiers Determining valid variable declarations Declaring variables within an anonymous block Using the %TYPE attribute to declare variables Declaring and printing a bind variable Executing a PL/SQL block

Слайд 32


Declaring PL/SQL Variables. (Lecture 2), слайд №32
Описание слайда:

Слайд 33


Declaring PL/SQL Variables. (Lecture 2), слайд №33
Описание слайда:

Слайд 34


Declaring PL/SQL Variables. (Lecture 2), слайд №34
Описание слайда:

Скачать

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