ClassMethodListFunction(){&sql(SELECTLIST(Home_State)INTO:statelistFROMSample.PersonWHEREHome_State%STARTSWITH'A')w"The states are:",!,statelist} 代码语言:javascript 代码运行次数:0 运行 AI代码解释 DHC-APP>d ##class(PHA.TEST.SQLCommand).ListFunction()The states are:AR,AL,AZ,AZ,AZ,AR,AL,...
&sql(SELECT LIST(DISTINCT Home_State) INTO :statelist FROM Sample.Person WHERE Home_State %STARTSWITH 'A') w "The distinct states are:",!,statelist } DHC-APP> d ##class(PHA.TEST.SQLCommand).ListFunction1() The distinct states are: AR,AL,AZ 下面的SQL示例为每个州创建了一个逗号分隔的...
第八十章 SQL函数 $LIST(二) 示例 在以下嵌入式 SQL 示例中,两个 WRITE 语句都返回“Red”,即列表中的第一个元素。第一个默认写入第一个元素,第二个写入第一个元素,因为位置参数设置为 1: /// d ##class(PHA.TEST.SQLFunction).Li4() ClassMethod Li4() { s a = $lb("Red", "Blue", "Green...
ClassMethod ListFunction() { &sql(SELECT LIST(Home_State) INTO :statelist FROM Sample.Person WHERE Home_State %STARTSWITH 'A') w "The states are:",!,statelist } 1. 2. 3. 4. 5. 6. 7. 8. AI检测代码解析 DHC-APP>d ##class(PHA.TEST.SQLCommand).ListFunction() The states are: A...
value public List value() Get the value property: List of userDefinedFunctions and their properties. Returns: the value value.Applies to Azure SDK for Java Latest在GitHub 上與我們共同作業 您可以在 GitHub 上找到此內容的來源,在其中建立和檢閱問題和提取要求。 如需詳細資訊,請參閱我們的...
TYPE t_type_refISTABLEOFtype_ref;FUNCTIONretrieve(v_namevarchar2)RETURNt_type_ref PIPELINED;ENDtest_141215;--PACKAGE BODYCREATEORREPLACEPACKAGE BODY test_141215ISFUNCTIONretrieve(v_namevarchar2)RETURNt_type_ref PIPELINEDIScur_type_ref type_ref; ...
(i_in_char clob,i_split varchar2) return base_type_library_pkg.ba_tab_type pipelined; endget_split_table_pkg; / create orreplace package body get_split_table_pkg is function fn_get_split_table(i_in_char clob,i_split varchar2) return base_type_library_pkg.ba_tab_type pipelined is v...
PARTITION FUNCTION PARTITION SCHEME PROCEDURE QUEUE REMOTE SERVICE BINDING RESOURCE POOL ROLE ROUTE 规则 SCHEMA SEARCH PROPERTY LIST SECURITY POLICY SELECTIVE XML INDEX SEQUENCE SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER ROLE SERVICE SPATIAL INDEX STATISTICS SYMMETRIC KEY SYNONYM TABLE 表(SQL 图) TABLE ...
CREATE PROCEDURE lake_list ( @region varchar(30), @size integer, @lake_list_cursor CURSOR VARYING OUTPUT ) AS BEGIN DECLARE @ok SMALLINT EXECUTE check_authority @region, username, @ok OUTPUT IF @ok = 1 BEGIN SET @lake_list_cursor =CURSOR LOCAL SCROLL FOR ...
PARTITION FUNCTION PARTITION SCHEME PROCEDURE QUEUE REMOTE SERVICE BINDING RESOURCE POOL ROLE ROUTE 规则 SCHEMA SEARCH PROPERTY LIST SECURITY POLICY SELECTIVE XML INDEX SEQUENCE SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER ROLE SERVICE SPATIAL INDEX STATISTICS SYMMETRIC KEY SYNONYM TABLE 表(SQL 图) TABLE ...