Home » SQL & PL/SQL » SQL & PL/SQL » SQL Report
SQL Report [message #314] Tue, 05 February 2002 05:54 Go to next message
Ram S.
Messages: 3
Registered: February 2002
Junior Member
Hi, I have to send some data to a user everyday. I can spool a file in a report format but can somebody help me how to automate that process? I would like to send it through e-mail(Microsoft Outlook) to few people.Thanks in advance for your help.
Re: SQL Report [message #337 is a reply to message #314] Wed, 06 February 2002 04:23 Go to previous message
laxman
Messages: 14
Registered: October 2000
Junior Member
you can use Mailing facility in Pl/sql and Dbms_job to chive this.

plz refer
http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_jo2.htm#1001490

http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/utl_smtp.htm#1000695

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:255615160805
Previous Topic: Copy in sql+
Next Topic: Protect Operations with additional Passwords
Goto Forum:
  


Current Time: Fri Sep 24 14:14:06 CDT 2021