Question: please answer this as fast as possible QUESTION 1 5 points Save Answer Assume that you have a product code that has the following format:

please answer this as fast as possible
QUESTION 1 5 points Save Answer 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()
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
