Cute Thing

Bo' that cute litle creature do remembers all ups and downs, monyong2 nya, bukan cuma liriknya!
Subhanallah, gw ga ragu sama sekali kalo metode ini bisa berhasil. Bukan berarti cewek kecil di atas punya masalah kerusakan otak loh yah. Tapi emang otak manusia itu Subhanallah deh. Ckckckck.

Recreate sequence using PL/ SQL

Recreate sequence using PL/ SQL:

For example, if the last value used by the Oracle sequence was 100 and you would like to reset the sequence to serve 225 as the next value. You would execute the following commands.

alter sequence seq_name increment by 124;
select seq_name.nextval from dual;
alter sequence seq_name increment by 1;

Now, the next value to be served by the sequence will be 225.

Seems handfull and confusing huh?
But it works just fine.
Just don't use it before exception DUP_VAL_ON_INDEX.
Or else, your sequence will grow like mushroom in rainy season :)

Alhamdulillah, Akhirnya

Francis-nya Indiana

Awww, ih, pengen gila punya pasangan kaya Francis Marijono.
Percaya diri, love it! It represents all good things that come after, kalem, romantis, penyayang, rasional.
And -this one is also come from gens and heritage- pebisnis handal.
Dansa di yacht pribadi, di dermaga di depan rumah pribadi, di Singapura!
Allah yang Maha Baik, saya mau saja merelakan semua itu demi ridho Mu. Tapi tetep aja saya mauuuuuuuuuuuuuuuuuuuuuu. Hehehehe.
Ok, should read deh Indiana Chronicles yang Lipstick.
Kamu mungkin bakal ngiri sama Indi atau naksir sama Francis, tapi jangan lupa, kamu (dan saya) punya hidup sendiri, karunia dari Allah. Jangan buat Dia sia-sia menciptakan kamu (dan saya) instead of menciptakan Francis, huehuheuhuehuehuehue.

Types of PL/ SQL Exceptions

List of exception you might want to catch in your PL/ SQL program