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