![]() Two methods: – WITH clause that defines a function – UDF pragma that gives more options to the compiler.– Bind records and associative arrays – Use TABLE operator with associative arrays – Still can't do much with Booleans Copyright 2013 Feuerstein and Associates ![]() ![]() Prior to 12c, PL/SQL-only datatypes could not be bound in dynamic SQL statements, restricted what functions could be called in SQL, etc.More PL/SQL-Only Data Types Cross PL/SQL-to-SQL Interface Goodbye, Tiny SQL VARCHAR2! Copyright 2013 Feuerstein and Associates.New Conditional Compilation Directives.Privileges/Access Management for Program Units – Grant Roles to Program Units – And INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES – BEQUEATH CURRENT_USER for Views.More PL/SQL-Only Data Types Cross PL/SQL-to-SQL Interface.– You must test them and modify them to fit your needs. – But remember: they are not production ready. You have my permission to use all these materials to do internal trainings and build your own applications. Download and use any of my scripts (examples, performance scripts, reusable code) from the same location: the demo.zip file. Download and use any of my training materials:.Watch, listen, ask questions, focus on concepts and principles.How to benefit most from this presentation Steven Feuerstein PL/SQL Evangelist, Dell Oracle Database 12c Release 1 PL/SQL New Features
0 Comments
Leave a Reply. |