PL/SQL: Conditional, Logical, Loops
by PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in …
Tag: AKTU MBA NOTES
PL/SQL: Introduction
PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed …
Basic Architecture, Data Definition
An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical …
SQL: Derived Relations
SQL-92 allows a subquery expression to be used in the from clause. If such an expression is used, the result relation must be given a name, and …
SQL: Null Functions
In SQL Null is both a value as well as a keyword. Let’s look into NULL value first – Null as a Value In simple …
SQL: Aggregate functions
Aggregate Functions are all about Performing calculations on multiple rows Of a single column of a table And returning a single value. The ISO standard …
SQL: Set Operations
SQL supports few Set operations which can be performed on the table data. These are used to get meaningful results from data stored in the …
SQL: Background, Basic Structure
SQL stands for Structured Query Language. It is used for storing and managing data in relational database management system (RDMS). It is a standard language …
ER-Model: Reduction of E-R Schema to Tables
A database that conforms to an E-R database schema can be represented by a collection of tables. For each entity set and for each relationship …
ER-Model: Design of an ER Database Schema
The data which is stored in the database at a particular moment of time is called an instance of the database. The overall design of …
You must be logged in to post a comment.