数据仓库服务 GAUSSDB(DWS)-Teradata格式:类型转换时优先执行数据库操作

时间：2024-12-10 11:28:49

类型转换时优先执行数据库操作

输入

输出

       
            REPLACE VIEW SC.VIEW_1 
 ( 
 col_1 
 ) 
 LOCKING TABLE sc.tab FOR AC CES S 
 AS 
 SEL 
 (COALESCE(TRIM(TGT.col_1),'')) || '_' || (COALESCE(TRIM(TGT.col_1),'')) (CHAR(22)) AS col_1 
 FROM 
 sc.tab TGT 
 ;

       
            CREATE 
      OR REPLACE VIEW SC.VIEW_1 (col_1)  
     /*LOCKING TABLE sc.tab FOR ACCESS */ 
      AS ( 
           SELECT 
                    CAST(  
                     ( COALESCE( TRIM( TGT.col_1 ) ,'' ) ) || '_' || ( COALESCE( TRIM( TGT.col_1 ) ,'' ) ) 
                    AS CHAR( 22 ) ) AS col_1 
                FROM 
                     sc.tab TGT 
      ) ;