Hi ,
I have got the following table structure.
SQL> DESC SMS_INBOUND;
Name Null? Type
----------------------------------------- -------- ----------------------------
MSG_ID NOT NULL NUMBER(20)
DNIS NUMBER(10)
SHORT_MESSAGE VARCHAR2(200)
MOBILE_NUMBER NUMBER(10)
RECEIVE_TIME TIMESTAMP(6)
READ_FLAG NUMBER(2) Now i want to read 10 messages at particular interval, Lets say i am reading 10 messages using select statement and when to fire the select statement i am deciding through
java scheduler.
but while i am reading a messages from the table using select statement i want to update the READ_FLAG value at the same time instance.
If it possible ?
PLUS some other application will be continuously performing insert in SMS_INBOUND table.
so use of the flag is to keep track on how many messages i have read using select statement for further processing.
How do i achieve that ?
Please suggest me some idea for the same.
PS : I have posted the same topic on Oracle forum also, may be there is a solution at oracle database level.