Basic commands in PLSQL for getting the meta data

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

...
Read more

Difference Between Cursor And Ref Cursor

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

A ref cursor can be passed to another PL/SQL routine (function or procedure) or returned to a client...
Read more

PL/SQL Ref Cursor

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

A cursor variable is a cursor that contains a pointer to a query result set....
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