Chapter 9, Problem 5EYK

Assume that you have a product code that has the following format: XXXXNNN  Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero).     Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be:    Product Name is: ABC  Serial Number is: 031    Hints: Use the following functions if needed:  instr( string1, string2 [, start_position [, nth_appearance ] ] )  substr( string, start_position, [ length ] )  length( string )  DBMS_OUTPUT.PUT_LINE( )

10 If the Year of Hire is 2003, insert the value from cell M2, If the Year of Hire is 1996, insert the value from cell M3, If the Year of Hire is 1984 insert the value from cell M4, otherwise insert the value from cell M5. (Use absolute cell referencing where necessary).

Interval Selection: Please help me with this TypeError