🗊Презентация Introduction to PL/SQL

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

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

Слайд 1


Introduction to PL/SQL
Описание слайда:
Introduction to PL/SQL

Слайд 2


Objectives After completing this lesson, you should be able to do the following: Explain the need for PL/SQL Explain the benefits of PL/SQL Identify the different types of PL/SQL blocks Output messages in PL/SQL
Описание слайда:
Objectives After completing this lesson, you should be able to do the following: Explain the need for PL/SQL Explain the benefits of PL/SQL Identify the different types of PL/SQL blocks Output messages in PL/SQL

Слайд 3


About PL/SQL PL/SQL: Stands for “Procedural Language extension to SQL” Is Oracle Corporation’s standard data access language for relational databases Seamlessly integrates procedural constructs with SQL
Описание слайда:
About PL/SQL PL/SQL: Stands for “Procedural Language extension to SQL” Is Oracle Corporation’s standard data access language for relational databases Seamlessly integrates procedural constructs with SQL

Слайд 4


About PL/SQL PL/SQL: Provides a block structure for executable units of code. Maintenance of code is made easier with such a well-defined structure. Provides procedural constructs such as: Variables, constants, and data types Control structures such as conditional statements and loops Reusable program units that are written once and executed many times
Описание слайда:
About PL/SQL PL/SQL: Provides a block structure for executable units of code. Maintenance of code is made easier with such a well-defined structure. Provides procedural constructs such as: Variables, constants, and data types Control structures such as conditional statements and loops Reusable program units that are written once and executed many times

Слайд 5


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

Слайд 6


Benefits of PL/SQL Integration of procedural constructs with SQL Improved performance
Описание слайда:
Benefits of PL/SQL Integration of procedural constructs with SQL Improved performance

Слайд 7


Benefits of PL/SQL Modularized program development Integration with Oracle tools Portability Exception handling
Описание слайда:
Benefits of PL/SQL Modularized program development Integration with Oracle tools Portability Exception handling

Слайд 8


Introduction to PL/SQL, слайд №8
Описание слайда:

Слайд 9


PL/SQL Block Structure DECLARE (optional) Variables, cursors, user-defined exceptions BEGIN (mandatory) SQL statements PL/SQL statements EXCEPTION (optional) Actions to perform when errors occur END; (mandatory)
Описание слайда:
PL/SQL Block Structure DECLARE (optional) Variables, cursors, user-defined exceptions BEGIN (mandatory) SQL statements PL/SQL statements EXCEPTION (optional) Actions to perform when errors occur END; (mandatory)

Слайд 10


Introduction to PL/SQL, слайд №10
Описание слайда:

Слайд 11


Block Types Anonymous Procedure Function
Описание слайда:
Block Types Anonymous Procedure Function

Слайд 12


Introduction to PL/SQL, слайд №12
Описание слайда:

Слайд 13


Program Constructs
Описание слайда:
Program Constructs

Слайд 14


Introduction to PL/SQL, слайд №14
Описание слайда:

Слайд 15


Create an Anonymous Block Enter the anonymous block in the SQL Developer workspace:
Описание слайда:
Create an Anonymous Block Enter the anonymous block in the SQL Developer workspace:

Слайд 16


Execute an Anonymous Block Click the Run Script button to execute the anonymous block:
Описание слайда:
Execute an Anonymous Block Click the Run Script button to execute the anonymous block:

Слайд 17


Test the Output of a PL/SQL Block Enable output in SQL Developer by clicking the Enable DBMS Output button on the DBMS Output tab: Use a predefined Oracle package and its procedure: DBMS_OUTPUT.PUT_LINE
Описание слайда:
Test the Output of a PL/SQL Block Enable output in SQL Developer by clicking the Enable DBMS Output button on the DBMS Output tab: Use a predefined Oracle package and its procedure: DBMS_OUTPUT.PUT_LINE

Слайд 18


Test the Output of a PL/SQL Block
Описание слайда:
Test the Output of a PL/SQL Block

Слайд 19


Quiz A PL/SQL block must consist of the following three sections: A Declarative section which begins with the keyword DECLARE and ends when the executable section starts. An Executable section which begins with the keyword BEGIN and ends with END. An Exception handling section which begins with the keyword EXCEPTION and is nested within the executable section. True False
Описание слайда:
Quiz A PL/SQL block must consist of the following three sections: A Declarative section which begins with the keyword DECLARE and ends when the executable section starts. An Executable section which begins with the keyword BEGIN and ends with END. An Exception handling section which begins with the keyword EXCEPTION and is nested within the executable section. True False

Слайд 20


Summary In this lesson, you should have learned how to: Integrate SQL statements with PL/SQL program constructs Describe the benefits of PL/SQL Differentiate between PL/SQL block types Output messages in PL/SQL
Описание слайда:
Summary In this lesson, you should have learned how to: Integrate SQL statements with PL/SQL program constructs Describe the benefits of PL/SQL Differentiate between PL/SQL block types Output messages in PL/SQL

Слайд 21


Practice 1: Overview This practice covers the following topics: Identifying the PL/SQL blocks that execute successfully Creating and executing a simple PL/SQL block
Описание слайда:
Practice 1: Overview This practice covers the following topics: Identifying the PL/SQL blocks that execute successfully Creating and executing a simple PL/SQL block

Слайд 22


Introduction to PL/SQL, слайд №22
Описание слайда:

Скачать

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