alicloud_ess_scaling_group
ECS,NONE.Default to ECS.tags-(Optional,Available since v1.160.0)A mapping of tags to assign to the resource.Key:It can be up to 64 characters in length.It cannot begin with"aliyun","acs:","http://",or"https://". It cannot ...
使用说明
WHILE begin<=end DO SET@ID1=begin;SET@NAME=CONCAT(begin+begin*281313,'@stiven');SET@TIME=from_days(begin+737600);EXECUTE stmt using@ID1,@NAME,@TIME;SET begin=begin+1;END WHILE;END;delimiter;CALL proc_batch_insert(1,3000,'...
创建子函数
statements statements 是 SPL 程序语句（BEGIN-END 块可以包含 EXCEPTION 部分）。示例 以下示例显示如何使用递归子函数：DECLARE FUNCTION factorial(n BINARY_INTEGER)RETURN BINARY_INTEGER IS BEGIN IF n=1 THEN RETURN n;ELSE RETURN...
alicloud_db_readonly_instance
true:delete protect.false:no delete protect.tags-(Optional,Available since v1.68.0)A mapping of tags to assign to the resource.Key:It can be up to 64 characters in length.It cannot begin with"aliyun",acs:","http://",or...
alicloud_ess_scaling_configuration
ess_attachment replaces it.tags-(Optional)A mapping of tags to assign to the resource.It will be applied for ECS instances finally.Key:It can be up to 64 characters in length.It cannot begin with"aliyun",http://",or...
局部程序
只声明，未定义 BEGIN END;结果显示如下：ERROR:subroutine body must be defined for forward-declared function"func_test"以下示例展示如何正确使用前向声明。DECLARE PROCEDURE proc1(number1 NUMBER);前向声明 proc1 PROCEDURE proc2...
alicloud_ess_eci_scaling_configuration
It can be up to 64 characters in length.It cannot begin with"aliyun","http://",or"https://". It cannot be a null string.Value:It can be up to 128 characters in length.It cannot begin with"aliyun","http://",or...
alicloud_network_interface
DEPRECATED:This resource has...and must not begin with http:// or https://. Default value is null. description - (Optional)Description of the ENI.This description can have a string of 2 to 256 characters,It cannot begin with ...
alicloud_eip
It cannot begin with http:// or https://. Default value is null. bandwidth - (Optional)Maximum bandwidth to the elastic public network,measured in Mbps(Mega bit per second).If this value is not specified,then automatically...
存储过程
PL/pgSQL-SQL 过程语言 PL/pgSQL 是 AnalyticDB PostgreSQL版 数据库系统的一个默认安装的过程语言，易于使用。PL/pgSQL 的设计目标是创建一种可加载的过程语言，可以：用于创建函数和触发器过程；为 SQL 语言增加控制结构；执行复杂的计算...
集合类型构造函数
BEGIN END;结果显示如下：ERROR:function varray_type(integer,integer,integer)does not exist LINE 1:varray_type(1,2,3)^HINT:No function matches the given name and argument types.You might need to add explicit type casts.QUERY...
alicloud_adb_db_cluster
It can be up to 64 characters in length.It cannot begin with"aliyun","acs:","http://",or"https://". It cannot be a null string.Value:It can be up to 128 characters in length.It cannot begin with"aliyun","acs:","http://",or...
SET TRANSACTION
可以通过在 BEGIN 或者 START TRANSACTION 中指定想要的 transaction_modes 来省掉 SET TRANSACTION。但是在 SET TRANSACTION SNAPSHOT 中该选项不可用。会话默认的事务模式也可以通过设置配置参数 default_transaction_isolation、default...
alicloud_launch_template
ssd,please don't set this param.Default to true description-(Optional)The description of the data disk.tags-(Optional)A mapping of tags to assign to the resource.Key:It can be up to 64 characters in length.It cannot begin ...
集合变量的赋值
本文介绍了为集合变量赋值的方式。...赋值为 NULL BEGIN END;显示结果如下：ERROR:can not assign NULL to associative array CONTEXT:PL/SQL function inline_code_block line 4 during statement block local variable initialization
CreateRouteEntry-创建自定义路由条目
400 InvalidRouterType Cannot specify nexthop list in vbr's route table.-400 IncorrectHaVipStatus This operation is denied because satus of the specified HaVip is neither Available nor InUse.无法执行该操作，因为HaVip的状态...
CreateRouteEntry-创建自定义路由条目
400 InvalidRouterType Cannot specify nexthop list in vbr's route table.-400 IncorrectHaVipStatus This operation is denied because satus of the specified HaVip is neither Available nor InUse.无法执行该操作，因为HaVip的状态...
子类型
显示结果如下：NOTICE:var=1 ERROR:null value cannot be assigned to variable"var"declared NOT NULL CONTEXT:PL/SQL function inline_code_block line 5 at assignment 隐式类型转换 DECLARE SUBTYPE subtype_int IS INT;SUBTYPE ...
DELETE
结果显示如下：ERROR:cannot access deleted element CONTEXT:PL/SQL function inline_code_block line 6 at RAISE 以下是一个嵌套表删除元素后，重新赋值给该位置的示例。DECLARE TYPE nt_type IS TABLE OF INT;nt nt_type:=nt_type(1,2);...
alicloud_rds_account
db_instance.default.id account_name=var.name account_password="Example1234"} Argument Reference The following arguments are supported:account_description-(Optional)Database description.It cannot begin with ...
事务管理
示例：使用可序列化（SERIALIZABLE）隔离级别开始事务块：BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;BEGIN;SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;AnalyticDB PostgreSQL版 提供了下列事务管理相关的SQL命令：BEGIN或者...
声明
CREATE FUNCTION concat_selected_fields(in_t sometablename)RETURN text IS BEGIN RETURN in_t.f1|in_t.f3|in_t.f5|in_t.f7;END;当一个PL/SQL函数被声明为带有输出参数，输出参数可以用普通输入参数相同的方式被给定$``n 名称以及可选的...
创建子存储过程
statements statements是SPL程序语句（BEGIN-END块可以包含EXCEPTION部分）。示例 以下示例是匿名块中的一个子存储过程。DECLARE PROCEDURE list_emp IS v_empno NUMBER(4);v_ename VARCHAR2(10);CURSOR emp_cur IS SELECT empno,ename ...
游标
语法是：[<<label>>]FOR recordvar IN bound_cursorvar[([argument_name:=]argument_value[,.])]LOOP statements END LOOP[label];该游标变量必须在声明时已经被绑定到某个查询，并且它 不能 已经被打开。FOR 语句会自动打开游标，并且在...
特殊用法
BEGIN FORALL i IN nt.first.nt.last UPDATE test_backup SET ROW=nt(i)WHERE id=nt(i).id;END;SELECT*FROM test_backup;结果显示如下：id|name-+-1|c 2|d(2 rows)BULK COLLECT INTO BULK COLLECT INTO 的使用场景与 INTO 类似，区别在于 ...
alicloud_rds_clone_db_instance
essd:enhanced SSDs(ESSDs)of performance level 1(PL1)cloud_essd2:ESSDs of PL2 cloud_essd3:ESSDs of PL3 payment_type-(Required)The billing method of the new instance.Valid values:PayAsYouGo and Subscription and Serverless.db...
alicloud_nat_gateway
Provides a resource to ...and must not begin with http:// or https://. Defaults to null. description - (Optional)Description of the nat gateway,This description can have a string of 2 to 256 characters,It cannot begin with ...
分布式事务问题
数据访问代理是否支持分布式事务 数据访问代理支持与分布式事务的...在数据访问代理 V2.9.5 之前的版本中，如果事务中存在跨数据库的 SQL，数据访问代理将会返回错误 ERROR 7031:Cannot execute update SQLs cross databases in transaction。
Tablestore数据源
当配置的 begin、end 数量小于主键数量时，依据 最左主键匹配原则，未配置的主键范围默认为[INF_MIN，INF_MAX）。当只配置了 begin、end 中的一项时，导出的数据范围为[begin,INF_MAX）或[INF_MIN,end）。当仅有一个主键列时，begin、end ...
附录：消息格式
INSERT/UPDATE_BEFOR/UPDATE_AFTER/DELETE/TRANSACTION_BEGIN/TRANSACTION_END/CREATE/ALTER/ERASE/QUERY/TRUNCATE/RENAME/CINDEX/DINDEX/GTID/XACOMMIT/XAROLLBACK/MHEARTBEAT.",/大小写敏感,"timestamp":{"eventTime":1,/必选，记录源端...
alicloud_elasticsearch_instance
(Optional,Available since v1.73.0)A mapping of tags to assign to the resource.key:It can be up to 128 characters in length.It cannot begin with"aliyun","acs:".It cannot contain"http://" and "https://". It cannot be a null ...
alicloud_ecs_instance_set
It cannot begin with http:// or https:// . security_group_ids - (Required,ForceNew)A list of security group ids to associate with.image_id-(Required,ForceNew)The Image to use for the instance.instance_type-(Required,...
控制结构
PL/SQL有三种形式的 IF：IF.THEN.END IF IF.THEN.ELSE.END IF IF.THEN.ELSIF.THEN.ELSE.END IF 以及两种形式的 CASE：CASE.WHEN.THEN.ELSE.END CASE CASE WHEN.THEN.ELSE.END CASE IF-THEN IF boolean-expression THEN statements END IF;...
记录变量
方式3 BEGIN.END;在PL/SQL块中定义的记录类型是局部类型。它仅在块中可用，对外部不可见。当记录类型在包中被声明时，它才存储在数据库中。此时，您可以通过以下语法使用：CREATE PACKAGE pkg AS TYPE r_type IS RECORD(id INT,name ...
错误代码
x ERROR 7031:Cannot execute update SQLs cross databases in transaction ERROR 7100:Getting next sequence error,xx ERROR 1003:Transaction error,need to rollback ERROR:Server connection execute error:x ERROR:Access denied for...
对象类型组成部分
其中constructor的语法如下：CONSTRUCTOR func_name[([SELF[IN|IN OUT]name][,parm1[IN|IN OUT|OUT]datatype1[DEFAULT value1]][,parm2[IN|IN OUT|OUT]datatype2[DEFAULT value2]].)]RETURN self AS RESULT { IS|AS }[declarations]BEGIN ...
包正文
请注意，DECLARE-BEGIN-END 块被视为 SPL 语句本身。因此，函数正文可以包含嵌套块。exception 异常条件名称，如 NO_DATA_FOUND、OTHERS 等。func_name 要创建的函数的名称。rettype 返回数据类型，可以是为 argtype 列出的任意类型。对于 ...
CREATE FUNCTION
statements SPL程序语句（BEGIN-END 块可以包含 EXCEPTION 部分）。IMMUTABLE/STABLE/VOLATILE 这些属性将函数的行为通知给查询优化器；您只能指定一个选项。VOLATILE 是默认行为。IMMUTABLE 指示函数不能修改数据库，并在提供相同参数值时...
CREATE PROCEDURE
statements statements 是 SPL 程序语句（BEGIN-END 块可以包含 EXCEPTION 部分）。IMMUTABLE|STABLE|VOLATILE 这些属性将存储过程的行为通知给查询优化器；您只能指定一个选项。VOLATILE 是默认行为。IMMUTABLE 指示存储过程不能修改数据...
查看活跃Query
idle in transaction(aborted)：表示进程处于一个事务中，该事务存在语句错误，并且进程当前没有执行查询操作。fastpath function call：表示进程正在执行一个 fast-path 函数。disabled：表示进程的 track activities 被禁用。单击 查询。...
- 产品推荐
- 这些文档可能帮助您