Basic commands in PLSQL for getting the meta data

 August 22, 2022 |  Last Modified On: August 29, 2022

...
Read more

Relational Model

 August 12, 2022 |  Last Modified On: August 29, 2022

A relational database is a database that conforms to the relational model....
Read more

PL/SQL Pseudocolumns

 July 27, 2022 |  Last Modified On: August 29, 2022

A pseudocolumn behaves like a table column, but is not actually stored in the table.
Read more

PL/SQL ROWNUM

 July 25, 2022 |  Last Modified On: August 29, 2022

ROWNUM is a pseudocolumn (not a real column) that is available in a query. ROWNUM will be assigned the numbers 1, 2, 3,
Read more

Validate Conversion

 July 24, 2022 |  Last Modified On: August 29, 2022

VALIDATE_CONVERSION determines whether `expr` can be converted to the specified data type.
Read more

The SELECT INTO Clause

 July 20, 2022 |  Last Modified On: August 29, 2022

The SELECT INTO is actually a standard SQL query where the SELECT INTO clause is used to place the returned data into predefined...
Read more

Count(*) is unsafe

 July 19, 2022 |  Last Modified On: August 29, 2022

In PLSQL method with count(*) is unsafe.
Read more

Set Define OFF

 July 18, 2022 |  Last Modified On: August 29, 2022

The `SET DEFINE` command changes the prefix character used to mark substitution variables.
Read more

PL/SQL - Implicit Cursors

 January 31, 2022 |  Last Modified On: August 28, 2022

Oracle creates a memory area, known as the context area for processing an SQL statements, which contain all the...
Read more
PL/SQL - Implicit Cursors