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 […]
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”
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”
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
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″”
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;
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; /
BEGIN UTL_MAIL.SEND ( sender => ‘[email protected]’, recipients => ‘rst@yahoo.’, subject => ‘test Oracle’, message => ‘testing orcl’); END; /
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 […]
SELECT * FROM (SELECT * FROM TEST_TABLE ORDER BY dbms_random.value) WHERE rownum <= 5; This will give 5 random rows from table.