Forum Stats

  • 3,826,566 Users
  • 2,260,666 Discussions
  • 7,896,999 Comments

Discussions

Sequence Trigger (exclude number range) Fails wtih ORA-01403: no data found

13»

Answers

  • Mark D Powell
    Mark D Powell Member Posts: 5,914 Blue Diamond
    edited Jun 24, 2020 3:02PM

    user4249458, I will just add a note that whenever you store a number into a varchar (varchar2) column that you may encounter issues if the output needs to be sorted on this column.  Character wise '1', '10', '2' is correct sort order but what you want is likely 1, 2, 10 so it may be necessary to format the varchar2 values to have leading zeroes: to_char(number,'09').

    - -

    HTH -- Mark D Powell --

    RanagalUser_I4Y3CUser_I4Y3C