Suppose you have a query result and want to concatenate a string to that output for better readibility, it can be done using the Concat operator in SQL*PLUS
Select Name, Size from Table ;
EMV_DATA 23 LOG_RECORD_HIST 6 EMVX 5 CARDHOLDER_TRAN 4 EJ_LOG 3 ISO_MSG 3 CARD_TRAN_IDX2 2 ACCT_IX 2 CARD_TRAN_IDX 2
Now if you want to add a string “GB” at the end of the result set of second column the SQL statement will be as below
Select Name, Size || ‘ GB’ from Table;
EMV_DATA 23 GB LOG_RECORD_HIST 6 GB EMVX 5 GB CARDHOLDER_TRAN 4 GB EJ_LOG 3 GB ISO_MSG 3 GB CARD_TRAN_IDX2 2 GB ACCT_IX 2 GB CARD_TRAN_IDX 2 GB
