CREATE PUBLIC DATABASE LINK TESTING CONNECT TO dbaname IDENTIFIED BY “dbconn” USING ‘@ORA’; Untuk mengetahui database link tersebut sudah berhasil atau belum adalah sebagai berikut: Select * from [TAB… more →
one word for you...wrote 1 year ago: Oracle teks, sebelumnya dikenal sebagai Intermedia teks dan konteks, teknologi pengindeksan berbasis … more →
wrote 1 year ago: CREATE PUBLIC DATABASE LINK TESTING CONNECT TO dbaname IDENTIFIED BY “dbconn” USING ‘@ORA’; Untuk me … more →
wrote 1 year ago: BEGIN SYS.DBMS_JOB.SUBMIT ( job => [jobs number] what => '[procedure yg dieksekusi];' next_dat … more →
wrote 2 years ago: Penggunaan syntax HAVING clause pada SQL Statement: SELECT column1, column2, … column_n, aggre … more →
wrote 2 years ago: CREATE OR REPLACE PACKAGE PKG_TERBILANG IS /******************************************************** … more →
wrote 2 years ago: Mungkin sekedar sharing ajah…dalam proyek’s “business intelligence”, munkin kita disibuk … more →
wrote 2 years ago: Dalam relations antar tabel sebetulnya bisa juga dihubungkan tanpa menggunakan Fk (foreign key ) kal … more →
wrote 2 years ago: SELECT TO_CHAR(TO_DATE(Number???,’J'), ‘jsp’) to_word FROM dual SELECT ‘Rp … more →