1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| --测试时间到毫秒
declare
start_time number;
finish_time number;
elapsed_time number(5);
begin
select dbms_utility.get_time into start_time from dual;
dbms_lock.sleep(5);
-- do something
select dbms_utility.get_time into finish_time from sys.dual;
elapsed_time := finish_time - start_time;
dbms_output.put_line(elapsed_time);
end;
--测试时间到秒
declare
start_time char(5);
finish_time char(5);
elapsed_time number(5);
begin
select to_char(sysdate, 'SSSSS') into start_time from dual;
dbms_lock.sleep(5);
-- do something
select to_char(sysdate, 'SSSSS') into finish_time from sys.dual;
elapsed_time := finish_time - start_time;
dbms_output.put_line(elapsed_time);
end;
|