About the course Delegates will attain an in-depth understanding of Oracle PL/SQL in the SQL*plus environment. You will need PL/SQL where the set returns of SQL no longer meet your programming requirements and you need to “stop on every row” to make coding decisions. The course covers control structures, exception, anonymous blocks, stored procedures, stored functions, packagesand database triggers. Oracle has a rich offering of built-in PL/SQL packages which can be used to control and manage the database. The course introduces the programmers to this wealth of functionality. Prerequisites Delegates should have a reasonable knowledge of IT in general. You should feel comfortable investigating system settings through Windows GUI interfaces, as well as entering line commands in console environments. It is important that you be familiar with Oracle SQL and the SQL*Plus monitor. Previous programming experience would be useful, but is not essential if you have the required aptitude for this type of work. Audience If you come from one of these business or technical areas, you would find the course very useful: An application developer in an Oracle environment A skilled end user looking at advanced ways of accessing data Programming in Oracle Forms requires a knowledge of PL/SQL Building tables with triggers Project manager seeking to understand and control Oracle database programming Database administrators needing to write automated routines or other facilities for users Duration 3 days