数据仓库服务 GAUSSDB(DWS)-BEGIN:语法格式

时间:2024-01-26 16:15:20

语法格式

  • 开启匿名块
    1
    2
    3
    4
    5
    [DECLARE [declare_statements]] 
    BEGIN
    execution_statements  
    END;
    /
    
  • 开启事务
    1
    2
    3
    4
    5
    6
    7
    BEGIN [ WORK | TRANSACTION ]
      [ 
        { 
           ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE | REPEATABLE READ }
           | { READ WRITE | READ ONLY }
          } [, ...] 
      ];
    
support.huaweicloud.com/sqlreference-820-dws/dws_06_0257.html