Me on Information Tech

I am reposting an article ( 7 Habits To Win In Office Politics ) that was originally from lifehack.org authored by Lawrence Cheok, but with my own interpretations. I found this post helpful and factual and thought that it might also get you to work around on hard times in your own office or workforce. Everything that is posted in here is purely objective, thus you may agree or not agree on points that i might find essential. However, there is always a room for discussions and exchange of views, you may post comments or share more ways that you think should be included in this list. Way # 1. Be aware you have a CHOICE In all circumstances, disputes and disagreements arise without caution that can break or make your career. You just have two options when this comes your way, be sober and drool over the situation or get over it and move forward. It is up to you to choose the right feelings for the situation, staying long in aggression is not a good idea neither...

I’ve done minimal programming stuffs for two months now. It is a sign that things are not going too well, I miss squeezing juice of logic from my brain from time to time (*sad). I miss using programming IDEs and having headaches due to overtime work. Weird huh? Yes, I guess I am. Maybe you’re wondering what I have been up to, here is a gist of what my work is like for the past two months. I’ve been maintaining the company corporate web site, cool isn’t? big time! Sounds fun and interesting and seems to have tons of programming stuffs to be done right? But you’re wrong. In the beginning of the project we all thought that we’ll be doing a lot of programming jobs and expecting to encounter complicated codes especially dojo scripts (my knowledge in dojo is the reason why I was chosen to be part of the project). But to my dismay, the company uses a web publisher that allows any key employee to update the content anytime as they desire but not the layout and other technical details of th...

I have not post for quite a long time since my last post. I’ve been busy doing the new project I am now into. As a sweet fruit of labor, I would like to share some knowledge I have gained in this new venture. I was assigned to the global IT projects together with two more colleagues. A lot of new technologies that we need to cope up with, especially dealing with the critical and gem departments of the company - marketing and sales, every detail is scrutinized and case studied thoroughly. Quality and reliability of the system is the top most importance of the development. A portion of everything done is the server configuration and optimization; this is to aid the system for the search management and site hits. The standard tools used by the company are Solr and Nutch working together pretty well, thus we end up studying these technologies. A brief description: Apache Solr - is an open source enterprise search server based on the Lucene Java search library, with XML/HTTP and JSON...

These three famous Javascript frameworks are certainly in the top list of every web developer. They are a proven help in developing dynamic and creative web portals. Without their birth, how in the earth “google” could produce a fanstatic portal such as “igoogle” ( hhmmmm have you thought of it? ). Now, if you are just starting to explore the usage and advantages of either of these frameworks, let me give you a little hint of the best tool to use in your application (*wink). Advantages … 1. AJAX Function All of these frameworks enable you to deal with AJAX with ease and they are also cross-browser compliant. Besides simple requests, they also provide various ways to handle the response from the server, either through XML, JSON or plain text. My advise here, if you only need a way to use AJAX functions and customized UIs is not a concern, use the primitive framework – prototype. Prototype is the best tool to use as it is just a one file function compared to the other two custo...

You can select list of tables from all the different schemas in your oracle database, here’s how SELECT all_tables FROM all_tab_columns; or get all the table details SELECT * FROM all_tab_columns;

Here are some helpful tips to remember when dealing with oracle. I. Use the “flashback technology” when you accidentally commit a mistake with your production data. (altering entire table contents, corrupted table data, or worst dropping unintended table). - First thing to do is to enable flashback on your database. ALTER DATABASE FLASHBACK ON; - Restoring database to its good state. FLASHBACK DATABASE TO RESTORE POINT bef_damage; - Restoring dropped table. FLASHBACK TABLE [TABLE_NAME] TO BEFORE DROP; - Restoring table to its good state. FLASHBACK TABLE [TABLE_NAME] TO TIMESTAMP TO_TIMESTAMP('[DATE_TIME]'); II. Manipulate date and time display Aside from to_date and to_timestamp functions , you could also alter the date and time display in your database through the use of this code below. ALTER SESSION SET NLS_DATE_FORMAT = '[DATE_FORMAT]'

Split, Join and DateDiff are just few Oracle functions that can aid you in data manipulation. Function Definition Split - split a result by “character specified (by default, comma)” into multiple results. e.g. “A,B,C” –> results 3 records of “A”,”B”, and “C”. Join - join multiple records into one result by “character specified (by default, comma)”. e.g. “1″,”2″,”3″ –> results 1 record of “1,2,3″. DateDiff - Differentiate two dates. Function Code create or replace function split( p_list varchar2, p_del varchar2 := ',' ) return split_tbl pipelined is l_idx pls_integer; l_list varchar2(32767) := p_list; l_value varchar2(32767); begin loop l_idx := instr(l_list,p_del); ...