Vision: Be a light wherever God sent

As we know, one of softwares that help us to interact with Oracle is TOAD. And for small-medium scale data, there is SQL*Loader feature to be used on TOAD. But how if you’ve around 2Terra or more data to be uploaded ? For my experiences, you will find that TOAD GUI become hang (but in the fact, you can use PL/SQL procedure to check it. sometimes, only TOAD GUI hang, but the process still running). The easiest way that will help you to upload large scale data is via command prompt. Follow this step, and feel the comfortness .. Only  [ Read More ]

Hi, Sometimes as someone who interact with Oracle Database, we need to get total row for all tables in a tablespace, or maybe for multiple tables in a short time. For this purpose, we can use this code below : SQL> set serveroutput on SQL> declare 2 numrows integer; 3 cursor c1 is select table_name from user_tables order by table_name; 4 function rowcount(tablename in user_tables.table_name%type) 5 return integer is 6 cursornum integer; 7 numrows integer; 8 ignore integer; 9 begin 10 cursornum := dbms_sql.open_cursor; 11 dbms_sql.parse(cursornum, 12 ‘select count( * ) from ‘ || tablename, 13 dbms_sql.v7); 14 dbms_sql.define_column(cursornum, 1,  [ Read More ]

Today, Facebook is launching another way for people to access Facebook anytime, anywhere: 0.facebook.com. 0.facebook.com is a new mobile site that includes all of the key features of Facebook but is optimized for speed. It initially is available through more than 50 mobile operators in 45 countries and territories with zero data charges. Collaborating with operators from around the world, Facebook developed this new mobile site with two main attributes: It’s fast: 0.facebook.com includes all the key features of our standard mobile site m.facebook.com. Users can update their status, view their News Feed, like or comment on posts, send and  [ Read More ]

“..Who you are today is the result of what have you done on the past… the past can not be undone or re-engineering.. but the future can still be reached by what you do today…Remorse will never help you, only effort can make you move forward” ~ by tanpabatas.web.id

ORACLE gives us free for usage, but we must pay for official support from ORACLE. And when company decide to use ORACLE and ask for ORACLE support, they must be given a key called as METALINK. It’s great if you have one when you work with ORACLE products. But how about if the opposite happen? Well, that’s happen to me..The company where I work doesn’t have metalink. Yes, we’re a consulting company, but only clients who decide to use ORACLE support has the metalink. Because of we’re consultants in project, so we didn’t have the metalink. At first, it will  [ Read More ]