SELECT /* ORDERED (hxc tbb_det tbb_day) */
      TO_CHAR (tbb_day.start_time, 'DD-MON-RRRR') Start_Date,
       LPAD (TO_CHAR (tbb_day.start_time, 'RRRRMMDD'), 8, '0') slno,
       tbb_day.start_time,
       tbb_det.resource_id,
       TRUNC (hxc.stop_time) stop_time,
       tbb_det.resource_type,
       tbb_det.measure tot_hrs,
         (  (  TO_CHAR (
                  TRUNC (SYSDATE) + (tbb_det.stop_time - tbb_det.start_time),
                  'HH24')
             * 60)
          + TO_CHAR (
               TRUNC (SYSDATE) + (tbb_det.stop_time - tbb_det.start_time),
               'MI'))
       / 60
          TIME,
       tbb_det.unit_of_measure uom,
       tbb_det.time_building_block_id,
       tbb_det.object_version_number parent_building_block_ovn
  FROM hxc_time_building_blocks tbb_day,
       hxc_time_building_blocks tbb_det,
       hxc_timecard_summary hxc,
       HXC_TIME_ATTRIBUTE_USAGES HTAU,
       HXC_TIME_ATTRIBUTES HTA,
       PAY_ELEMENT_TYPES_F PETF
 WHERE     tbb_det.scope = 'DETAIL'
       AND tbb_day.scope = 'DAY'
       AND tbb_det.date_to = hr_general.end_of_time
       AND tbb_det.parent_building_block_ovn = tbb_day.object_version_number
       AND tbb_det.parent_building_block_id = tbb_day.time_building_block_id
       AND tbb_day.parent_building_block_ovn = hxc.timecard_ovn
       AND tbb_day.parent_building_block_id = hxc.timecard_id
       AND TRUNC (tbb_day.start_time) >= ( :P_START_DATE)
       AND TRUNC (tbb_day.stop_time) <= ( :P_END_DATE)
       AND TBB_DET.TIME_BUILDING_BLOCK_ID = HTAU.TIME_BUILDING_BLOCK_ID
       AND TBB_DET.object_version_number = HTAU.TIME_BUILDING_BLOCK_OVN
       AND HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
       AND HTA.ATTRIBUTE_CATEGORY = 'ELEMENT - ' || PETF.ELEMENT_TYPE_ID
       AND PETF.ELEMENT_NAME = 'Total Payroll Hours'

SELECT /* ORDERED (hxc tbb_det tbb_day) */

SELECT /*+ ORDERED (hxc tbb_det tbb_day) */

LPAD (TO_CHAR (tbb_day.start_time, 'RRRRMMDD'), 8, '0')

SQL> select to_char(to_date('1', 'YYYY'), 'RRRRMMDD') from dual;
 
TO_CHAR(TO_DATE('1','YYYY'),'R
------------------------------
00010301

//Generate query explain plan

EXPLAIN PLAN FOR
<select query>


//query for formatted explain plan output
SELECT  *
FROM    TABLE(DBMS_XPLAN.DISPLAY);