Results 1 to 4 of 4

Thread: Oracle - Dynamic Trigger

  1. #1
    Join Date
    Feb 2011
    Posts
    5

    Oracle - Dynamic Trigger

    Hi,

    i created a trigger for inserting a data. Now i use to fetch data by using select query, i want to create a csv or excel file while the end of the month, as well as this trigger wants to execute by checking the date compared with month end.

    Eg. create or replace trigger [triggername]
    BEFORE INSERT ON [tablename]
    when(calldatetime == [lastdatetime])
    begin
    [how to create csv file creation here]
    end

    [lastdatetime] - want to fetch the date automatically, for example, january - 31, Feburary - 28 , if leap year means -29 , likewise it wants to date

    kindly anybody help me, by sharing your ideas.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    But this is sql server forum.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    To create an external file, you should look into EXTERNAL TABLE feature of Oracle.

  4. #4
    Join Date
    Feb 2011
    Posts
    5
    Quote Originally Posted by rmiao View Post
    But this is sql server forum.
    Yes, of course, i tried in sql server, it working. but now want to develop the same steps in oracle. So that i'm in need of somebodies help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •