It's under your control.

*UNION Operator * UNION ALL Operator * INTERSECT Operator* MINUS Operator SQL> select * from a; ID ---------- 1 2 3 SQL> select * from b; ID ---------- 3 4 5 SQL> select id from a union all select id from b; ID ---------- 1 2 3 3 4 5 SQL> select id from a unionselect id from b; ID ---------- 1 2 3 4 5 SQL> select id from a intersectselect id from b; ID ---------- 3 SQL> select id from a minussel..

*databases select Sorting lll. Using Sigle-Row Functions to Customize Output * Character Functions (continued)FunctionPurposeLOWER(column|expression )Converts alpha character values to lowercaseUPPER(column|expression )Converts alpha character values to uppercaseINITCAP(column|expression )Converts alpha character values to uppercase for the firstletter of each word; all other letters in lowercas..