Moore,
Thanks for quick reply.
I did not explain clearly at the first place. My issue is with sql loader. I
need to ignore Alpha Numeric values in a particular column when we are
loading to table using sql loader. I tried like below in red but WHEN will
not allow any function :(
load data
into table t_contr_daily_raj
when nvl(LENGTH(TRIM(TRANSLATE(PRODUCT_PRICE_CD, ' +-.0123456789',' '))), 0)
=0
truncate
(
CONTR_ACCT_ID Position( 1:12 ),
CONTR_ID Position( 13:22 ),
BUS_PRTNR_ID Position( 23:32 ),
RESID_CML_IND Position( 33:33 ),
DWELL_TY Position( 34:34 ),
CONTR_STAT Position( 35:36 ),
CONTR_DESC Position( 37:71 ),
CO_CD Position( 72:75 ),
SRVC_ADDR_LN_1 Position( 76:125 ),
SRVC_ADDR_LN_2 Position( 126:150 ),
SRVC_ADDR_CTY Position( 151:180 ),
SRVC_ADDR_ST Position( 181:182 ),
On Thu, May 5, 2011 at 2:14 PM, Michael Moore <michaeljmo...@gmail.com>wrote:
> DECLARE
> myvar VARCHAR2 (30) := 'abc123';
> mynum PLS_INTEGER;
> BEGIN
> BEGIN
> mynum := myvar;
> EXCEPTION
> WHEN VALUE_ERROR
> THEN
> DBMS_OUTPUT.put_line (' myvar is not numeric: ' || myvar);
> END;
> END;
>
> Mike
>
>
>
> On Thu, May 5, 2011 at 11:57 AM, swaroop gowda <swaroop.t...@gmail.com>wrote:
>
>> Hi All,
>>
>> Any one knows how to check the string has numeric?
>>
>> Please let me know.
>>
>> --
>> Thanks & Regards
>> Swaroop Thailuru Swamy
>> Ph: 713-392-1571
>>
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Oracle PL/SQL" group.
>> To post to this group, send email to Oracle-PLSQL@googlegroups.com
>> To unsubscribe from this group, send email to
>> oracle-plsql-unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/Oracle-PLSQL?hl=en
>>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
Thanks & Regards
Swaroop Thailuru Swamy
Ph: 713-392-1571
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
