Oracle concatenates values of different columns into a string

Oracle concatenates values of different columns into a string [SQL] -- using the concatenation operator "|" or CONCAT, concatenate values of different columns into a string -- Method 1: select s. TEAM | '**' | S. NAME | '**' | S. JOB_NUMBER from staff s where s. PASS = '000000' and s. TEAM = 'south' -- Method 2: tedious. Select concat (S. TEAM, '**'), S. NAME), '**'), S. JOB_NUMBER) from staff s where s. PASS = '000000' and s. TEAM = 'south' -- the results are the same in the south as follows: ** Chen moumou ** 110320 South ** Peng moumou ** 119008 South ** Huang moumou ** 119083