Find Largest table in Oracle DB

select table_name, num_rows from dba_tables where num_rows is NOT NULL order by num_rows desc;

Enjoy :-)

copy and xcopy command in windows

Copy a file to a folder:
copy /b _source-file_ _destination-folder_

Copy a folder into another folder:
xcopy _source-folder_ _destination-folder_ /D /E /C /R /I /K /Y

Making Oracle session case insensitive

alter session set nls_comp=ansi;
alter session set nls_sort=binary_ci;

query Next week day oracle, next working day oracle

SET SERVEROUTPUT ON
/
DEFINE V_DATE_TODAY = '23-04-2011';
/
DECLARE
DAY_TODAY VARCHAR2(30);
DAY_NEXT_WORKING_DAY VARCHAR2(30);
DATE_NEXT_WORKING_DAY VARCHAR2(30);
BEGIN
SELECT REPLACE(TO_CHAR(TO_DATE('&V_DATE_TODAY','dd-MM-yyyy'), 'DAY'),' ',NULL) INTO DAY_TODAY FROM DUAL;
SELECT CASE DAY_TODAY
WHEN 'MONDAY' THEN 'TUESDAY'
WHEN 'TUESDAY' THEN 'WEDNESDAY'
WHEN 'WEDNESDAY' THEN 'THURSDAY'
WHEN 'THURSDAY' THEN 'FRIDAY'
WHEN 'FRIDAY' THEN 'MONDAY'
WHEN 'SATURDAY' THEN 'MONDAY'
WHEN 'SUNDAY' THEN 'MONDAY'
END
INTO DAY_NEXT_WORKING_DAY FROM DUAL;

SELECT NEXT_DAY(TO_DATE('&V_DATE_TODAY','dd-MM-yyyy'), DAY_NEXT_WORKING_DAY) INTO DATE_NEXT_WORKING_DAY FROM DUAL;

DBMS_OUTPUT.PUT_LINE('DATE TODAY :' || '&V_DATE_TODAY');
DBMS_OUTPUT.PUT_LINE('DAY TODAY :' || DAY_TODAY);
DBMS_OUTPUT.PUT_LINE('DATE NEXT WEEK DAY :' || DATE_NEXT_WORKING_DAY);
DBMS_OUTPUT.PUT_LINE('DAY NEXT WEEK DAY :' || DAY_NEXT_WORKING_DAY);

END;
/

Hadoop Hue & django

Hadoop Hue is written in a web-framework build in python called django.http://www.djangoproject.com/

Killing and starting the Hadoop datanode deamon

$sudo jps

check the Datanode process ID

$sudo kill -9

$sudo /etc/init.d/hadoop*datanode start

thats it!