SELECT DBMS_LOB.SUBSTR(DS_OBJECTIVES, 1000, 1) FROM T_SCNS_COURSE_REQUEST; DS_OBJECTIVES ==> field yg bertype CLOB.
klo masih kurang jelas googling aja yach. --ashfi--. Oracle Application & Apps Express Developer IT Department Sec AppDev PT Daya Adira Mustika Jln Raya Cibereum 26, Bandung 0856 8430031, 022-91993173 --- On Thu, 3/5/09, Henry G <[email protected]> wrote: From: Henry G <[email protected]> Subject: RE: [indo-oracle] Column type CLOB To: [email protected] Date: Thursday, March 5, 2009, 8:13 AM Ada apa dengan CLOB? Emang ada masalah bagaimana baca CLOB? Kalau di kantor saya, kolom CLOB biasanya buat simpan Memo ataupun XML Document karena ndak cukup kalo ditampung pake varchar2 _____ From: indo-oracle@ yahoogroups. com [mailto:indo-oracle@ yahoogroups. com] On Behalf Of hendra chen Sent: Tuesday, March 03, 2009 10:07 PM To: oracle milis Subject: [indo-oracle] Column type CLOB Dear Gurus, Bagaimana ya cara membaca table yang salah satu kolom nya bertype CLOB ? Terima kasih atas bantuan nya.. Best Regards, Hendra ____________ _________ _________ _________ _________ _________ _ Search, browse and book your hotels and flights through Yahoo! Travel. http://sg.travel. <http://sg.travel. yahoo.com> yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
