9 Replies Latest reply: Oct 4, 2013 5:06 AM by Pars RSS

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



      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,