Skip to main 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.



Comments

  1. SOHAIL7 November 2020 at 03:47

    Nice good one 👍

    ReplyDelete
  2. Unknown7 November 2020 at 07:15

    Thank you so much sir. Easy to understand with simple tips and tricks.

    ReplyDelete

Post a Comment

Popular posts from this blog

SQL server

  Microsoft SQL Server: Microsoft SQL Server is a relational database management system (RDBMS). Applications and tools connect to a SQL Server instance or database, and communicate using Transact-SQL (T-SQL). You can install SQL Server on Windows or Linux, deploy it in a Linux container, or deploy it on an Azure Virtual Machine. SQL Server components and technologies: Database Engine The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise.  Integration Services SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing. Analysis Services SQL Server Analysis Services (SSAS) is an analytical data platform and toolset for personal, te...
Post a Comment
Read more

C# Tutorial , Step-5, Built in Data Types

 Hello, Welcome to all. My name is Abdul Yesdani. Today we are going to learn about built in data types of C# language. The following list describe the C# built in types. Integral numeric types Type Description / Range bool True or false byte 0-255     Unsigned 8 bit integer sbyte -128 to 127       Signed 8 bit integer short -32,768 to 32,767         Signed 16-bit integer ushort 0 to 65,535               Unsigned 16-bit integer int -2,147,483,648 to 2,147,483,647    Signed 32-bit integer uint 0 to 4,294,967,295     Unsigned 32-bit integer long -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Signed 64-bit integer ulong 0 to 18,446,744,073,709,551,615 Unsigned 64-bit integer Floating Types float ±1.5 x 10−45 to ±3.4 x 1038             4 bytes double ±5.0 × 10−324 to ±1.7 × 10308        8 bytes decimal ±1.0 x ...
Post a Comment
Read more