combine fields to make new field sql

Question

I have these three fields that I'd like to combine to make one new one:

DEPT  CRS  SC
-------------
BIO   101  A
BIO   101  B
BIO   105  A
CHEM  101  A

Preferred output:

NEW
-------------
BIO 101A
BIO 101B
BIO 105A
CHEM 101A

I have a feeling I would use NVL()?

Answer 1

Try this: select DEPT||" "||CRS||SC as new from table