Sunday, September 28, 2008

Losing My Religion Song Interpretation

Here’s my interpretation of what it is about, and an explanation of what it is about for me. The song for me is about the efforts of conveying your love to someone, trying to get them to understand how much you love them, without saying it straight out because of the fear of losing them all together.

“Life is bigger, it’s bigger than you” is a statement, logically true. It shouldn’t be the end of the world that she doesn’t love you.

“And you are not me” is the sad truth, she’s not on the same page, you are not a part of each other.

“The lenghts that I will go to” shows the power of the love, that you will go to the end of the world for her. “The distance in your eyes” is her lack of interest in you, she’s not there with you with the same emotions. “I set it up” means that you’re trying to create situations where the truth will come out, where you will get what you want.

“That’s me in the corner, that’s me in the spotlight”, you are everywhere, in the background and right in front of her. “losing my religion”, losing your faith that she loves you, losing your faith in love all together. Losing your belief that soulmates would be together no matter what.

“Trying to keep up with you, and I don’t know if I can do it”, trying to stop her from walking away from you, trying to keep moving on together, not sure that it’s working.

“Oh no I’ve said too much, I haven’t said enough”, the fear that you hinted too strongly, that it has become too obvious that you love her. Wanting to tell her more, to let it all out, thinking that maybe she didn’t get your hints, that they weren’t obvious enough.

“I thought that I heard you laughing, I thought that I heard you sing”, You thought you were going in the right direction, you thought she was there with you. “I think I thought I saw you try”, you thought she was hinting back, but you are so unsure.

“Every whisper, of every waking hour, I’m choosing my confessions”, every second of your time you’re thinking about what to reveal and what not to, planning what to say to her. “Trying to keep an eye on you”, trying to see how she reacts, what she feels and thinks about what you’re saying. “like a hurt lost and blinded fool”, you’re hurt that she doesn’t respond to your hints, you’re lost in what to do, you feel blind because you thought that you saw that she felt something for you and you feel like a fool because you allowed yourself to think that she would love you back.

“consider this, consider this, the hint of the century”, you give her the most obvious hint of your love that you can think of. “The slip that brought me to my knees failed”, you gave her the hint of a lifetime, so huge it was basically a slip and the emotional impact it had on you to tell her brought you to your knees, beat you down. But still she did not respond to you.

“What if all these fantasies come flailing around”, express the fear you have that your fantasies about you two together will never become a reality. “Now I’ve said too much”, there it was, you want to be with her and you just let yourself think it. There’s no way back, you can’t take that thought back.

“That was just a dream”, all your hinting was for nothing, it turns out she doesn’t love you back and you had just created what you wanted to be there, but what was not really.

Thursday, September 18, 2008

Replace in UTL_FILE

create or replace PROCEDURE get_cols1 (p_table_name VARCHAR2, p_file_name VARCHAR2, p_delimiter VARCHAR2)
IS
TYPE vl_t_columnlist IS VARRAY (100) OF VARCHAR2 (50); vl_c_
vl_t_columnlist;
vl_f_output_file UTL_FILE.file_type;
vl_c_proc_name VARCHAR2 (100) := 'get_cols';
vl_d_current_dtm DATE := gnvgen.systemdate ();
vl_c_statustext VARCHAR2 (1000);
vl_n_status NUMBER:=700;
v_dd varchar2(1000);
v_dd1 varchar2(1000);
v_name varchar2(1000);
v_name1 varchar2(1000):='CREATED_DTM';
BEGIN
vl_n_status:=700;
vl_f_output_file := UTL_FILE.fopen ('ANTLUTL', p_file_name , 'a');
UTL_FILE.put_line (vl_f_output_file, '(');
vl_n_status:=701;
SELECT column_name
BULK COLLECT INTO vl_c_listcol
FROM cols
WHERE table_name = p_table_name
ORDER BY column_id;
vl_n_status:=702;
FOR i IN vl_c_listcol.FIRST .. vl_c_listcol.LAST
LOOP
vl_n_status:=703;
IF i = vl_c_listcol.COUNT THEN
vl_n_status:=704;
dbms_output.put_line(v_dd1);
UTL_FILE.put_line (vl_f_output_file, vl_c_listcol(i));
vl_n_status:=705;
ELSE
v_dd:=vl_c_listcol(i);
v_name:=v_name1' "''to_date('':'v_name1',''''DD-MON-YYYY HH24:MI:SS'''')''"';
v_dd1:=(replace(v_dd,'CREATED_DTM',v_name));
vl_n_status:=706;
UTL_FILE.put_line (vl_f_output_file, v_dd1 p_delimiter);
vl_n_status:=707;
END IF;
END LOOP;
vl_n_status:=708;
UTL_FILE.put_line (vl_f_output_file, ')');
UTL_FILE.fclose (vl_f_output_file);
vl_n_status:=709;
EXCEPTION
WHEN OTHERS THEN
vl_c_statustext :=(vl_c_proc_name ' - ' vl_n_status ' - ' SQLERRM);
ist.arch_reload.error_log (vl_c_statustext, vl_d_current_dtm);
END get_cols1;