Collections:
Understanding PL/SQL Language Basics
Where to find answers to frequently asked questions on Understanding PL/SQL Language Basics?
✍: FYIcenter.com
Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team
on Understanding PL/SQL Language Basics.
It can also be used as learning tutorials on defining variables, assigning values, using "loop" statements, setting "if" conditions, and working with null values.
PL/SQL Language Case Insensitive in Oracle
Enter Comments in PL/SQL in Oracle
Different Types of PL/SQL Code Blocks in Oracle
PL/SQL Anonymous Block in Oracle
PL/SQL Named Program Unit in Oracle
Declare Local Variables in Oracle
Initialize Variables with Default Values in Oracle
Assign Values to Variables in Oracle
Arithmetic Operations in Pl/SQL in Oracle
Numeric Comparison Operations in Oracle
Logical Operations in PL/SQL in Oracle
Categories of Data Types in PL/SQL in Oracle
Scalar Data Types Supported in PL/SQL in Oracle
Convert Character Types to Numeric Types in Oracle
Types of Execution Flow Control Statements in Oracle
Use "IF" Statements with Multiple Conditions in Oracle
Use "WHILE" Loop Statements in Oracle
Use "FOR" Loop Statements in Oracle
Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. Most of the sample scripts in this FAQ collection are written in anonymous block format. It is also assumed that you know how to create and run anonymous blocks with SQL*Plus or SQL Developer.
⇒ PL/SQL Language Case Insensitive in Oracle
2018-12-26, 3183🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...