http://orapunk.com oracle, punk, anarchy, database, bi, solution, pl/sql, sql, edge Wed, 25 Aug 2010 13:38:43 +0000 http://backend.userland.com/rss092 en Now SYSDATE Tomorow/ next day SYSDATE + 1 Seven days from now SYSDATE + 7 One hour from now SYSDATE + 1/24 Three hours from now SYSDATE + 3/24 An half hour from now SYSDATE + 1/48 10 minutes from now SYSDATE + 10/1440 1 minute from now SYSDATE + 1/1440 Tomorrow at 12 midnight TRUNC(SYSDATE + 1) Tomorrow at 10 AM TRUNC(SYSDATE + 1) + 10/24 http://orapunk.com/?p=94 Hello hello hello, See here what we were waiting for, the new OBIEE 11g. http://orapunk.com/?p=92 For the ones who wants to reset the SYSTEM pwd: operfcfg.exe -U SYSTEM -P password -D tns_entry_name http://orapunk.com/?p=90 Q. What if your Dad loses his car keys? A. 'Parent keys not found!' Q. What if your old girl friend spots you with your new one? A. 'Duplicate value on index!' Q. What if the golf ball doesn't get into the hole at all? A. 'Value larger than specified precision!' Q. What if you try ... http://orapunk.com/?p=88 Yes finally after 3 years of product tuning, there is finally the new and adult version of OBIEE. Called of course 11G (something else would have been a big surprise). You can check some more information on the following Oracel website: http://www.oracle.com/oms/businessintelligence11g/business-insight-075567.html http://orapunk.com/?p=86 Sometimes we forget some basic concepts. So do I (sometimes). To retrieve the latest record of a table it's not ALWAYS correct to use the max(rowid) of a table. The rowid is an ID generated based on file/block/slot . The only method to make sure we take the last record is a having ... http://orapunk.com/?p=84 set echo off ver off feed off pages 0 accept tname prompt 'Enter Name of Table: ' accept dformat prompt 'Enter Format to Use for Date Columns: ' spool &tname..ctl select 'LOAD DATA'|| chr (10) || 'INFILE ''' || lower (table_name) || '.dat''' || chr (10) || 'INTO TABLE '|| table_name || chr (10)|| 'FIELDS TERMINATED BY ... http://orapunk.com/?p=82 http://www.linkedin.com/groups?home=&gid=2784198&trk=anet_ug_hm http://orapunk.com/?p=79