This query will capture the View Details Page (VDP) link of a vehicle on a specific website, then add the URL to the export file. There are 3rd party website hosts, like Facebook, that advertise inventory for the dealership but want to include a link to the dealer’s main website. These links need to be captured, stored, then added to the export for that site host.

This dealership wants the links of specific vehicle Makes to reference one website, and other Makes to reference their other website. The VDP values are saved in a temporary table. Depending on the name of the website URL (hickorycadillac or everettchevy) a different URL value will be stored with the label detailref. Then on the export file, the temporary table can be referenced and the value of that label can be placed with each record.

Tools: Oracle SQL.