Is there anyway to concatenate two string results without using variables?
I want to concatenate query results like these two in the Code Box.
The result from the first is '08OUT14' and from the second one is 'JOCO', so the result that i want would be '08OUT14JOCO'.
SELECT TO_CHAR(data_inicio,'YYMONDD') FROM registo_eventos WHERE customer_id = 28704000002662
SELECT SUBSTR(p.display_name,1,3) FROM ev_produtos ev, product p WHERE p.product_id = ev.product_id AND customer_id = 28704000002662