Can someone help me, I have this function in Oracle...I never created
it, but I need to use it to format the text in a text box, I have no
clue. tnx
CREATE OR REPLACE FUNCTION TRAFFIC.GET_FORMATTED_CAR_NUMBER
(orig_car_num IN VARCHAR2) RETURN VARCHAR2 IS
cntr_1 NUMBER := 1;
cntr_2 NUMBER := 0;
new_car_num VARCHAR2(10);
car_num_alpha VARCHAR2(4);
car_num_digit VARCHAR2(6);
hold_char VARCHAR2(1);
BEGIN
While cntr_1 <= 4
LOOP
hold_char := substr(orig_car_num, cntr_1, 1);
IF ASCII(hold_char) >= 65 and ASCII(hold_char) <= 90 THEN
car_num_alpha := car_num_alpha || hold_char;
END IF;
cntr_1 := cntr_1 + 1;
END LOOP;
car_num_alpha := RPAD(car_num_alpha, 4, ' ');
cntr_1 := 1;
WHILE cntr_1 <= length(orig_car_num)
LOOP
hold_char := substr(orig_car_num, cntr_1, 1);
IF ASCII(hold_char) >= 48 and ASCII(hold_char) <= 57 THEN
car_num_digit := car_num_digit || hold_char;
END IF;
cntr_1 := cntr_1 + 1;
END LOOP;
car_num_digit := LPAD(car_num_digit, 6, '0');
new_car_num := car_num_alpha || car_num_digit;
RETURN new_car_num;
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END GET_FORMATTED_CAR_NUMBER;
/
