Chapter 8, Problem 6RQ

Explanation of Solution

“RTRIM” function:

• The “RTRIM” function is used to remove the additional spaces at the end of a value.
  • The “RTRIM” means right trim which is used to remove any additional spaces inserted at the end of the value.

Example:

The Example for “RTRIM” function is given below:

SELECT STUDENT_ID, RTRIM(FIRST_NAME)||''||RTRIM(LAST_NAME) AS STUDENT_NAME FROM STUDENT;

• The above query is used to display the stu...