The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trunc(c.zip_centroid.sdo_point.y, 5),
trunc(c.zip_centroid.sdo_point.x, 5),
c.dst_indicator, c.gmt_offset,
--to_char( c.dst_start_date, 'MM'),
to_char( to_number( to_char( c.dst_start_date, 'MM') ) ),
to_number( to_char(c.dst_start_date, 'DD') ),
to_number( to_char(c.dst_start_date, 'W') ),
to_number( to_char(c.dst_start_date, 'D') ),
to_number( to_char(c.dst_start_date, 'HH24') ),
to_char( c.dst_end_date, 'MM'),
to_number( to_char(c.dst_end_date, 'DD') ),
to_number( to_char(c.dst_end_date, 'W') ),
to_number( to_char(c.dst_end_date, 'D') ),
to_number( to_char(c.dst_end_date, 'HH24') ),
c.zip_centroid
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour, x_geometry
FROM wsh_location_data_ext c
WHERE c.ZIP_CODE = upper(l_location.postal_code) AND
c.CITY = upper(l_location.city);
SELECT trunc(c.zip_centroid.sdo_point.y, 5),
trunc(c.zip_centroid.sdo_point.x, 5),
c.dst_indicator, c.gmt_offset,
--to_char( c.dst_start_date, 'MM'),
to_char( to_number(to_char(c.dst_start_date, 'MM') ) ),
to_number( to_char(c.dst_start_date, 'DD') ),
to_number( to_char(c.dst_start_date, 'W') ),
to_number( to_char(c.dst_start_date, 'D') ),
to_number( to_char(c.dst_start_date, 'HH24') ),
to_char( c.dst_end_date, 'MM'),
to_number( to_char(c.dst_end_date, 'DD') ),
to_number( to_char(c.dst_end_date, 'W') ),
to_number( to_char(c.dst_end_date, 'D') ),
to_number( to_char(c.dst_end_date, 'HH24') ),
c.zip_centroid
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour, x_geometry
FROM wsh_location_data_ext c
WHERE c.ZIP_CODE = upper(l_location.postal_code);
SELECT trunc(AVG(c.zip_centroid.sdo_point.y), 5),
trunc(AVG(c.zip_centroid.sdo_point.x), 5),
MAX(c.dst_indicator), MAX(c.gmt_offset),
--MAX( to_char( c.dst_start_date, 'MM') ),
MAX( to_char( to_number( to_char( c.dst_start_date, 'MM') ) ) ),
MAX( to_number( to_char(c.dst_start_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_start_date, 'W') ) ),
MAX( to_number( to_char(c.dst_start_date, 'D') ) ),
MAX( to_number( to_char(c.dst_start_date, 'HH24') ) ),
MAX( to_char( c.dst_end_date, 'MM') ),
MAX( to_number( to_char(c.dst_end_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_end_date, 'W') ) ),
MAX( to_number( to_char(c.dst_end_date, 'D') ) ),
MAX( to_number( to_char(c.dst_end_date, 'HH24') ) )
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour
FROM wsh_location_data_ext c
WHERE c.CITY = upper(l_location.city) AND
c.COUNTY = upper(l_location.county);
SELECT trunc(AVG(c.zip_centroid.sdo_point.y), 5),
trunc(AVG(c.zip_centroid.sdo_point.x), 5),
MAX(c.dst_indicator), MAX(c.gmt_offset),
--MAX( to_char( c.dst_start_date, 'MM') ),
MAX( to_char( to_number( to_char( c.dst_start_date, 'MM') ) ) ),
MAX( to_number( to_char(c.dst_start_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_start_date, 'W') ) ),
MAX( to_number( to_char(c.dst_start_date, 'D') ) ),
MAX( to_number( to_char(c.dst_start_date, 'HH24') ) ),
MAX( to_char( c.dst_end_date, 'MM') ),
MAX( to_number( to_char(c.dst_end_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_end_date, 'W') ) ),
MAX( to_number( to_char(c.dst_end_date, 'D') ) ),
MAX( to_number( to_char(c.dst_end_date, 'HH24') ) )
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour
FROM wsh_location_data_ext c
WHERE c.CITY = upper(l_location.city) AND
c.STATE = upper(l_location.state);
SELECT trunc(AVG(c.zip_centroid.sdo_point.y), 5),
trunc(AVG(c.zip_centroid.sdo_point.x), 5),
MAX(c.dst_indicator), MAX(c.gmt_offset),
--MAX( to_char( c.dst_start_date, 'MM') ),
MAX( to_char( to_number( to_char( c.dst_start_date, 'MM') ) ) ),
MAX( to_number( to_char(c.dst_start_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_start_date, 'W') ) ),
MAX( to_number( to_char(c.dst_start_date, 'D') ) ),
MAX( to_number( to_char(c.dst_start_date, 'HH24') ) ),
MAX( to_char( c.dst_end_date, 'MM') ),
MAX( to_number( to_char(c.dst_end_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_end_date, 'W') ) ),
MAX( to_number( to_char(c.dst_end_date, 'D') ) ),
MAX( to_number( to_char(c.dst_end_date, 'HH24') ) )
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour
FROM wsh_location_data_ext c
WHERE c.STATE = upper(l_location.state) AND
c.COUNTY = upper(l_location.county);
SELECT trunc(AVG(c.zip_centroid.sdo_point.y), 5),
trunc(AVG(c.zip_centroid.sdo_point.x), 5),
MAX(c.dst_indicator), MAX(c.gmt_offset),
--MAX( to_char( c.dst_start_date, 'MM') ),
MAX( to_char( to_number( to_char( c.dst_start_date, 'MM') ) ) ),
MAX( to_number( to_char(c.dst_start_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_start_date, 'W') ) ),
MAX( to_number( to_char(c.dst_start_date, 'D') ) ),
MAX( to_number( to_char(c.dst_start_date, 'HH24') ) ),
MAX( to_char( c.dst_end_date, 'MM') ),
MAX( to_number( to_char(c.dst_end_date, 'DD') ) ),
MAX( to_number( to_char(c.dst_end_date, 'W') ) ),
MAX( to_number( to_char(c.dst_end_date, 'D') ) ),
MAX( to_number( to_char(c.dst_end_date, 'HH24') ) )
INTO x_latitude, x_longitude, x_dst_flag,
x_gmt_offset, x_begin_dst_month,
x_begin_dst_day, x_begin_dst_week_of_month,
x_begin_dst_day_of_week, x_begin_dst_hour,
x_end_dst_month, x_end_dst_day,
x_end_dst_week_of_month, x_end_dst_day_of_week,
x_end_dst_hour
FROM wsh_location_data_ext c
WHERE c.STATE = upper(l_location.state);