Writing

20 November 2024

I want to write something every day. I don’t know what to write, but I love to write.

I don’t want to write for publishing; I want to write for the sake of writing.

I think I can write about myself, the thoughts in my head, or the things around me.

So, I am writing here to feel alive.

Light is coming

18 November 2024

To those who are in dark: Hold on, light is coming—and it’s within you.

Bahrain Airshow

15 November 2024

Went to the Bahrain Airshow with Gino, and friends. It was an amazing experience filled with excitement. Witnessed incredible performances by the Indian Air Force Sarang Helicopter team, the U.S. Fighting Falcon, the Pakistan Air Force Thunder demo, and the Saudi Hawks. The Saudi fighter team’s display was truly spectacular. Had the chance to meet U.S. pilots also.

Explored a helicopter for the first time, checking off a bucket list item! A day filled with awe, adventure, and unforgettable memories.

ഓർമ്മകൾ

15 November 2024

എല്ലാ യാത്രകൾക്ക് ശേഷവും
അവസാനിക്കുന്നത് മനോഹരമായ
ഓർമ്മകളാണ്.
നിങ്ങൾ, നിറങ്ങൾ, ചിറകുകൾ
എല്ലാമൊരു മധുരസ്വപ്നം പോലെ
ഭംഗിയുള്ളത്.

നുകരട്ടെ ഞാൻ ആവോളം,
ഇതെല്ലാം ആസ്വദിക്കാൻ
കാലമിനിയും അവസരം തരട്ടെ.

Winder rides

14 November 2024

Today is throwback thursday and here is beautiful view of Bahrain in the winter.

Moment

13 November 2024

I want to live in this moment because it’s all I truly own. Once it’s gone, it’s gone forever.

PL/SQL commands to view the table details

13 November 2024

In Oracle PL/SQL, you can use the following commands to view table details:

  1. DESCRIBE or DESC

    DESC table_name;
    

    Displays columns, data types, and constraints.

  2. USER_TAB_COLUMNS

    SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH
    FROM USER_TAB_COLUMNS
    WHERE TABLE_NAME = 'TABLE_NAME';
    

    Shows details about columns for tables owned by the user.

  3. ALL_TAB_COLUMNS

    SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH
    FROM ALL_TAB_COLUMNS
    WHERE TABLE_NAME = 'TABLE_NAME';
    

    Provides column information for tables accessible to the user.

  4. DBMS_METADATA.GET_DDL

    SELECT DBMS_METADATA.GET_DDL('TABLE', 'TABLE_NAME') FROM DUAL;
    

    Displays the CREATE TABLE statement for table structure details.

To view constraints on the table, you can check here.

Use Flashback Query

11 November 2024

If your Oracle database has Flashback enabled, you can query past versions of data within a specified retention period. Here’s how to use Flashback to retrieve a prior state of data:

SELECT * 
FROM your_table AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '5' MINUTE) 
WHERE your_condition;

Replace SYSTIMESTAMP - INTERVAL '5' MINUTE with the timestamp or interval that reflects when the data was last known to be in its old state.

Note: Flashback must be enabled, and it’s only available within the Flashback retention window, which depends on your database configuration.

References

Killians Bytes

How to break columns in Bootstrap

3 November 2024

Breaking columns to a new line in flexbox requires a small hack: add an element with width: 100% wherever you want to wrap your columns to a new line.

<div class="container text-center">
  <div class="row">
    <div class="col-6 col-sm-3">.col-6 .col-sm-3</div>
    <div class="col-6 col-sm-3">.col-6 .col-sm-3</div>

    <!-- Force next columns to break to new line -->
    <div class="w-100"></div>

    <div class="col-6 col-sm-3">.col-6 .col-sm-3</div>
    <div class="col-6 col-sm-3">.col-6 .col-sm-3</div>
  </div>
</div>

You can also apply this break at specific breakpoints with our responsive display utilities.

<div class="container text-center">
  <div class="row">
    <div class="col-6 col-sm-4">.col-6 .col-sm-4</div>
    <div class="col-6 col-sm-4">.col-6 .col-sm-4</div>

    <!-- Force next columns to break to new line at md breakpoint and up -->
    <div class="w-100 d-none d-md-block"></div>

    <div class="col-6 col-sm-4">.col-6 .col-sm-4</div>
    <div class="col-6 col-sm-4">.col-6 .col-sm-4</div>
  </div>
</div>
References

Bootstrap Doc