Simple Oracle Questions!

Folks,

I'm learning Oralce (6.0), so please, excuse my simple questions.

1. How'd I subtract Time??

        I tried :

                to_char(f1, 'HH24:MM:SS') - to_char(f2, 'HH24:MM:SS')

        but, it doesn't work.

2) Can I interst a character(i.e., *) in the output of a select??

        select Name, Zip from Tab1;

        I want the output to be

		Name1 *	Zip1
		Name2 *	Zip2
		Name3 *	Zip3

Thanx in advance for your help..

-- 
------------------------------------------------------------
Jay Patel			pateljb_at_ucnix.san.uc.edu
Disclaimer: Opinions - they're mine, all mine. Details on the back.