smart data

i believe that within three years, we'll be laughing the method that we currently manage/integrate/transform the data.
there should be another way to manage all these bunches of data. a smarter one.

tune up:
"self-managed smart data"

coming soon...

Yorumlar

Yorum Gönder

Bu blogdaki popüler yayınlar

table_to_html_mail

CREATE OR REPLACE PACKAGE BODY DDSBASE.PKG_TABLE_TO_HTML AS    -- week cursor for fetching row    TYPE REFCUR IS REF CURSOR;         v_job_module         VARCHAR2(50)         := 'REPORTS';                                               -- Job Module Name :     v_pkgc               VARCHAR2(50)         := 'PKG_TABLE_TO_HTML';                                     -- PLSQL Package Name     v_job_owner          VARCHAR2(50)         := 'DDSBASE';                                         ...
Devamı

Toad for Oracle

find saved connection information at: C:\Users\ {NT USER} \AppData\Roaming\Quest Software\Toad for Oracle\{PREV VER} copy & replace  CONNECTIONPWDS.ini and CONNECTIONS.ini files to: C:\Users\ {NT USER} \AppData\Roaming\Quest Software\Toad for Oracle\{NEW VER}
Devamı

oracle performance tuning

add a join_key=1 to both tables then join tables on that key and see the difference between Merge-sort vs Hash-join        ----------------------------------------------------------------       -- out 5,6 t1.join_key = t2.join_key  AND (  (INSTR(t1.SERVICE_NUMBER, t2.SERVICE_DIGIT) > 0 AND INSTR(t1.SERVICE_PLATFORM, t2.SERVICE_PLATFORM) > 0) /* ( t1.SERVICE_NUMBER    like '%' || t2.SERVICE_DIGIT || '%' and t1.SERVICE_PLATFORM  like '%' || t2.SERVICE_PLATFORM || '%')*/       OR       ( t1.SERVICE_VARIANT_ID= TO_CHAR(t2.SERVICE_VARIANT_ID )AND t1.SDPA_FLAG != 0 AND t1.ABONELIK_FLAG = 'N' )  )  AND   T1.DCALL_DATE BETWEEN t2.START_DATE(+) AND t2.END_DATE(+)
Devamı