The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?

Question

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:A user needs to extract the dealership information from the JSON.How can this be accomplished?

Oliver Buss · Accepted Answer

select src:dealership from car_sales;

Oliver Buss · Answer

select src.dealership from car_sales;

Oliver Buss · Answer

select src:Dealership from car_sales;

Oliver Buss · Answer

select dealership from car_sales;

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 239 - COF-R02 discussion

Suggested answer: A

0 comments