Category Archives: Oracle

Oracle Database related

Oracle and getting Milliseconds from Sysdate… [Systimestamp]

First, you can’t. Sysdate doesn’t support going to milliseconds.  However, starting with Oracle 9, you can getting milliseconds from another system source : SYSTIMESTAMP. SELECT to_char(sysdate, ‘HH24:MI:SS’), to_char(systimestamp, ‘HH24:MI:SS.FF6’) FROM dual; Powered by Qumana Advertisements

Posted in Oracle | 4 Comments

Oracle SELECT with an array using an IN

SELECT with an array with an IN declare     — CREATE OR REPLACE TYPE PROD_TYPES.TYPE_NUMBER_ARRAY AS TABLE OF NUMBER    nt_src     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    — Constructor         nt_dest     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    — Constructor      begin     — Test data (no order)     select         product_version_id    bulk collect     into         nt_src    from product_version … Continue reading

Posted in Oracle | 3 Comments