What is the meaning of + sign in a condition like where consumer.consumer _id = orders.consumer _id(+);
Options
- indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as in the result set.
- indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as in the result set.
- indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as default value in the result set.
- indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as default value in the result set.
CORRECT ANSWER : indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as in the result set.
Write your comments