存储过程is as-存储过程is as文档介绍内容-阿里云

alicloud_security_group_rule

Provides a security group rule resource.Represents a single ingress or egress group rule,which can be added to external Security Groups.->NOTE:nic_type should set to intranet when security group type is vpc or specifying ...

alicloud_ecs_invocation

Period,NextRebootOnly,EveryReboot.Default value:When timed is set to false and Frequency is not specified,the default value of repeat_mode is Once.When Timed is set to true and Frequency is specified,period is used as the ...

alicloud_config_rule

Provides a Config Rule resource.For information about Config Rule and how to use it,see What is Rule.->NOTE:Available since v1.204.0.Example Usage Basic Usage data"alicloud_resource_manager_resource_groups""default"{ ...

产品计费

其他费用在使用云存储网关过程中，除了云存储网关收费的计费项之外，还有其他费用支出。OSS使用费用云存储网关中的OSS资源归您所有，网关访问OSS产生的费用由OSS产品向您收取，这些费用包括存储费用、流量费用、请求费用和数据取回费用，...

alicloud_vod_domain

id-The resource ID in terraform of Domain.Its value is same as domain_name.domain_name-The domain name for CDN.description-The description of the domain name for CDN.cert_name-The name of the certificate.The value of this ...

AttachDisk-为实例挂载数据盘或系统盘

400 InvalidDisk.DiskNotBootable The specified disk is not a bootable disk,can not be attached as system disk.-400 InvalidInstance.NotOriginInstance The specified disk can not attached to other instance as system disk.-400 ...

alicloud_alb_server_groups

the health check state is changed from success to fail.Valid values:2 to 10.Default value:3.health_check_codes-The status code for a successful health check.Multiple status codes can be specified as a list.Valid values:...

ALIYUN:IOT:Product

specify the product is classified as a resource group.If this parameter is passed,the product will be classified as a default resource group."},"DataFormat":{"Type":"Number","Description":"You must specify this parameter ...

alicloud_ehpc_cluster

Provides a Ehpc Cluster resource.For information about Ehpc Cluster and how to use it,see What is Cluster.->NOTE:Available since v1.173.0.Example Usage Basic Usage variable"name"{ default="tf-example"} data"alicloud_zones...

存储过程

您在使用存储过程时，可以指定存储过程的名字并使用参数（parameters），并在合适的时候调用存储过程实现相同或者不同的业务。本文将介绍存储过程的使用方法。背景信息 AnalyticDB PostgreSQL 6.0版中，函数（Function）虽然可以实现大...

alicloud_db_backup_policy

interval-(Optional,Available since v1.194.0)The frequency at which you want to perform a snapshot backup on the instance.Valid values:1:No backup frequencies are specified.30:A snapshot backup is performed once every 30 ...

alicloud_cs_kubernetes_node_pool

Provides a ACK Nodepool resource.This resource will help you to manage node pool in Kubernetes Cluster,see What is kubernetes node pool.->NOTE:Available since v1.97.0.->NOTE:From version 1.109.1,support managed node pools,...

RenewInstance-续费一台包年包月ECS实例

403 InstanceLockedForSecurity The specified operation is denied as your instance is locked for security reasons.实例被安全锁定。403 InvalidDisk.NotAllowed The specified disk is not allowed to be converted to portable.指定...

UDF（地理空间）

说明在使用过程中，如果您有任何问题，请直接在GitHub上提交issues获取帮助。步骤一：准备本地函数准备本地函数有如下两种方法：下载源代码后编译为JAR包获取地理空间UDF代码的URL下载链接。打开Git命令行工具，下载2.1.0版本Hive...

alicloud_polardb_cluster

Provides an PolarDB cluster resource.An PolarDB cluster is an isolated database environment in the cloud.An PolarDB cluster can contain multiple user-created databases.->NOTE:Available since v1.66.0.Example Usage Create a ...

更新实例配置

32 smallProportion:0.5#The segment is considered as"small segment"when its#of rows is smaller than#(smallProportion*segment max#of rows).#A compaction will happen on small segments if the segment after compaction will have...

ReplaceSystemDisk-更换操作系统

403 InstanceExpiredOrInArrears The specified operation is denied as your prepay instance is expired(prepay mode)or in arrears(afterpay mode).实例已过期或者欠费，请您续费或者结清后再进行操作。403 ChargeTypeViolation The ...

alicloud_rds_clone_db_instance

Provides an RDS Clone DB Instance resource.For information about RDS Clone DB Instance and how to use it,see What is ApsaraDB for RDS.->NOTE:Available since v1.149.0+.Example Usage Create an RDS MySQL clone instance data...

alicloud_cen_route_map

known mandatory attribute,which describes the numbers of the ASs that a BGP route passes through during transmission.as_path_match_mode-(Optional)A match statement.It indicates the mode in which the AS path attribute is ...

alicloud_vpc_bgp_groups

the BGP neighbor is considered disconnected.id-The ID of the Bgp Group.ip_version-IP version.is_fake_asn-Whether the AS number is false.keepalive-The keepalive time.local_asn-The local AS number.peer_asn-The autonomous ...

CREATE PROCEDURE

AUTHID CURRENT_USER|PARALLEL { UNSAFE|RESTRICTED|SAFE }|COST execution_cost|ROWS result_rows|SET configuration_parameter { TO value|=value|FROM CURRENT }.]{ IS|AS }[PRAGMA AUTONOMOUS_TRANSACTION;[declarations]BEGIN ...

创建存储过程

存储过程是作为单个 SPL 程序语句调用的独立 SPL 程序。调用时，存储过程可选择以输入参数的形式从调用方接收值，并可选择以输出参数的形式向调用方返回值。CREATE PROCEDURE 命令可定义并命名一个将存储在数据库中的独立存储过程。如果...

DBMS_ALERT

SIGNAL Procedure 该存储过程用于产生一条指定名称的告警语法 DBMS_ALERT.SIGNAL(event IN VARCHAR2,message IN VARCHAR2);参数说明参数说明 event 发送消息的告警的名称。message 告警的具体消息。示例该示例展示了如何发送一个告警...

新建存储过程

概述 存储过程是一条或多条语句的集合，对数据库进行一系列复杂操作时，存储过程可以在数据库内将这类复杂操作封装成一个代码块，以便重复使用，从而减少数据库开发人员的工作量。存储过程旨在完成特定功能的 SQL 语句集，经编译创建并保存...

alicloud_actiontrail_trails

Disable,Enable,Fresh.ids-(Optional)A list of ActionTrail Trail IDs.It is the same as trail name.output_file-(Optional)File name where to save data source results(after running terraform plan).Attributes Reference The ...

alicloud_datahub_project

The project is the basic unit of resource management in Datahub Service and is used to isolate and control resources.It contains a set of Topics.You can manage the datahub sources of an application by using projects.Refer ...

创建子存储过程

PROCEDURE name[(parameters)]{ IS|AS }[PRAGMA AUTONOMOUS_TRANSACTION;[declarations]BEGIN statements END[name];参数参数说明 name name是子存储过程的标识符。parameters parameters是形参的列表。PRAGMA AUTONOMOUS_TRANSACTION ...

alicloud_datahub_subscription

The subscription is the basic unit of resource usage in Datahub Service under Publish/Subscribe model.You can manage the relationships between user and topics by using subscriptions.Refer to details.->NOTE:Available since ...

Dataphin即席查询报错“Metering data exceed max ...

PROVIDER,BUSINESS_PLAN_ID AS BUSINESS_PLAN_ID,MESSAGE_LENGTH AS MESSAGE_LENGTH,ddBankCard(MESSAGE_ID)AS MESSAGE_ID,IS_POLL AS IS_POLL,ddSelfMask(COST,'1,0')AS COST,HAS_URL_FLAG AS HAS_URL_FLAG,ddSelfMask(UPD_BY,'1,0')AS ...

alicloud_datahub_topic

The topic is the basic unit of Datahub data source and is used to define one kind of data or stream.It contains a set of subscriptions.You can manage the datahub source of an application by using topics.Refer to details.->...

CreateDataFlow-创建数据流动

创建一个CPFS文件系统与源端存储的数据流动。接口说明基础操作文件存储 CPFS 2.2.0 及以上版本、智算 CPFS 2.4.0 及以上版本支持数据流动。文件存储 CPFS、CPFS 智算版状态为运行中，才能创建数据流动。一个文件存储 CPFS 或者 CPFS 智算...

常用操作及兼容性说明

存储过程 创建存储过程 USE testdb GO CREATE PROC dbo.UP_getDemoData(@id int)AS BEGIN SET NOCOUNT ON SELECT*FROM dbo.tb_test WHERE id=id END;GO 查看存储过程 SELECT*FROM sys.procedures WHERE name='up_getdemodata';执行存储过程...