Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help With Range Query

543079Oct 23 2007 — edited Nov 8 2007

Hi folks,

Let's say I have a table with this data:

START_DATE  END_DATE
----------- -----------
01-OCT-2007
02-OCT-2007 05-OCT-2007
02-OCT-2007
03-OCT-2007
03-OCT-2007
20-OCT-2007 21-OCT-2007

I would like a query that would give me each unique date including ones that fall between the start and end dates:

01-OCT-2007
02-OCT-2007
03-OCT-2007
04-OCT-2007
05-OCT-2007
20-OCT-2007
21-OCT-2007

Selecting the unique start date is of course not a problem. I am scratching my head on how to grab the list of dates that are within a range.

Please help. Thanks.

Comments

181444
First check the status in dba_triggers for the trigger to be sure it is "ENABLED"

Check to see if the user you tested with has the ADMINISTER DATABASE TRIGGER system privilege in which case I believe that the trigger does not fire for users with this privilege.

HTH -- Mark D Powell --
OrionNet
I have tested the same trigger on sys schema and it worked just fine.
Make sure you have right set of privs

CREATE OR REPLACE TRIGGER dts_trg
AFTER LOGON
ON DATABASE
DECLARE
BEGIN
INSERT INTO kham_temp.t (action)
VALUES ('user logged in');
EXCEPTION
WHEN OTHERS
THEN
-- Consider logging the error and then re-raise
RAISE;
END dts_trg;
/
179130
I got caught out with the following undocumented parameter that stopped my LOGON triggers firing:

systemtrig_enabled=FALSE

It was during a test upgrade, which failed 1/2 way through...
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2007
Added on Oct 23 2007
9 comments
1,861 views