-
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.
-
But this is sql server forum.
-
To create an external file, you should look into EXTERNAL TABLE feature of Oracle.
-
Originally Posted by rmiao
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
-
Forum Rules
|
|