Tutorials
Understanding Date Time in JS
Introduction Date and time are a regular part of our everyday lives and therefore feature prominently in computer programming. In Java...
Read more
Tutorials
Top 65 PL/SQL Interview Questions & Answers
1) What is PL SQL ? PL SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs...
Read more![Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sxsDlvJ5-Fc6k13XxOyTYUA_2gF4poV-4jlMcZTIBKeMPMTyjsABwrmpdFVgUXAeGypXgPYGusTJ_HCYL3SfEdLbwR2HU6-OU_pNualS556jO3w1W0nt7M1yXf4owhXBRJwPV8=w680)
Tutorials
Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
What is Nested Blocks Oracle? In PL/SQL, each block can be nested into another block. They are referred as a nested block. Nested blocks...
Read more
Tutorials
Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL
What is Dynamic SQL? Dynamic SQL is a programming methodology for generating and running statements at run-time. It is mainly used to ...
Read more
Tutorials
Oracle PL/SQL Object Types Tutorial with EXAMPLES
What is Object Type in PL/SQL? Object-Oriented Programming is especially suited for building reusable components and complex application...
Read more![Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_saJr5cvRzNi427pL77Jjug3UuBdkOC5UFwY5l3SkDiS2GAB7L4PXlf_JOH9XVB4W3Wc7w9aRWnN60N6kamYT_DDT40MMu2HO-KkF3rx5oSdOF4u769pyUslEYfO150jcbNoFA=w680)
Tutorials
Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]
What are Triggers in PL/SQL? Triggers are stored programs that are fired automatically when some events occur. The code to be fired can ...
Read more![Oracle PL/SQL Package: Type, Specification, Body [Example]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqi0Ef_8xanZ5b0F6WDdUGbJig36jFqmXJ6T89e7AxJfDeul8mgdvEPNJ6KMj1NPnycIXxaR2myz34Vt9SB2FySap4phFZugGyUfbMUKgSKeOAyR6VNvcYiiOBGYt0aAK-S1Ha4tIcm_yd/w680/1200px-MySQL.svg.png)
Tutorials
Oracle PL/SQL Package: Type, Specification, Body [Example]
What is Package in Oracle? PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A ...
Read more
Tutorials
Autonomous Transaction in Oracle PL/SQL: Commit, Rollback
What are TCL Statements in PL/SQL? TCL stands for Transaction Control Statements. It will either save the pending transactions or roll b...
Read more
Tutorials
Oracle PL/SQL BULK COLLECT: FORALL Example
What is BULK COLLECT? BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to fetch the records a...
Read more
Tutorials
Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]
What is CURSOR in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement whic...
Read more
