SQL Performance (MOSC)

MOSC Banner

Sql is running very slow

edited May 23, 2013 6:52AM in SQL Performance (MOSC) 13 commentsAnswered
Sql statement-----------
SELECT   emplid, empl_rcd, dur, TO_CHAR (dur, 'YYYY-MM-DD'), punch_type,
         TO_CHAR (CAST ((punch_dttm) AS TIMESTAMP),
                  'YYYY-MM-DD-HH24.MI.SS.FF'),
         TO_CHAR (CAST ((punch_end) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF'),
         rule_element_1, rule_element_2, rule_element_3, rule_element_4,
         rule_element_5, taskgroup, oprid, reported_status, oprid_last_updt,
         TO_CHAR (CAST ((dttm_modified) AS TIMESTAMP),Sql Statement
                  'YYYY-MM-DD-HH24.MI.SS.FF'
                 ),
         TO_CHAR (CAST ((dttm_created) AS TIMESTAMP),
                  'YYYY-MM-DD-HH24.MI.SS.FF'
                 ),
         trc, tl_quantity, country, business_unit, LOCATION, deptid, jobcode,
         business_unit_pc, project_id, activity_id, resource_type,
         resource_category, resource_sub_cat, user_field_1, user_field_2,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center