just want to conver the elapsedtime (H:MM:SS.00) to Seconds. DBC.Qrylog has one column Elapsedtime but i want this value in seconds only.
Please suggest .
There may be better ways. However, I am thinking this way:
SELECT EXTRACT (hour FROM '13:36:15.5') *3600 a,EXTRACT (minute FROM '13:36:15.5') *60 b, EXTRACT (second FROM '13:36:15.5') c, a+b+c
I Have one more doubt. Can we restrict users to create a fallback table in system ?
can we restrict fallback table creation at user/database/system level ?