Oracle output on HTML file

SET MARKUP HTML ON SPOOL ON HEAD "<TITLE>SQL*Plus Report</title> -
<STYLE TYPE='TEXT/CSS'><!--BODY {background: ffffc6} --></STYLE>"
SET ECHO OFF
SPOOL employee.htm

SELECT sysdate from dual;
BY modified_date ASC;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON

Forgot to mention subject in mail???

1. Open your Outlook,
2. Press Alt+F11. This opens the Visual Basic Editor and then Press Ctrl+R which in turn open Project-Project 1 (left side)
3. On the Left Pane, one can see "Microsoft Outlook Objects" or "Project1", expand this. Now one can see the "ThisOutLookSession".
4. Double click on "ThisOutLookSession". It will open up a Code Pane on the right hand side.
5. Copy and Paste the following code in the right pane (Code Pane) and save it Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
       Dim strSubject As String
       strSubject = Item.Subject
       If Len(Trim(strSubject)) = 0 Then
           Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
           If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
               Cancel = True
           End If
       End If
   End Sub
   
    
   

Run Commands

Infrequently Used Run Commands

Below are a list of commands you can type into the Run dialog, split into several categories: programs, control panels, computer administration tools, and special folders.

Programs

Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Free Cell	freecell
Hearts Card	mshearts
Microsoft Chat	winchat
Minesweeper	winmine
On Screen Keyboard	osk
Remote Desktop	mstsc
Spider Solitare	spider
Telnet Client	telnet
Windows Magnifier	magnify

Control Panels

Accessibility Controls	access.cpl
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Automatic Updates	wuaucpl.cpl
Date and Time	timedate.cpl
Display Properties	desk.cpl
Folders Properties	control folders
Fonts	control fonts
Fonts Folder	fonts
Game Controllers	joy.cpl
Internet Properties	inetcpl.cpl
Keyboard Properties	control keyboard
Mouse Properties	control mouse
Network Connections	control netconnections
Network Setup Wizard	netsetup.cpl
ODBC Data Source Administrator	odbccp32.cpl
Password Properties	password.cpl
Phone and Modem Options	telephon.cpl
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Regional Settings	intl.cpl
Scanners and Cameras	sticpl.cpl
Security Center	wscui.cpl
Sounds and Audio	mmsys.cpl
User Account Management	nusrmgr.cpl
Windows Firewall	firewall.cpl

Computer Administration Tools

Computer Management	compmgmt.msc
Device Manager	devmgmt.msc
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Management	diskmgmt.msc
Disk Partition Manager	diskpart
Dr. Watson System Troubleshooting	drwtsn32
Driver Verifier Utility	verifier
Event Viewer	eventvwr.msc
Group Policy Editor (XP Prof)	gpedit.msc
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Performance Monitor	perfmon
Resultant Set of Policy	rsop.msc
Scheduled Tasks	control schedtasks
Services	services.msc
Shared Folders	fsmgmt.msc
System Configuration Editor	sysedit
System Configuration Utility	msconfig
Utility Manager	utilman
Windows System Security Tool	syskey

Computer Administration Tools

Application Data Folder	%appdata%
Home Directory Drive	%homedrive%
Home Directory	%homepath%
Shared Home Directory	%homeshare%
Temporary Folder	%temp%
Windows Root Drive	%systemdrive%
Windows Root Directory	%windir%

Creating Your Own Run Commands

• Win+R to open the Run dialog
   
• Enter %windir% to open the Windows directory
   
• Create a shortcut to the desired program
   
• The name you give the shortcut is what you type in the Run dialog to start the program