Osman Eyup

works for both windows 7 and windows 8: try to create a new folder on desktop then rename it to (write_sth_here) .{ed7ba470-8e54-465e-825c-99712043e01c}  it populates almost every single control feature into one directory. exp: rename new folder to "GOD-MODE .{ed7ba470-8e54-465e-825c-99712043e01c}" lols

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}

/* Formatted on 05.07.2013 10:03:10 (QP5 v5.252.13127.32847) */ SELECT REGEXP_SUBSTR (           '20130704125118|2170391:100A2876|952828909|905337662754|aksa|0||0|ORG',           '([^\|]*)\||$',           1,           5,           NULL ,           1)   FROM DUAL ----- : aksa

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(+)

        --------------------------------------------------------------------             -- 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(+)         AND

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';                                               -- Owner of the Job     v_proc               VARCHAR2(3000);                                                                   -- Procedure Name     c_delim              VARCHAR2(10)         := ' : ';                                                   -- Delimiter Used In Logging    -- get the cursor id and concatenate fetched row as html row    FUNCTION CONCATENATE_ROW (ICURNUM INTEGER)       RETURN CLOB    IS       CLOBTEMP     CLOB;       CLOBDATA     CL

Bankalara kaptırdığınız hesap işletim ücretlerini almanın yolu: http://www.eksisozluk.com/show.asp?id=31732288