Este curso é um curso introdutório à linguagem PL / SQL e apresenta os benefícios desta poderosa linguagem de programação. Os formandos aprendem a criar blocos PL / SQL de código que podem ser partilhados por diversos formulários, relatórios e aplicações de gestão de dados.

Objetivos

- Describe the features and syntax of PL/SQL
- Create and use stored procedures and functions
- Manage dependencies between PL/SQL subprograms
- Design and use PL/SQL packages to group and contain related constructs
- Create overloaded package subprograms for more flexibility
- Write dynamic SQL for more coding flexibility
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
- Describe stored procedures and functions
- Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
- Design PL/SQL anonymous block that execute efficiently
- Create triggers to solve business challenges



Duração: 30 Horas


Conteúdo Programático

• Introduction to PL/SQL
• Creating and Executing a Simple Anonymous Block
• Generating Output from a PL/SQL Block
• Declaring PL/SQL Identifiers
• Storing Data in Variables
• Scalar Data Types
• Bind Variables
• Interacting with the Oracle Server
• The SQL Cursor concept
• Using SQL Cursor Attributes to Obtain Feedback on DML
• Saving and Discarding Transactions
• Writing Executable Statements
• Writing Control Structures
• Conditional processing Using IF Statements
• Conditional processing Using CASE Statements
• Control Statements
• Working with Composite Data Types
• Using PL/SQL Records
• Using Explicit Cursors




Solicite mais informação

Inscreva-se neste curso