This is a PL/SQL forum, you might get a faster reply by asking your question
on the oracle-l list.
Regards,
Mike
On Thu, May 5, 2011 at 12:24 PM, swaroop gowda <swaroop.t...@gmail.com>wrote:
> 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
>
--
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
