PL/SQL – Object Oriented
In this chapter, we will discuss Object-Oriented PL/SQL. PL/SQL allows defining an object type, which…
2,486 total views, 4 views today
In this chapter, we will discuss Object-Oriented PL/SQL. PL/SQL allows defining an object type, which…
2,486 total views, 4 views today
In this chapter, we will discuss the DBMS Output in PL/SQL. The DBMS_OUTPUT is a…
2,342 total views, 7 views today
In this chapter, we will discuss the Date and Time in PL/SQL. There are two…
2,458 total views, 4 views today
In this chapter, we will discuss the transactions in PL/SQL. A database transaction is an…
2,176 total views, 3 views today
In this chapter, we will discuss the Collections in PL/SQL. A collection is an ordered…
2,307 total views, 4 views today
In this chapter, we will discuss the Packages in PL/SQL. Packages are schema objects that…
2,166 total views, 3 views today
In this chapter, we will discuss Triggers in PL/SQL. Triggers are stored programs, which are…
2,118 total views, 4 views today
In this chapter, we will discuss Exceptions in PL/SQL. An exception is an error condition…
2,239 total views, 4 views today
In this chapter, we will discuss Records in PL/SQL. A record is a data structure…
2,214 total views, 3 views today
In this chapter, we will discuss the cursors in PL/SQL. Oracle creates a memory area,…
2,322 total views, 5 views today
In this chapter, we will discuss the functions in PL/SQL. A function is same as…
2,194 total views, 5 views today
In this chapter, we will discuss Procedures in PL/SQL. A subprogram is a program unit/module…
2,181 total views, 7 views today
In this chapter, we will discuss arrays in PL/SQL. The PL/SQL programming language provides a…
2,150 total views, 6 views today
The string in PL/SQL is actually a sequence of characters with an optional size specification….
2,327 total views, 4 views today
In this chapter, we will discuss Loops in PL/SQL. There may be a situation when…
2,235 total views, 3 views today
In this chapter, we will discuss conditions in PL/SQL. Decision-making structures require that the programmer…
2,068 total views, 3 views today
In this chapter, we will discuss operators in PL/SQL. An operator is a symbol that…
2,247 total views, 4 views today
In this chapter, we will discuss constants and literals in PL/SQL. A constant holds a…
2,068 total views, 4 views today
In this chapter, we will discuss Variables in Pl/SQL. A variable is nothing but a…
2,199 total views, 4 views today
In this chapter, we will discuss the Data Types in PL/SQL. The PL/SQL variables, constants…
2,175 total views, 3 views today
In this chapter, we will discuss the Basic Syntax of PL/SQL which is a block-structured…
2,213 total views, 3 views today
In this chapter, we will discuss the Environment Setup of PL/SQL. PL/SQL is not a…
2,340 total views, 4 views today
The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as procedural…
2,240 total views, 6 views today