Online pl/Sql Course Training USA, UK

1
Oracle 12C Pl/SQL Features

• S M Consultant

2
Oracle 12c Functionalities

• Oracle 12c provides a bunch of new advanced
  features that increases functionalities and
  usefulness of plsql database.

3
Oracle 12c Functionalities

• Lets have look at the unique properties

4
Data types cross to SQL interface

• Before we couldnt bind PL/SQL specific database
  in a dynamic statement but now it is quite
  possible to bind values PLSQL data types in

5
Data types cross to SQL interface

• Anonymous block
• Function calls in SQ queries
• CALL statements and TABLE operator.

6
Use of ACCESSIBLE_By Clause

• This feature helps to expose subprograms that are
  intended to be used in specific program units.

7
Use of ACCESSIBLE_By Clause

• Before Implicit statement results helps to store
  subprogram returned from SQL queries explicitly
  though RETURN clause but now in Oracle 12C stored
  sub program can return query results implicitly
  using PLSQL package.

8
New Conditional Directives

• Oracle has added 2 predefined inquiry directives.
• PLSQL_UNIT_OWNER
• PLSQL_UNIT_TYPE

9
New Conditional Directives

• Get a specific PLSQL 12c versions and features
  training from highly qualified and Oracle
  certified trainers at S M consultant today.

10
New Conditional Directives

• Our training module is highly versed and contains
  all industry oriented features.

11
Oracle 12C Pl/SQL Features

• S M Consultant
• (1) 650-585-2312
• contact_at_smconsultant.com