This discussion is archived
9 Replies Latest reply: Oct 4, 2013 3:06 AM by Pars RSS

Set value of transaction no. to next value when date is same

Pars Pro
Currently Being Moderated


I'm using Oracle Apex 4.2.1 and oracle 11gR2

My table having three column trncd, trndate, trnno

My question is when i am inserting 1st transaction on todays date then trnno set to 1

and next time i'm insert another transaction on same date then trnno value automatically set to 2

next transaction same trnno is 3

and then from another  date also trnno start from 1.


Any idea?


Thanks & Regards,




  • Correct Answers - 10 points
  • Helpful Answers - 5 points