In this chapter, we will discuss Object-Oriented PL/SQL. PL/SQL allows defining an object type, which helps in designing object-oriented database…
Read More
PL/SQL – DBMS Output
In this chapter, we will discuss the DBMS Output in PL/SQL. The DBMS_OUTPUT is a built-in package that enables you…
Read MorePL/SQL – Date & Time
In this chapter, we will discuss the Date and Time in PL/SQL. There are two classes of date and time…
Read MorePL/SQL – Transactions
In this chapter, we will discuss the transactions in PL/SQL. A database transaction is an atomic unit of work that…
Read MorePL/SQL – Collections
In this chapter, we will discuss the Collections in PL/SQL. A collection is an ordered group of elements having the…
Read MorePL/SQL – Packages
In this chapter, we will discuss the Packages in PL/SQL. Packages are schema objects that groups logically related PL/SQL types,…
Read MorePL/SQL – Triggers
In this chapter, we will discuss Triggers in PL/SQL. Triggers are stored programs, which are automatically executed or fired when…
Read MorePL/SQL – Exceptions
In this chapter, we will discuss Exceptions in PL/SQL. An exception is an error condition during a program execution. PL/SQL…
Read MorePL/SQL – Records
In this chapter, we will discuss Records in PL/SQL. A record is a data structure that can hold data items…
Read MorePL/SQL – Cursors
In this chapter, we will discuss the cursors in PL/SQL. Oracle creates a memory area, known as the context area,…
Read MorePL/SQL – Functions
In this chapter, we will discuss the functions in PL/SQL. A function is same as a procedure except that it…
Read MorePL/SQL – Procedures
In this chapter, we will discuss Procedures in PL/SQL. A subprogram is a program unit/module that performs a particular task.…
Read MorePL/SQL – Arrays
In this chapter, we will discuss arrays in PL/SQL. The PL/SQL programming language provides a data structure called the VARRAY,…
Read MorePL/SQL – Strings
The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric,…
Read MorePL/SQL – Loops
In this chapter, we will discuss Loops in PL/SQL. There may be a situation when you need to execute a…
Read MorePL/SQL – Conditions
In this chapter, we will discuss conditions in PL/SQL. Decision-making structures require that the programmer specify one or more conditions…
Read MorePL/SQL – Operators
In this chapter, we will discuss operators in PL/SQL. An operator is a symbol that tells the compiler to perform…
Read MorePL/SQL – Constants and Literals
In this chapter, we will discuss constants and literals in PL/SQL. A constant holds a value that once declared, does…
Read MorePL/SQL – Variables
In this chapter, we will discuss Variables in Pl/SQL. A variable is nothing but a name given to a storage…
Read MorePL/SQL – Data Types
In this chapter, we will discuss the Data Types in PL/SQL. The PL/SQL variables, constants and parameters must have a…
Read MorePL/SQL – Basic Syntax
In this chapter, we will discuss the Basic Syntax of PL/SQL which is a block-structured language; this means that the…
Read More
VB.Net – Overview
Visual Basic .NET (VB.NET) is an object-oriented computer programming language implemented on the .NET Framework. Although it is an evolution…
Read MorePL/SQL – Environment Setup
In this chapter, we will discuss the Environment Setup of PL/SQL. PL/SQL is not a standalone programming language; it is…
Read MorePL/SQL – Overview
The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL and…
Read More
SQL – RDBMS Concepts
What is RDBMS? RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern…
Read MoreSQL – Overview
SQL is a language to operate databases; it includes database creation, deletion, fetching rows, modifying rows, etc. SQL is an…
Read More
MySQL – Installation
All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required…
Read MoreMySQL – Introduction
What is a Database? A database is a separate application that stores a collection of data. Each database has one…
Read More
Python – Extension Programming with C
Any code that you write using any compiled language like C, C++, or Java can be integrated or imported into…
Read MorePython – GUI Programming (Tkinter)
Python provides various options for developing graphical user interfaces (GUIs). Most important are listed below. Tkinter − Tkinter is the…
Read MorePython – XML Processing
XML is a portable, open source language that allows programmers to develop applications that can be read by other applications,…
Read MorePython – Multithreaded Programming
Running several threads is similar to running several different programs concurrently, but with the following benefits − Multiple threads within…
Read MorePython – Sending Email using SMTP
Simple Mail Transfer Protocol (SMTP) is a protocol, which handles sending e-mail and routing e-mail between mail servers. Python provides…
Read MorePython – Network Programming
Python provides two levels of access to network services. At a low level, you can access the basic socket support…
Read MorePython – MySQL Database Access
The Python standard for database interfaces is the Python DB-API. Most Python database interfaces adhere to this standard. You can…
Read MorePython – CGI Programming
The Common Gateway Interface, or CGI, is a set of standards that define how information is exchanged between the web…
Read MorePython – Regular Expressions
A regular expression is a special sequence of characters that helps you match or find other strings or sets of…
Read MorePython – Object Oriented
Python has been an object-oriented language since it existed. Because of this, creating and using classes and objects are downright…
Read MorePython – Exceptions Handling
Python provides two very important features to handle any unexpected error in your Python programs and to add debugging capabilities…
Read MorePython – Files I/O
This chapter covers all the basic I/O functions available in Python. For more functions, please refer to standard Python documentation.…
Read MorePython – Modules
A module allows you to logically organize your Python code. Grouping related code into a module makes the code easier…
Read MorePython – Functions
A function is a block of organized, reusable code that is used to perform a single, related action. Functions provide…
Read MorePython – Date & Time
A Python program can handle date and time in several ways. Converting between date formats is a common chore for…
Read MorePython – Dictionary
Each key is separated from its value by a colon (:), the items are separated by commas, and the whole…
Read MorePython – Tuples
A tuple is an immutable sequence of Python objects. Tuples are sequences, just like lists. The differences between tuples and…
Read MorePython – Lists
The most basic data structure in Python is the sequence. Each element of a sequence is assigned a number –…
Read MorePython – Strings
Strings are amongst the most popular types in Python. We can create them simply by enclosing characters in quotes. Python…
Read MorePython – Numbers
Number data types store numeric values. They are immutable data types, means that changing the value of a number data…
Read MorePython – Loops
In general, statements are executed sequentially: The first statement in a function is executed first, followed by the second, and…
Read MorePython – Decision Making
Decision making is anticipation of conditions occurring while execution of the program and specifying actions taken according to the conditions.…
Read More
