Bino

  • Home
  • Room
  • Workbench
  • Malayali
  • Desk
  • Projects
  • More
    • Travel
    • Library
    • Stats
    • Archive
    • Uses
    • Tags
    • Contact
  • About

# Database

Relational Model

12 August 2022

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

PL/SQL Pseudocolumns

27 July 2022

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

PL/SQL ROWNUM

25 July 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 July 2022

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

PL/SQL SELECT INTO Clause

20 July 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 July 2022

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

Set Define OFF

18 July 2022

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

TYPE Attribute

2 March 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 - Explicit Cursors

31 January 2022

As discussed earlier, there are two types of cursors: Implicit cursors and explicit cursors. In this section, we will focus on explicit cursors and their functionality...
Read more
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Bino Kochumol Varghese © 2026

Powered by Hugo, Netlify, Lightbi & more.

| Made with ❤️ and ✨ by Bino |

Last updated: 15 March 2026, 11:49 +0300

  • Contact
  • Wall
  • Travel
  • Archive
  • Featured
  • Stats
  • Slashes
  • Now
  • Uses
  • Library
  • Tags
  • Credits
  • Changelog
  • Disclaimer
  • Blogroll