How to create a second set of records in Oracle

Question

I have set of records:

Title     Format
ABC       CD
DEF       CD

I want to add a an additional format. The final set will look like:

Title     Format
ABC       CD
DEF       CD
ABC       LP
DEF       LP

What will the query look like?

Answer 1

I would use UNION ALL

SELECT title, format FROM table
UNION ALL
SELECT title, 'LP' FROM table