Posts

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