How to remove MSN messenger completely from Windows

Friday, 8 June 2007, 2:22 | Category : Technology
Tags :

Remove MSN Messenger… Are you tired of seeing MSN Messenger pop up on your Windows XP system? As usual, in an effort to continue its course towards domination of everything, Microsoft has made it difficult to remove. But it is possible! The following method works in Windows XP Professional, but has not been tested on […]

How to switch back to win2000 style search in WinXP

Friday, 8 June 2007, 2:17 | Category : Technology
Tags : ,

Open notepad and paste following content and save the file as XPSearch.reg. After creation, double click the file and say yes on option alert box. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionExplorerCabinetState] “Settings”=hex:0c,00,02,00,1b,01,e7,77,60,00,00,00 “FullPath”=dword:00000001 “FullPathAddress”=dword:00000001 “Use Search Asst”=”no”

How to reset “View source” application in internet explorer back to notepad

Friday, 8 June 2007, 2:15 | Category : Technology
Tags : ,

Open notepad and paste following content and save the file as resetIEViewSource.reg. After creation, double click the file and say yes on option alert box. Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREMicrosoftInternet ExplorerView Source EditorEditor Name] @=”C:\Windows\notepad”

How to enable File Name completion on command prompt

Friday, 8 June 2007, 2:14 | Category : Technology
Tags :

Open notepad and paste following content and save the file as cmdComplete.reg. After creation, double click the file and say yes on option alert box. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USERSoftwareMicrosoftCommand Processor] “CompletionChar”=dword:00000009

Add “command prompt here” to right click menu of folder

Friday, 8 June 2007, 2:11 | Category : Technology
Tags :

Open notepad and paste following content and save the file as cmd.reg. After creation, double clik the file and say yes on option alert box. REGEDIT4 [HKEY_CLASSES_ROOTDirectoryshelldos] @=”Command Prompt here” [HKEY_CLASSES_ROOTDirectoryshelldoscommand] @=”cmd.exe /k cd “%1″”

How to create a new user on oracle

Friday, 8 June 2007, 1:43 | Category : Database, Technology
Tags :

create user newUser identified by userPassword; grant create session to newUser_ grant create table to newUser; GRANT create view TO newUser; GRANT CREATE SEQUENCE TO newUser; GRANT CREATE PROCEDURE TO newUser; GRANT CREATE ANY TRIGGER TO newUser; GRANT CREATE ANY TYPE TO newUser; alter user newUser quota unlimited on users;

How to schedule jobs in Oracle

Friday, 8 June 2007, 1:41 | Category : Database, Technology
Tags :

BEGIN DBMS_SCHEDULER.DROP_JOB (‘TEST_JOB’); END; / BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ‘TEST_JOB’, job_type => ‘PLSQL_BLOCK’, job_action => ‘UPDATE TABLE tblName set value=5;’, start_date => sysdate, repeat_interval => ‘FREQ=HOURLY; INTERVAL=1’, /* every one hour */ enabled => TRUE, comments => ‘Test_JOb’); END; / BEGIN DBMS_SCHEDULER.ENABLE (‘TEST_JOB’); END; /

How to send email from oracle stored procedure

Friday, 8 June 2007, 1:40 | Category : Database, Internet, Technology
Tags : ,

BEGIN UTL_MAIL.SEND ( sender => ‘[email protected]’, recipients => ‘[email protected]’, subject => ‘test Oracle’, message => ‘testing orcl’); END; /

How to drop everything on a oracle schema

Friday, 8 June 2007, 1:39 | Category : Database, Technology
Tags :

BEGIN FOR cur_rec IN (SELECT table_name, constraint_name FROM user_constraints WHERE constraint_type = ‘R’) LOOP EXECUTE IMMEDIATE ‘ALTER TABLE ‘ || cur_rec.table_name || ‘ DROP CONSTRAINT ‘ || cur_rec.constraint_name; END LOOP; FOR cur_rec IN (SELECT object_name, object_type FROM user_objects) LOOP BEGIN EXECUTE IMMEDIATE ‘DROP ‘ || cur_rec.object_type || ‘ ‘ || cur_rec.object_name; EXCEPTION WHEN OTHERS THEN […]

Selecting random rows from an oracle table

Friday, 8 June 2007, 1:20 | Category : Database, Technology
Tags :

SELECT * FROM (SELECT * FROM TEST_TABLE ORDER BY dbms_random.value) WHERE rownum <= 5; This will give 5 random rows from table.