1a). declare Cursor c1 IS SELECT tabel.kol1 FROM tabel; myvar1 tabel.kol1%TYPE; myvar2 varchar2(10);
begin open c1; fetch c1 INTO myvar1; fetch c1 INTO myvar2; ..... end; 1b). SELECT tabel.kol INTO :var FROM tabel; 2). Pada blok data di Forms tentukan property Locking Mode ferry. ----- Original Message ----- From: "Abu Naufal" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, June 04, 2005 5:52 PM Subject: [indo-oracle] Simpan hasil select di variable > Para Senior, > > Sorry pertanyaannya mendasar banget. maklum newbie > Bagaimana caranya menyimpan hasil operasi select di variable. > misalnya select x from tabley. SAya ingin menyimpan nilai x kedalam suatu > variable. > > Okey, sekalian nanya gimana caranya melakukan locking pada row di Oracle > sampai transaksi di commit. > > Terima Kasih > Abu Naufal > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- 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/
