Skip to main content

Posts

Showing posts from November, 2020

PL / SQL PART-2 | PROCEDURS | FUNCTIONS | CURSORS | TRIGGERS

Hello, In this tutorial you are going to learn about PL / SQL advance topics. Procedures, Functions, Cursors, Triggers and packages are the topics you will learn here. The following topics demonstrated for you here. How to define procedures functions and using or calling them? What is cursor and how to work with cursors? What is trigger and How they act while working with DML commands? What is package? Note: Plase give your views and suggestions in the COMMENTS section. It will help me to improve the content.

PL /SQL TUTORIAL | ANONYMOUS BLOCKS |

Hello, In this tutorial you are going to learn about PL / SQL programing. What is PL/ SQL? PL/ SQL architecture. How anonymous blocks of code can be written? You can also learn about  data types, declaration of variables, processing them in Begin - End section of code.  You can write decision making statements, loops, output function, doing calculations by arithmetic operators.  Learn about user defined types, Exception handling and 'Varray' array types. You can find detailed information of these topics in the following presentation. Note: After reading it please comment your views and suggestions in the comment section. It will help  to improve the content.