SCENARIO: We have table EMPLOYEE_INFO which contains Employee information. We want the output table should display NAME field and it should contain EMPNAME field values leaving behind first and last character in it. Please see below in details.
TABLE NAME: EMPLOYEE_INFO
 |
| EMPLOYEE_INFO Table |
