________________________________ From: Wibowo Yulius [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 01, 2007 1:29 PM To: Herry Yusirwan Subject: Re: bahasa pemograman? Bahasa yg bisa dipakai di Oracle (Database), baik itu utk bahasa berinteraksi maupun pembuatan sub-program di dalama database, a.l: 1. SQL : SELECT, INSERT, UPDATE, DELETE, MERGE, CREATE, DROP, ... Ini non-procedural language. Jadi tidak ada iterasi, percabangan, atau error handling Dan Oracle menggunakan SQL standard ANSI maupun SQL "specific" Oracle. 2. PL/SQL ini procedural language. Native di Oracle environment, baik di database maupun yg dipakai di tools spt Form & Report 3. Java Selama di dalam database ada JVM (Java Virtual Machine), maka bisa dibuat program dengan menggunakan Java disalam database. Tetapi untuk eksekusinya harus dipublish/map sebagai PL/SQL terlebih dulu. CREATE OR REPLACE PROCEDURE.... AS LANGUAGE JAVA .... Java juga bisa diimplementasikan di Oracle Tools, spt Form sebagai Java Bean. 4. C/C++ Bisa dipakai dari dalam database dengan catatan bahasa C/C++ dipakai untuk membuat external procedure yg nantinya bisa dipakai/dipanggil dari dalam Oracle Database. CREATE OR REPLACE PROCEDURE.... AS LANGUAGE C .... Saran saya kalau ingin belajar "bahasa" Oracle, pelajari dulu SQL, kemudian PL/SQL. Sedangkan Java atau C/C++ sifatnya optional. Mungkin catatan ini bisa dishare buat rekan2 di milis . Bowo Herry Yusirwan <[EMAIL PROTECTED]> wrote: Dear Pak Yulius, pa kbar, pak? mudah2an baik2 saja. berhubung di milis tadi ada yang menanyakan tentang bahasa pemograman, saya jadi tergelitik dengan satu pertanyaan. oracle sendiri memiliki beberapa bahasa pemograman. apakah ada segmentasi terhadap bahasa pemograman tersebut? tolong di jelaskan karena ini bisa menjawab pertanyaan simple "saya harus belajar bahasa pemograman apa?". mohon pencerahannya terima kasih Rgds, herry DISCLAIMER: This Message is confidential; it contents does not constitute a commitment by PT. INDONESIA POWER, except where provided for in a written agreement between you and PT. INDONESIA POWER. Any unauthorized disclosure, use or dissemination of the content, either whole or partial, is strictly prohibited. If you are not the intended recipient of the message or you have received this electronic transmission in error, please notify or contact the sender immediately. PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in power generating business. Through its 130 power plants, with a total capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to the Java Bali interconnection system electricity supply. PT.INDONESIA POWER operates through its eight generating Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one maintenance Services business unit (MSBU). ________________________________ Ahhh...imagining that irresistible "new car" smell? Check out new cars at Yahoo! Autos. <http://us.rd.yahoo.com/evt=48245/*http:/autos.yahoo.com/new_cars.html;_ ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM- > DISCLAIMER: This Message is confidential; it contents does not constitute a commitment by PT. INDONESIA POWER, except where provided for in a written agreement between you and PT. INDONESIA POWER. Any unauthorized disclosure, use or dissemination of the content, either whole or partial, is strictly prohibited. If you are not the intended recipient of the message or you have received this electronic transmission in error, please notify or contact the sender immediately. PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in power generating business. Through its 130 power plants, with a total capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to the Java Bali interconnection system electricity supply. PT.INDONESIA POWER operates through its eight generating Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one maintenance Services business unit (MSBU). [Non-text portions of this message have been removed]
