#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order toget theSUBSTR function that returns the job_id = =E2=80=98REP'.

Answer

SELECT JOB_ID FROM EMPLOYEESWHERE SUBSTR(JOB_ID,4)='REP';