It is possible to move Oracle index to another tablespace.

It is possible to move oracle index like tables.

alter table tab move tablespace blabla;
alter index tab_index rebuild tablespace blala;

How to find readable time difference bettween Oracle date types?

It is not crucial, but it is cool. This way you can find time date/time difference nicely.

SELECT

lpad(EXTRACT(HOUR FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ hour ‘ ||
lpad(EXTRACT(MINUTE FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ minute ‘ ||
lpad(EXTRACT(SECOND FROM(dend_date – dstart_date) DAY TO SECOND),2,’0′) || ‘ second ‘ “Interval”
FROM process_log
order by dstart_date desc;

ref::Oracle® Database SQL Reference
10g Release 2 (10.2)
B14200-02

Mozilla Sunbird™

Another qualified product from Mozilla.

http://www.mozilla.org/projects/calendar/sunbird/
———————————
Mozilla Sunbird™ is a cross-platform calendar application, built upon Mozilla Toolkit. Our goal is to bring Mozilla-style ease-of-use to your calendar, without tying you to a particular storage solution.

CMD.exe pre-configuration

It is well known that Oracle-sql*plus can be configured with a login.sql file preferably placed under same directory of sql*plus. But what about cmd.exe on Windows.

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\AutoRun
and/or
HKEY_CURRENT_USER\Software\Microsoft\Command Processor\AutoRun

if you edit AutoRun key with a file address (i prefer-> c:\initial.bat), cmd.exe executes that file firstly. this way you can configure your regular work automatically.

Hello World

it is a classic. But i find no other way to start.

#include <stdio.h>
int main(void)
{

printf(“%s”,”Hello World\n”) ;
}