how to get required data from oracle
source is like this
i want my target data like
to get data using %_05_%
but it will give
how can i get my target data?
How can we manage the gap in a primary key column created
by a sequence?
Ex:a company has empno as primary key generated by a
sequence and some employees leaves in between.What is the
best way to manage this gap?