Pada versi database lebih tinggi dari 7.3.4
syntaknya adalah sebagai berikut Alter table Tablename drop(FiledD);
hanya sintak tersebut tidak berlaku pada versi tersebut diatas(7.3.xx)
  ----- Original Message ----- 
  From: agus sulaiman 
  To: [email protected] 
  Sent: 26 January 2006 1:18
  Subject: [indo-oracle] Database Oracle


  Kepada Teman-teman semuanya,
     
     
    Misalkan kita telah membuat table dalam suatu database , dimana terdiri 
dari 4 buah field yaitu fieldA, fieldB, fieldC,fieldD. bagaimana caranya agar 
kita dapat membuang 
    hanya satu field saja mengingat field tersebut tidak pernah dipakai? 
     
    Sebagai tambahan database oracle yang dipakai adalah versi 8.05
     
     
     
     
    Thanks.

              
  ---------------------------------
  Bring words and photos together (easily) with
  PhotoMail  - it's free and works with Yahoo! Mail.

  [Non-text portions of this message have been removed]



  --
  -----------I.N.D.O - O.R.A.C.L.E---------------
  Keluar: [EMAIL PROTECTED]
  Website: http://indo-oracle.lizt.org (NEW)
  -----------------------------------------------

  Bergabung dengan Indonesia Thin Client User Groups, 
  Terminal Server, Citrix, New Moon Caneveral, di:
  http://indo-thin.vze.com 



------------------------------------------------------------------------------
  YAHOO! GROUPS LINKS 

    a..  Visit your group "indo-oracle" on the web.
      
    b..  To unsubscribe from this group, send an email to:
     [EMAIL PROTECTED]
      
    c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


------------------------------------------------------------------------------




------------------------------------------------------------------------------


  ===================================================

          This Mail Scanned By Messaging Security Suite

  ================= Provided by IT Hardware =================


[Non-text portions of this message have been removed]



--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke