1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to send the output of a table as a mail using shell script,,, pls help

Discussion in 'SQL PL/SQL' started by vijayspecial, Nov 28, 2013.

  1. vijayspecial

    vijayspecial Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    I have a sql developer and unix box..
    i need to send the output of a table as a mail using shell script..
    can you please give some idea on this..
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Method of the solution of a task, in most cases, always not one...

    you need to write a task more precisely....


    Here one of possible scenarios and reference to :

    1) export of data, for example in csv the file

    http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:88212348059


    2) execute shell script ,for example from stored procedure
    http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:16212348050


    P.S. example of sending the post message from oracle

    http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:255615160805

    Oracle documentation :

    http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_mail.htm#ARPLS71209