PL/SQL (MOSC)

MOSC Banner

time need to be hard code

edited Sep 7, 2011 6:13AM in PL/SQL (MOSC) 12 commentsAnswered
dear export,

I need to write a PL/SQL for sysdate need to be hard code and generate a report.

table name:

creat table roam(mobileno varchar(20), event_date date, chrges integer(12,3)

97777777 7 |12-08-2011 03:45:23 | 50.00
975555527 |12-08-2011 02:45:23 | 50.00
977773337 |12-08-2011 01:40:23 | 50.00
976766767 |12-08-2011 00:46:23 | 50.00
977565657 |12-08-2011 03:45:23 | 50.00
977777777 |12-08-2011 03:45:23 | 50.00
977777777 |12-08-2011 03:45:23 | 50.00

I need to get this records ever day 24hr before 03:00:00 time
y-day 03:00:00<event_date >today 03:00:00

this 03:00:00 need to hard code and date must be changed.

pl help me

thanks

ashwan 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center