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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!