Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TYPE METRIC_IMPERIAL_DISTANCE AS OBJECT
- (
- METERS_FEET INTEGER,
- CENTIMETERS_INCHES INTEGER,
- FRACTION NUMBER
- )
- SELECT t_id, get_distance_breakdown (h.height, h.unit_of_measure_id) height_breakdown
- FROM heights h
- SELECT t_id, get_distance_breakdown (h.height, h.unit_of_measure_id).meters_feet height_meters_feet
- FROM heights h
- SELECT t_id, height_breakdown.meters_feet
- FROM (SELECT t_id, get_distance_breakdown (h.height, h.unit_of_measure_id) height_breakdown
- FROM heights h);
- SELECT v.t_id, v.height_breakdown.meters_feet
- FROM (SELECT t_id, get_distance_breakdown (h.height, h.unit_of_measure_id) height_breakdown
- FROM heights h) v;
Add Comment
Please, Sign In to add comment