|
- PL SQL Tutorial
PL SQL Tutorial PL SQL, which stands for Procedural Language extensions to the Structured Query Language (SQL) It is a combination of SQL along with the procedural features of programming languages It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL PL SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself
- PL SQL - Overview - Online Tutorials Library
The PL SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL and the Oracle relational database Following are certain notable facts about PL SQL − PL SQL is a completely portable, high-performance transaction-processing language PL SQL provides a built-in, interpreted and OS independent programming environment PL SQL can
- PL SQL - Basic Syntax - Online Tutorials Library
In this chapter, we will discuss the Basic Syntax of PL SQL which is a block-structured language; this means that the PL SQL programs are divided and written in logical blocks of code Each block consists of three sub-parts ?
- PL SQL - Operators - Online Tutorials Library
In this chapter, we will discuss operators in PL SQL An operator is a symbol that tells the compiler to perform specific mathematical or logical manipulation PL SQL language is rich in built-in operators and provides the following types of operators − Arithmetic operators Relational operators Comparison operators Logical operators String operators Here, we will understand the arithmetic
- PL SQL - Quick Guide - Online Tutorials Library
PL SQL - Overview The PL SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL and the Oracle relational database Following are certain notable facts about PL SQL − PL SQL is a completely portable, high-performance transaction-processing language PL SQL provides a built-in, interpreted and OS independent programming
- PL SQL - Procedures - Online Tutorials Library
In this chapter, we will discuss Procedures in PL SQL A subprogram is a program unit module that performs a particular task These subprograms are combined to form larger programs This is basically called the 'Modular design' A subprogram can be invoked by another subprogram or program which is called the calling program A subprogram can be created − At the schema level Inside a package
- Oracle PL SQL Online Training Course
Oracle PL SQL Training Course is a comprehensive guide designed for learners who want to learn how to develop PL SQL programs and Become Oracle Developer DBA
- PL SQL - Collections
In this chapter, we will discuss the Collections in PL SQL A collection is an ordered group of elements having the same data type Each element is identified by a unique subscript that represents its position in the collection PL SQL provides three collection types − Index-by tables or Associative array Nested table Variable-size array or Varray Oracle documentation provides the following
|
|
|