Skip to main content

Day One with Oracle DB Express 10g

Finally I've succeeded to download Oracle DB Express 10g last night,
although it's a little late then others (all Beta tester of this product), better late then never isn't it?

Actually I'm waiting the product to pass Beta Version before giving it a try.

Test,..!!!

Comments

Post a Comment

Popular posts from this blog

Configure Reverse Proxy Apache 2 for Oracle APEX 4.0

Just taking note reminder for myself, it's about how to configuring Apache 2 HTTP Server (Not OHS come with Compl CD of Oracle Database) as a front end HTTP Server for APEX 4.0 installed in Oracle XE 10g. Just follow the step as explain below: Install Apache 2.2 Server (Source can be downloaded from http://httpd.apache.org/download.cgi) installed with listening port configure at 8888 Install Oracle XE 10g Database (Download from http://www.oracle.com/technetwork/database/express-edition/downloads/index.html) installed with listening port configure at 7777 Install APEX 4.0 (Download from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html) After those development tools installed last thing to do is Configure Apache2 to become front server and static images server for APEX 4.0 then do the following steps: Enable/Activate module mod_proxy, proxy_http_module with LoadModule Directive. Configuration example: LoadModule proxy_module /usr/...
Post a Comment
Read more

Memproses CSV yg di upload menggunakan APEX

Setelah mencari-cari cara untuk memenuhi kebutuhan seperti judul blog ini beberapa waktu,... Akhirnya pencarian mendapatkan setitik pencerahan dari 2 link berikut: http://avdeo.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/ dan http://application-express-blog.e-dba.com/?p=1728 Dari 2 tips tersebut tampaknya jika langsung memproses binary file XLS (MS Excel) belum berhasil tetapi karena kebutuhan nya sudah bisa dicukupi dgn mengubah format file ke CSV (Coma Separated Value), akhir Saya putuskan untuk mencobanya. Mengenai bagaimana menggunakan fitur dasar File Upload dgn APEX bisa dipelajari di sini. Sekarang yg akan dijelaskan adalah post upload process dari APEX tersebut. Semua file yg diupload dgn APEX akan tersimpan di tabel APEX_APPLICATION_FILES yg merupakan alias/synonym ke tabel WWV_FLOW_FILES. Struktur Tabel APEX_APPLICATION_FILES: SQL> desc apex_application_files Name Null? Type ----------------------------...
Post a Comment
Read more

Behind The Scene of Processing CSV in Oracle Database using PL/SQL

Melanjutkan postingan sebelumnya: Memproses CSV yg di upload menggunakan APEX dimana penjelasan back end process dan behind the scene Saya coba paparkan semudah mungkin. Langkah-langkah mengkonversi konten CSV menjadi baris-baris tabel di Oracle Database bisa dilakukan dengan tahapan berikut init. Pasang dulu 2 fungsi yang sangat dibutuhkan yaitu: Fungsi F_CSV_CONVERT_TO_TABLE Fungsi HEX_TO_DECIMAL Fungsi F_CSV_CONVERT_TO_TABLE (Detail) CREATE OR REPLACE FUNCTION "F_CSV_CONVERT_TO_TABLE" ( p_in_string IN VARCHAR2 , p_in_encapsulator IN VARCHAR2 DEFAULT '"' ) RETURN wwv_flow_global.vc_arr2 AS l_string VARCHAR2(32767) := p_in_string || ','; l_quote_start_index PLS_INTEGER := 0; l_quote_end_index PLS_INTEGER := 0; l_comma_index PLS_INTEGER; l_index PLS_INTEGER := 1; l_tab wwv_flow_global.vc_arr2; i PLS_INTEGER := 1; BEGIN LOOP l_comma_index := REGEXP_INSTR(l_string, '[,...
Post a Comment
Read more