A collection of tech notes, personal reflections, and evolving thoughts about whatever’s caught my curiosity.

notes

Good old days

12 January 2025

Can I go back to the good old days
just for one last time?

To smile without the weight of pain,
and breathe in the calm of peace.
To make myself believe that chaos
and suffering no longer lingers within me.

To live a life unburdened by curses,
to feel blessed-
the way I always deserved to be.

Can I go back to the time
when everything seemed beautiful,
even if only in my dreams,
just one more last time?

notes

To extract the value of a tag from an XML-like string in PL/SQL

12 January 2025

To extract the value of a tag from the given XML-like string in PL/SQL, you can use the EXTRACTVALUE function or XMLTABLE for XML processing.

Example Using EXTRACTVALUE

DECLARE
    xml_data CLOB := '<Status>200</Status><Message>Success</Message>';
    l_message VARCHAR2(50);
BEGIN
    -- Extract the FunctionalReferenceID value
    l_message := EXTRACTVALUE(XMLTYPE('<root>' || xml_data || '</root>'), '/root/Message');
    
    -- Print the value
    DBMS_OUTPUT.PUT_LINE('FunctionalReferenceID: ' || l_message);
END;

Example Using XMLTABLE

DECLARE
    xml_data CLOB := '<Status>200</Status><Message>Success</Message>';
    l_message VARCHAR2(50);
BEGIN
    -- Use XMLTABLE to extract the Message
    SELECT value
    INTO l_message
    FROM XMLTABLE(
        '/root/Message'
        PASSING XMLTYPE('<root>' || xml_data || '</root>')
        COLUMNS value VARCHAR2(50) PATH '.'
    );

    -- Print the value
    DBMS_OUTPUT.PUT_LINE('Message: ' || l_message);
END;

EXTRACTVALUE, XMLTABLE

notes

Phoenix

11 January 2025

After all the chaos,
I will be reborn from the ashes
and soar high to the moon,
like a phoenix from a fairy tale.

I hope you’ll watch me
rise, just like the old days.

notes

The Night

27 December 2024

Sometimes, the night is a good time to hide yourself from the rest of the world. It gives a sense of relief, allowing you to be exactly as you want to be.

In the middle of the dark night you become your true self.

essay

Am I asking the right questions?

21 December 2024
I want to ensure I'm asking myself meaningful questions that encourage self-awareness and guide me to the better life.....
essay

The future

14 December 2024
This is my personal website, and I want to add a lot of things to it. Recently, I have been making many changes to the website and have developed an obsession with adding new features or improvements daily.
essay

Who am I?!

7 December 2024
This is the question I’ve asked myself the most in life. Yet, I’ve never been able to find a definitive answer...
notes

The promise

6 December 2024

I know that one day I will collapse,
And hopefully, you won’t witness it.
I will make sure that, until your last breath,
I’ll stay strong and keep us stronger.

That’s the promise I made—to hold you
Forever.

notes

It's you

5 December 2024

You are the most precious gift
you could ever wish for.
You are the light that guides you
through the darkest nights.
You are the Santa
you’ve always dreamed of.
You are the Christmas
you’ve been waiting for.