Oracle Database 12c New PL/SQL Features
Copied from http://www.toadworld.com/
For this Post all credit goes to Feuerstein and Associates :
Oracle Database 12c offers an array of exciting new features for PL/SQL
developers. The function result cache has been enhanced to support
functions defined with invoker rights. Use the ACCESSIBLE BY clause to
define "whitelists" of the program units that can execute subprograms in
a package. Grant roles to PL/SQL program units, rather than to schemas,
giving you much greater flexibility over access control. Design a
procedure to implicitly return a result set, much like you can do in SQL
Server (useful for migration projects). Define a view with BEQUEST
CURRENT_USER so that it behaves like an invoker rights unit. Declare
and call PL/SQL functions entirely inside the WITH clause a SELECT
statement. And more!
The information you posted here is useful to make my career better keep updates..If anyone want to become an oracle certified professional reach FITA, which offers Oracle Training in Chennai with years of experienced professionals.
ReplyDeleteOracle Training
ReplyDeleteI get a lot of great information from this blog. Recently I did oracle certification course at a leading academy. If anyone interested to learn best Oracle Course in Chennai visit FITA academy which offer SQL Training in Chennai.
There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this. FITA chennai reviews
ReplyDeleteAs I am fresher I have an interest in new Technology. So, now I am planning to learn Informatica in your blog i had some interesting concepts, it was crystal clear to read keep sharing thanks SAS Training in Chennai| SAS Course in Chennai
ReplyDeleteExecellent !
ReplyDeleteinformatica training in chennai
nice....
ReplyDeletemsbi training in chennai
Great effort. Thank to shared plsql new features. Keep updating.
ReplyDeleteOracle courses | DBA course
This is new sql feature more help for developer.
ReplyDeleteconvert foxpro code to sql
convert visual foxpro database to sql
foxpro database to sql server
import dbf file into sql server
ReplyDeleteOracle DBA Training
Oracle PLSQL Training
Oracle Performance Tunning Training
That is very interesting; you are a very skilled blogger. I have shared your website in my social networks!
ReplyDeletefire and safety course in chennai
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
ReplyDeleteOoty Taxi
Ooty Taxi service
Keep sharing the good post. Kindly refer
ReplyDeleteMachine Learning training in Pallikranai Chennai
Pytorch training in Pallikaranai chennai
Data science training in Pallikaranai
Python Training in Pallikaranai chennai
Deep learning with Pytorch training in Pallikaranai chennai
Bigdata training in Pallikaranai chennai
Mongodb Nosql training in Pallikaranai chennai
Spark with ML training in Pallikaranai chennai
Data science Python training in Pallikaranai
Bigdata Spark training in Pallikaranai chennai
Sql for data science training in Pallikaranai chennai
Sql for data analytics training in Pallikaranai chennai
Sql with ML training in Pallikaranai chennai