Pl sql and its Features on Oracle 12c

Hi There  Sql Or Structured Query Language is the Most important tool in Oracle database to Get the Required data  from the Datawarehouses from different Databases. Oracle basically can store Data in the server environment and can restore it for future usage  moreover it is responsible for the Securitising of Data in Data Warehouses

there are Certain Functions and procedures also to be Followed in Sql query  for the extraction of data from those Pool of Data

Now the Sql Functions having an extention in procedural language which termed as  pl Sql ( Procedural Language Structured Query Language ) 

earlier the Sql can be used to perform the task like creating the table and can map the table using functions and then extract the table  with the data required from it but due to the Usage of lengthy code structure can affect the Efficiancy of extraction or execution of data 

thus there is the Pl sql comes with the New functionality to reduce the Task and make it Efficient 

let me tell you about the Pl sql New functionality in Oracle 12c 

Optimize invoker rights functions for the RESULT_CACHE clause:-

As RESULT_CACHE which is Introduced By the Oracle 11g and is responsible for the easy to Use Caching Process further the main goal of CACHE is basically is that if the row of data hasn't changed then it will since the time it was fetched Last then it will be Fetched through the stored Cache

Define PL/SQL Subprograms in a SQL Statement:-

the Developer are mostly looking for the Defining Of Pl sql Subprogram In Sql Statements suppose a Function BETWNSTR that returns the substring between Start and end location 

:-

FUNCTION betwnstr (
string_in IN VARCHAR2
, start_in IN PLS_INTEGER
, end_in IN PLS_INTEGER
)
RETURN VARCHAR2 
IS
BEGIN
RETURN ( SUBSTR (
string_in, start_in, 
end_in - start_in + 1 ));
END;
I can then use it in a query as follows:

SELECT betwnstr (last_name, 3, 5) 
FROM employees

and this approach basically extends the Sql Query language with the Functionality and reuse the algorithm now in Oracle 12 c there is the New Functionality has emerged in that you need to you the WITH Clause to directly and define the Pl Sql Function and Procedure in Sql Statements

WITH
FUNCTION betwnstr (
string_in IN VARCHAR2,
start_in IN PLS_INTEGER,
end_in IN PLS_INTEGER)
RETURN VARCHAR2
IS
BEGIN
RETURN (SUBSTR (
string_in, 
start_in, 
end_in - start_in + 1));
END;
SELECT betwnstr (last_name, 3, 5) 
FROM employees

so there is a tutorial which i would like to share for Pl Sql and it can help you as well to crack the Pl Sql Global Certification exam as well 

so check this Out :-

https://www.youtube.com/watch?v=phvcwekT9ZA

https://www.youtube.com/watch?v=phvcwekT9ZA

thanks & Regards

Arya bhatt

( Blogger at All India Blogging)