Bino

  • Home
  • Room
  • Workbench
  • Malayali
  • Desk
  • More
    • Now
    • Uses
    • Stats
    • Library
    • Archive
  • About

# Pl-Sql

Column-Level Collation and Case-Insensitive Database in Oracle

24 October 2022

Collation determines how strings are compared, which has a direct impact on ordering (sorting) and equality tests between strings.
Read more

Oracle NLS / National Language Suppport

23 October 2022

The nls_database_parameters shows the values of the NLS parameters for the database.
Read more

List the months between two dates - PL/SQL

11 October 2022

PL SQL Query to list the months between two dates.
Read more

Difference Between Cursor And Ref Cursor

9 August 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

8 August 2022

A cursor variable is a cursor that contains a pointer to a query result set....
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
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • »
    • »»

Bino Kochumol Varghese  • © 2025

Powered by Hugo, Netlify, Lightbi & more. | Made with ❤️ and ✨ by Bino |

Last updated: 08 November 2025, 16:14 +0300

  • Stats
  • Now
  • Uses
  • Library
  • Archive
  • Tags
  • Credits
  • Changelog
  • Disclaimer
  • Blogroll
The biggest adventure you can take is to live the life of your dreams. — Oprah Winfrey