오라클, SQL, 자바, 스프링프레임워크, 닷넷, C#, WPF 강좌: dbms_utility.get

PLSQL,프로시저,함수,쿼리수행시간,set timing on,dbms_utility.get_time,systimestamp,오라클교육, SQL교육,자바교육,오라클학원,SQL학원,자바학원

http://ojc.asia/bbs/board.php?bo_table=LecSQLnPlSql&wr_id=733

PLSQL,프로시저,함수,쿼리수행시간,set timing on,dbms_utility.get_time,systimestamp,오라클교육, SQL교육,자바

PLSQL,프로시저,함수,쿼리수행시간,set timing on,dbms_utility.get_time,systimestamp,오라클교육, SQL교육,자바교육,오라클학원,SQL학원,자바학원오라클 PL/SQL프로시저, 함수, 쿼리 수행시간set timing ondbms_utility.g

ojc.asia

https://www.youtube.com/watch?v=YzJK7u7sf6U&list=PLxU-iZCqT52CfP98Y4gCDKIm52tKvgy36&index=45

https://www.youtube.com/watch?v=6Dj4un2o9bQ&list=PLxU-iZCqT52CfP98Y4gCDKIm52tKvgy36&index=44

https://www.youtube.com/watch?v=0CYrvAWrBjk&list=PLxU-iZCqT52CfP98Y4gCDKIm52tKvgy36&index=43

https://www.youtube.com/watch?v=XJOkRPZYSYo&list=PLxU-iZCqT52CfP98Y4gCDKIm52tKvgy36&index=42

프로시저, 함수, 쿼리 수행시간

set timing on

dbms_utility.get_time

systimestamp

[실습 : 프로시저를 만들어서 이를 호출하고 수행시간을 측정하고 출력]

create or replace procedure getCount (p_deptno in number)
is
    v_count number;
begin
    select count(1)
    into v_count
    from myemp1
    group by deptno
    having deptno = p_deptno;

    dbms_output.put_line(' count : ' || v_count);
end;

set serveroutput on
declare
    v_start number;
    v_end number;
    v_sec number;
begin
    v_start := dbms_utility.get_time;
    getCount('1');
    v_end := dbms_utility.get_time;

    v_sec := ( v_end - v_start ) /100;

    dbms_output.put_line(' sec : ' || v_sec);
end;

count : 5000001
sec : 1.53

set timing on
declare
    v_start timestamp;
    v_end timestamp;
    v_sec varchar2(50);
begin
    -- systimestamp : 년월일시분초 밀리세컨드 까지 표현
    v_start := systimestamp;
    getCount('1');
    v_end := systimestamp;

    v_sec := to_char( v_end - v_start);

    dbms_output.put_line(' v_sec : ' || v_sec);
end;

count : 5000001
v_sec : +000000000 00:00:01.418000000

#PLSQL,#프로시저,#함수,#쿼리수행시간,#settimingon,#dbms_utility.get_time,#systimestamp,#오라클교육, #SQL교육,#자바교육,#오라클학원,#SQL학원,#자바학원,PLSQL,프로시저,함수,쿼리수행시간,settimingon,dbms_utility.get_time,systimestamp,오라클교육, SQL교육,자바교육,오라클학원,SQL학원,자바학원

2022년 1월 9일 일요일

PLSQL,프로시저,함수,쿼리수행시간,set timing on,dbms_utility.get_time,systimestamp,오라클교육, SQL교육,자바교육,오라클학원,SQL학원,자바학원

(C#교육동영상)C# ADO.NET 실습 ODP.NET/ODAC 설치 오라클 함수 호출 실습, C#학원, WPF학원, 닷넷학원, 자바학원

신고하기

태그