Oracle Certificate Profession 1Z0-051-16

（16）Evaluate the following query:

SELECT promo_name || q'{'s start date was }' || promo_begin_date AS "Promotion Launches" FROM promotions;

What would be the outcome of the above query?

A. It produces an error because flower braces have been used.

B. It produces an error because the data types are not matching.

C. It executes successfully and introduces an 's at the end of each promo_name in the output.

D. It executes successfully and displays the literal " {'s start date was } " for each row in the output.

答案：（C）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1157186/，如需轉載，請註明出處，否則將追究法律責任。