Menu

Getting Started With PL/SQL

2018-03-23
2018-07-04
  • james mason

    james mason - 2018-03-23

    Building and Managing PL/SQL Program Units

    Building with Blocks PL/SQL is a block-structured language; familiarity with blocks is critical to writing good code.

    Controlling the Flow of Execution Conditional branching and iterative processing in PL/SQL

    Wrap Your Code in a Neat Package Packages are the fundamental building blocks of any high quality PL/SQL-based application

    Picking Your Packages Concepts and benefits of PL/SQL packages

    Error Management An exploration of error management features in Oracle PL/SQL

    The Data Dictionary: Make Views Work for You Use several key data dictionary views to analyze and manage your code

    PL/SQL Datatypes

    Working with Strings in PL/SQL PL/SQL offers several different string datatypes for use in your applications

    Working with Numbers in PL/SQL Learn about and how to use the different numeric types in PL/SQL.

    Working with Dates in PL/SQL Dates are a relatively complex scalar datatype, in both SQL and PL/SQL

    Working with Records A very common and useful composite type, PL/SQL's analogue to a table's row

    Working with Collections PL/SQL's implementation of arrays plays a role in almost every key performance feature of PL/SQL

    SQL in PL/SQL

    Working with Cursors PL/SQL cursors make it easy for you to manipulate the contents of database tables

    Bulk Processing with BULK COLLECT and FORALL The most important performance feature in PL/SQL related to executing SQL

     
  • Alex Jg

    Alex Jg - 2018-07-04

    Jade Global Customer Reduced Conversion Time From Over 1 Year To Less than 6 Months Using Jade Global’s Unique Oracle Data Integrator Conversion Tool, InfatoODI! .To know more visit http://informaticatoodi.jadeglobal.com

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.