Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Bulk Data Type Testing Question
What is the best way to determine if col1 contains a convertible
number?
Bulk collect? Is there a simple SQL function to handle ORA-01722:
invalid number.
Only the values inserted with 2 or -1 will should count.
CREATE TABLE TEST1(COL1 VARCHAR2(4000);
BEGIN
FOR x in 1..1000000
LOOP
INSERT INTO TEST1 SELECT CASE mod(dbms_crypto.randomnumber,3) WHEN 1 THEN 'ABC' WHEN 2 THEN '123' WHEN -1 THEN '100.42' WHEN 0 THEN '444.4a' -- NULL -- to_char(dbms_crypto.randomnumber) ELSE 'BJORK' END FROM DUAL;
![]() |
![]() |