Maksudnya begini select INSTANCE_NAME, HOST_NAME into :nbt_sid, :nbt_servernm from V$INSTANCE
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Oyib Sent: 22 Nopember 2005 7:28 To: [email protected] Subject: Re: [indo-oracle] server name Sorry pak alam, maksud saya nama komputernya atau IP juga tidak apa, kalau nama data base saya juga sudah coba dg : select name into :db_name from v$database Thank's pak alam atas infonya.. ----- Original Message ----- From: "Alamsyah" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, November 21, 2005 1:56 PM Subject: RE: [indo-oracle] server name > Coba pakai query ini. > > select INSTANCE_NAME into :nbt_sid > from V$INSTANCE > > Semoga membantu... > > Alamsyah > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf Of Kang Oyib > Sent: 21 Nopember 2005 13:25 > To: [email protected] > Subject: [indo-oracle] server name > > Dear All, > > Saya sedang belajar oracle, saya mendapat kesulitan untuk select nama > server > yang sedang saya akses, > mungkin diantara rekan's sekalian ada yang dapat memberikan solusi...? > > Terimakasih sebelumnya.... > > Best Regard's > > Oyib aja > > > [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 > > > > > > > > > > -- > > -----------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 > > > > > > -- -----------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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
