need help on dbms_profiler to find faulty sql code.
i have below select statement i would like to profile. how can i use dbms_profiler just on the below sql by not including it in a procedure or function ?
select empno,ename,sal,deptno from emp;
i could not find an example which meets my requirement when i googled.