Skip to main content

Posts

Showing posts with the label PLSQL

Basics of Oracle PLSQL

Basics of Oracle PLSQL Basics of Oracle PLSQL, helps to know more about PLSQL and its importance, before going for PLSQL be clear with SQL basics . What is PLSQL and its abbreviation ? PLSQL stands for Procedural Language extensions to Structured Query Language. In SQL we can't able to write business logics and there will be lot of limitations are there, so to overcome those limitations we go for PLSQL. So this can be proceeded by loop the list of SQL statements inside the single block and it will be executed. Advantages of Using PLSQL Performance wise it is high. As well it will reduce Network Traffic. It is one of the embedded language. Portable - so you can use it anywhere. Easily accessible, readable and friendly  Some Important basics of Oracle PLSQL List of some important points to be noted in basics of Oracle PLSQL which are listed below. PLSQL OBJECTS  As we already know more about the SQL objects, so in the same way PLSQL objects are there that can be stored in a database