Question: Question 21 ssume that you have a product code that has the following format XOOXXNNN here X is a character and N is a digit.

Question 21 ssume that you have a product code that has the following format XOOXXNNN here 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 hile the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero). Tite a PLUSQL program to separate the code into its two parts as shown in the following example: if the ing e output should be: oduct Name is: ABC ial Number is: 031 ts: Use the following functions if needed: instre string1, string2 [ start_position [, nth_appearance]]) substr(string, start_position. [ length ]) length( string) DBMS_OUTPUT.PUT_LINE() Ee the editor to format your answer maining
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
