Query table value aliasing in Oracle SQL
- by Strata
I have a homework assignment in SQL for Oracle 10g where I have to apply union to two different select statements, to return two columns. I need the values of each cell under vendor_state to indicate CA and every other value in another state to return "Outside CA", to indicate they're elsewhere.
I applied the union and produced the two columns…