For people that answered 1 or 5, you want to ask them additional questions so you will need to have enabling conditions for them.For the follow up questions, you would code the enabling conditions like this: The value for z can be an expression, a variable or a number. That is: To convert radians to decimal degrees or decimal degrees to radians, you can use the SDO_UTIL. To return a point geometry that is at a specified distance and bearing from a start point, you can use the SDO_UTIL. Examples The following example computes the bearing and tilt for two longitude/latitude points, where the elevation of the start point is 0 (zero) and the elevation of the end point is 5000 meters.

This example displays the bearing and tilt values in radians.

For this check, we would write the validation condition for the question like this: This function will return true if var matches any of the arguments in the provided list. The values in the list can either be numbers or variables.

This function provides a more simple way to write the condition: Assume you have a question (satisfied) that asks people to rank how satisfied they are with their life on a scale of 1 to 5 with 1 being very unsatisfied and 5 being very satisfied.

This survey is being conducted in 2016 so we want to check that the year entered falls in the range of 1900 to 2016.

This will also prevent interviewers from entering a year that does not contain 4 digits.

The value for z can be an expression, a variable or a number.

Value to the end of each variable to avoid a compile error. The value for a and b can be an expression, a variable or a number.

DECLARE bearing NUMBER; tilt NUMBER; BEGIN SDO_UTIL.

BEARING_TILT_FOR_POINTS( SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-71.5, 43, 0), NULL, NULL), -- start_point SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-71, 43.5, 5000), NULL, NULL), -- end_point 0.05, --tolerance bearing, tilt); DBMS_OUTPUT. PUT_LINE('Tilt = ' Tags: , ,