ROWNUM ? Setahu saya ROWNUM bukan menunjukkan nomor urut record di sebuah table.Tapi hanya nomor urut dari hasil query.
Identitas record/row ditentukan oleh ROWID. CMIIW, Bowo --- In [email protected], "Oscar Wilyanto" <[EMAIL PROTECTED]> wrote: > > Dear masters, > > mo nanya donk, gimana sih caranya reset rownum disuatu table? > > masalahnya setiap table habis didelete habis (no rows), trus diisi lagi rownumnya tidak mulai dari nol lagi.. > > thanks > Oscar > > > > > > ------------------------------------------------------------------- ----------- > This message contains confidential information and is intended only for the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and delete > this e-mail from your system. E-mail transmission cannot be guaranteed to be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore > does not accept liability for any errors or omissions in the contents of this > message, which arise as a result of e-mail transmission. If verification is > required please request a hard-copy version. > > MKD Group, www.mkdgroup.com > ------------------------------------------------------------------- ----------- > > > [Non-text portions of this message have been removed] >
