Data type in any programming language lets programmer identify and define the kind of data they will use in their codes. These data types can be numbers, text, dates, images,…
Category: <span>SQL</span>
When you create a schema, it may be possible that you forget to add some columns or constraints in a table. SQL Alter Table Statement gives you the capability to…
You need to learn certain basic things about PL/SQL before you begin creating code blocks in PL/SQL. Here are some PL/SQL fundamentals for you to remember. PL/SQL is NOT Case-Sensitive…
PL/SQL architecture defines how the PL/SQL blocks are executed in Oracle. Oracle provides PL/SQL engine that executes the Procedural Language part of a block. When an application program or a…
An important aspect of database systems is creation of external schemas for different users and their needs. These are also known as external views for users. One way of doing…
Subquery in SQL or nesting a query within another query is an extremely important concept in SQL. It allows the programmer to fetch rows from one table depending upon the…
SQL UNION, UNION ALL, INTERSECT and MINUS are set operations to help you to get the required data from multiple tables. It is basically application of Set Theory formulas on…