Dummy data without dummy tables – just a little SQL trick with the TABLE operator

(Lucas Jellema) While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a awkard solution to a problem that has a much more elegant one. Using a database type and the TABLE operator we hav

Read More - Register for Free Membership