OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL Report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Report [message #314]

Tue, 05 February 2002 05:54

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.

Report message to a moderator

Re: SQL Report [message #337 is a reply to message #314]

Wed, 06 February 2002 04:23

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

Report message to a moderator

Previous Topic:	Copy in sql+
Next Topic:	Protect Operations with additional Passwords

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:42:23 CDT 2024