Wednesday 14 March 2012

Oracle apps (Conversions)To remove last column spaces ( conversions )from staging table

----UPDATE THE LAST COUMN BY USING FOLLOWING STATEMENT----

Update INVOICE_HEADERS_STG90
set VENDOR_SITE_CODE = replace (VENDOR_SITE_CODE, CHR (13)) 
where VENDOR_SITE_CODE  like '%' || CHR (13) || '%';

No comments:

Post a Comment