Relational Model

12 Aug 2022

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

PL/SQL Pseudocolumns

27 Jul 2022

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

PL/SQL ROWNUM

25 Jul 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

24 Jul 2022

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

PL/SQL SELECT INTO Clause

20 Jul 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

19 Jul 2022

In PL/SQL method with count(*) is unsafe.
Read more

Set Define OFF

18 Jul 2022

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

TYPE Attribute

2 Mar 2022

The %TYPE attribute lets use the datatype of a field, record, nested table, database column, or variable in your own declarations, rather than hardcoding the type names.
Read more

PL/SQL - Implicit Cursors

31 Jan 2022

Cursor

Oracle creates a memory area, known as the context area for processing an SQL statements, which contain all the informations needed for procesing the SQL statements.

Read more