SQL> insert into bla bla
sql> /
1135608 rows created.
Elapsed: 03:215:12958.64
sql> commit;
What on earth is 03:215:12958.64, some new Oracle standard for representing times?
Printable View
SQL> insert into bla bla
sql> /
1135608 rows created.
Elapsed: 03:215:12958.64
sql> commit;
What on earth is 03:215:12958.64, some new Oracle standard for representing times?
I guess this was bug. What sqlplus version you are using ? If you are using 8.1.6, try version 8.1.7 or 9i
Sanjay
hours:hours*60+minutes:hours*3600+minutes*60+seconds:hundredths
It is a known bug