maximmum value of a sequnec and viewing very large numbers
Hi,
We have a table which has a column populated using a sequence - it is maintained by code in owb but growing at larger rate than expect
e.g sequence starts at say 10000000000, would expect next row to b created with 10000000001 but large gap in between.
Have a separate ticket raised with oracel for this as mainatined via dimesnion opertaor code.
However, have couple of questions reagrding sequences.
1) How large can they be
2) If we try query numbers which over 14 digits long starts to show e in the tool we are using (pl/sql developer) Is there a way to ensure we can see the whole number (sqlplus?) and
I'm assuming say if had number column which very large say 18 digits long joined to another table 18 digits long then no issues?
Thanks