Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sowmyat

    generate auto increment field using ecmap

    I figured it out , thanks for the replies. In Ecmap we can execute a sql statement 'UPDATE UMEMP_SXC_DRUG SET SEQNBR = ROWNUM' This eleminates the need to create a sequence and a trigger if done on oracle database.
  2. sowmyat

    ECMAP , How to read highest value in a sequence.

    I have an oracle table in which a field has sequence number 1,2,3,... How to read the highest value in this field using ecmap.??
  3. sowmyat

    generate auto increment field using ecmap

    yes, I am working on that logic, I can do the rest but I do not know how to read the highest sequence number.
  4. sowmyat

    generate auto increment field using ecmap

    I know we can do it in oracle, I want to know how to do it in ecmap/
  5. sowmyat

    generate auto increment field using ecmap

    Hi, I am using ecmap connected to oracle database. I need to create a sequence number field which starts from 1 and auto increments. I have tried declaring an ecmap variable and incrementing by 1, but this sets itself to 0 the next time the map runs and starts counting from 1 again, i.,e I...

Part and Inventory Search

Back
Top