函数返回数据集合例子

最新推荐文章于 2023-06-23 15:55:20 发布
最新推荐文章于 2023-06-23 15:55:20 发布
阅读量124 收藏
点赞数
分类专栏： 数据库 文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/thomas0104/article/details/84159227
版权
CREATE OR REPLACE TYPE ictpm.objemp AS OBJECT (
menuId VARCHAR2(200 CHAR),--节点id
menuCount NUMBER(4) --节点数
);
/


CREATE OR REPLACE TYPE ictpm.tabemp AS TABLE OF ictpm.objemp;
/


CREATE OR REPLACE FUNCTION ictpm.F_O_GET_FIRSTPAGE_COUNT(USERID VARCHAR2)
RETURN ictpm.tabemp PIPELINED
IS
/******************************************************************************
NAME: 查询ICT首页待处理任务总数函数
PURPOSE: 减少访问数据库次数，提高查询性能

REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2012-02-16 wangsongtao 1. ICT项目管理系统

NOTES:
userId：用户row_id

******************************************************************************/
TOTALCOUNT NUMBER := 0;--总数
TEMPNUMBER NUMBER;--临时数
WORKUNITID VARCHAR2(20 CHAR);--用户所属单位
WORKUNITKIND VARCHAR2(30 CHAR); --用户单位类别
USERNAME VARCHAR2(30 CHAR); --用户名称
v objemp; --返回结果集
CURSOR funcList IS (SELECT T.WEB_PAGE --权限集合
FROM TH_FUNCTION T, TH_USER_ROLE_REL UR, TH_ROLE_FUNC_REL RF
WHERE T.ROW_ID = RF.FUNC_ID
AND RF.ROLE_ID = UR.ROLE_ID
AND UR.USER_ID = userId
UNION
SELECT T.WEB_PAGE
FROM TH_FUNCTION T, TH_USER_FUNC_REL UF
WHERE UF.USER_ID = userId
AND T.ROW_ID = UF.FUNC_ID);
BEGIN
SELECT USR.WORK_UNIT_ID,USR.WORK_UNIT_KIND,USR.USER_NAME --获取用户所属单位
INTO WORKUNITID,WORKUNITKIND,USERNAME
FROM TH_USER USR
WHERE USR.ROW_ID = userId;
--遍历所有用户权限
FOR ROWVAL IN FUNCLIST LOOP
IF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_amend.action'
THEN --需我送审的项目
SELECT COUNT(1) INTO TEMPNUMBER
FROM ICTPM_PROJECTINFO T
WHERE T.STATE = '0' AND T.INPUTPEOPLE = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqModifyPro',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_audit.action'
THEN --需我审核的项目
SELECT COUNT(1) INTO TEMPNUMBER
FROM ICTPM_PROJECTINFO T
WHERE T.STATE = '1' AND T.PROJECTMANAGER = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditPro',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_submit.action'
THEN --需我提交的协调任务单
SELECT COUNT(1) INTO TEMPNUMBER
FROM ICTPM_WORKORDER ER
WHERE ER.STATE = '0' AND ER.INPUTPEOPLE = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSubmitWorkOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_distribute.action'
THEN --需我派发的协调任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_WORKORDER ER
WHERE EXISTS (SELECT 1
FROM ICTPM_PROJECTINFO INFO
WHERE ER.PROJECTID = INFO.ID
AND ER.STATE = '1'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSendWorkOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_feedback.action'
THEN --需我反馈的协调任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_WORKORDER ER
WHERE ER.STATE IN ('2','6','7') AND ER.RECEIVEUNITID = WORKUNITID;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedbackWorkOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_feedback_affirm.action'
THEN --需我确认的协调任务单反馈
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_WORKORDER ER
WHERE EXISTS (SELECT 1
FROM ICTPM_PROJECTINFO INFO
WHERE ER.PROJECTID = INFO.ID
AND ER.STATE = '8'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedbackComfirmWorkOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-teamorder_need_submit.action'
THEN --需我提交的团队建设通知单
SELECT COUNT(1) AS TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TEAMORDER T
WHERE T.STATE = '0' AND T.INPUTPEOPLE = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSubmitTeamBuild',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-teamorder_need_distribute.action'
THEN --需我派发的团队建设通知单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TEAMORDER T
WHERE EXISTS (SELECT 1 FROM ICTPM_PROJECTINFO INFO
WHERE INFO.ID = T.PROJECTID AND T.STATE = '1' AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSendTeamBuild',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-teamorder_need_feedback.action'
THEN --需我反馈的团队建设通知单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TEAMORDER T
WHERE T.STATE = '2' AND T.RECEIVERID = WORKUNITID;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedBackTeamBuild',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_minutes_need_submit.action'
THEN --需我提交的会议纪要
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_SETUPMEET T
WHERE T.STATE = '0' AND T.INPUTPEOPLE = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSubmitMeetingContent',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_minutes_need_audit.action'
THEN --需我审核的会议纪要
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_SETUPMEET T
WHERE EXISTS (SELECT 1
FROM ICTPM_PROJECTINFO INFO
WHERE INFO.ID = T.PROJECTID
AND T.STATE = '1'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditMeetingContent',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_audit.action'
THEN --需我审核的实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_PROJECTINFO INFO
WHERE EXISTS (SELECT 1
FROM ICTPM_TASKORDER ER
WHERE INFO.ID = ER.PROJECTID
AND ER.TASKSTATE = '0'
AND INFO.STATE = '2'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_distribute.action'
THEN --需我派发的实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_PROJECTINFO INFO
WHERE EXISTS (SELECT 1
FROM ICTPM_TASKORDER ER
WHERE INFO.ID = ER.PROJECTID
AND ER.TASKSTATE = '1'
AND INFO.STATE = '2'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSendTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_receive.action'
THEN --需我接收的实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TASKORDER ER
WHERE EXISTS (SELECT 1
FROM ICTPM_PROJECTINFO INFO
WHERE INFO.ID = ER.PROJECTID
AND ER.RECEIVEUNITID = WORKUNITID
AND WORKUNITKIND <> '10330001'
AND ER.TASKSTATE IN ('2','5')
AND INFO.STATE = '2'
AND INFO.PROJECTMANAGER = userId);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqReciveTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_distribute_transpond.action'
THEN --需我转派的实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TASKORDER ER
WHERE ER.TASKSTATE IN ('3','4')
AND ER.RECEIVERID = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqTransformTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_feedback.action'
THEN --需我反馈的实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TASKORDER ER
WHERE ER.TASKSTATE IN ('3','6')
AND ER.RECEIVERID = userId;
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedBackTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_taskorder_need_feedback_expire.action'
THEN --需我反馈的到期实施任务单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_TASKORDER T
WHERE T.RECEIVERID = userId
AND T.TASKSTATE IN ('j', 'a', 'b', 'c', 'd', 'e', 'f', 'g')
AND EXISTS (SELECT 1
FROM ICTPM_TASKORDERFEEDBACK TOB
WHERE TOB.TASKID = T.ID
AND TOB.STATE IN ('0', '1', '2'));
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqNotFeedBackTaskOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_problem_need_feedback.action'
THEN --需我反馈的问题
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_PROBLEM P
WHERE EXISTS (SELECT 1
FROM ICTPM_TEAMORDERFEEDBACKDETAIL T
WHERE T.TEAM = P.ACCEPTTEAM
AND P.STATE IN ('0', '1')
AND T.UNITID = WORKUNITID
AND T.NAME = USERNAME);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedBackQuestionDeal',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_problem_need_affirm.action'
THEN --需我确认的问题
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_PROBLEM P
WHERE P.INPUTPEOPLE = userId
AND P.STATE IN ('0','1','2');
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqComfirmQuestionDeal',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_feedbacklist.action'
THEN --需我反馈的催单
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_REMINDORDER T
WHERE T.RECEIVERID = userId
AND T.STATE IN ('2','3');
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqFeedBackReminder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_audit_listExamineChange.action'
THEN --需我审批的验收通知单变更
SELECT COUNT(1) TOTALCOUNT INTO TEMPNUMBER
FROM ICTPM_EXAMINE_CHANGE C
WHERE C.APPROVESTS = '1'
AND EXISTS (SELECT 1 FROM ICTPM_EXAMINE E
WHERE EXISTS (SELECT 1 FROM ICTPM_PROJECTINFO INFO
WHERE INFO.ID = E.PROJECTID
AND INFO.PROJECTMANAGER = userId));
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditCheckInfoChangeOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_audit_listTeamorderfbdChange.action'
THEN --需我审批的项目成员变更
SELECT COUNT(CID) TOTALCOUNT INTO TEMPNUMBER
FROM (SELECT T.ID CID
FROM ICTPM_TEAMORDERFBD_CHANGE T
LEFT JOIN ICTPM_TEAMORDERORGARCHITECTURE X ON X.ID = T.TEAM
LEFT JOIN ICTPM_PROJECTINFO Y ON Y.ID = X.PROJECTID
WHERE T.APPROVESTS = '1'
AND Y.PROJECTMANAGER = userId
UNION
SELECT T.ID CID
FROM ICTPM_TEAMORDERFBD_CHANGE T
LEFT JOIN ICTPM_TEAMORDERORGARCHITECTURE X ON X.ID = T.TEAMNEW
LEFT JOIN ICTPM_PROJECTINFO Y ON Y.ID = X.PROJECTID
WHERE T.APPROVESTS = '1'
AND Y.PROJECTMANAGER = userId
AND T.CREATEORDEL = '2');
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditProMemberChange',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_Projects_meeting.action'
THEN --需我审核的项目协调会
SELECT COUNT(1) TOTAL INTO TEMPNUMBER
FROM ICTPM_CONCERTMEET T
WHERE EXISTS (SELECT 1
FROM ICTPM_PROJECTINFO INFO
WHERE INFO.STATE = '2'
AND INFO.PROJECTMANAGER = userId
AND T.STATE = '1'
AND INFO.ID = T.PROJECTID);
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditProMeeting',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_acceptExamTaskorderList.action'
THEN --需我接收的验收通知单
SELECT COUNT(1) TOTAL INTO TEMPNUMBER
FROM ICTPM_EXAMINE E
WHERE E.RECEIVEPEOPLEID = userId
AND E.STATE = '4';
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqReciveCheckOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_submit_acceptExamTaskorderList.action'
THEN --需我提交的验收通知单
SELECT COUNT(1) TOTAL INTO TEMPNUMBER
FROM ICTPM_EXAMINE E
WHERE E.RECEIVEPEOPLEID = userId
AND E.STATE IN ('5','7');
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqSubmitCheckOrder',TEMPNUMBER);
PIPE ROW (v);
ELSIF ROWVAL.WEB_PAGE = '/view/ictpm/mywork/main.jsp?linkTo=/view/mywork/projectfirst-list_need_examAuditTaskorderList.action'
THEN --需我审核的验收通知单
SELECT COUNT(1) TOTAL INTO TEMPNUMBER
FROM ICTPM_EXAMINE E
WHERE E.STATE = '6'
AND EXISTS
(SELECT 1 FROM ICTPM_TASKORDER ER
WHERE ER.ID = E.TASKID
AND EXISTS
(SELECT 1 FROM ICTPM_PROJECTINFO INFO
WHERE INFO.ID = ER.PROJECTID
AND INFO.PROJECTMANAGER = userId));
TOTALCOUNT := TEMPNUMBER + TOTALCOUNT;
v:= objemp('reqMyTask-reqAuditCheckOrder',TEMPNUMBER);
PIPE ROW (v);
END IF;
END LOOP;
RETURN;
END F_O_GET_FIRSTPAGE_COUNT;
/
thomas0104
关注
专栏目录
postgresql 函数返回结果集(一)
Sicily_winner的博客
12-24 3255
参考文章： Postgres函数返回自定义数据集--返回自定义的TABLE结构 传入整个sql，自定义函数 根据上面2个文章，就可以实现 传入变量 编写sql return table多行数据 当前sql在datagrip界面操作，实现目标： 如果用户选择了开始时间(2015rq_s)和结束时间(2019rq_e)，则需要变成下面的效果 sql，范围是最长5年 ​select d.nf from (select regexp_split_to_table(test.nf...
r 函数返回多个值_R语言之数据处理(二)
weixin_39971435的博客
11-21 2554
我们继续来总结一下R语言数据处理的第二部分——维度处理。在R语言中，常见的多维数据的存储形式有矩阵、数据框、列表和数组等，其中向量是特殊的矩阵，矩阵是特殊的数据框，数据框又是特殊的数组。对于不同的数据形式，有对应的不同方法处理，下面会分别介绍apply类函数、dplyr拓展包、reshape2包和tidyr包中的相关函数及其运用情况。一、apply类函数1.apply若想对一个数组的行或者列按指定...
函数返回数据集
冷月宫主的专栏
12-05 599
http://blog.csdn.net/minitoy/article/details/6159575 1.返回cursor SQL> set serveroutput on SQL>  SQL> create or replace function func_return_cursor   2  return sys_refcursor   3  as   4
ORACLE 函数返回数据集
风中浮柳的专栏
03-25 1756
通过oracle中的函数，返回数据集 以学生为例，先定义学生实体数据类型 1.定义学生数据类型 CREATE OR REPLACE TYPE "STUDENT_OBJ" as object (     STUDENT_ID varchar2(10),          STUDENT_NAME varchar2(100),   STUDENT_NO VARCHAR2(10),
函数返回一个表集合数据
kang8408的专栏
12-28 158
--创建行类型 create or replace type row_type1 as object(k number, v varchar2(100)); --创建以行类型为row_type1的表类型table_type1 create or replace type table_type1 as table of row_type1; --function create or replace ...
集合返回函数（一）
HighGO
03-23 530
系列生成函数（series generating functions）系列的函数是集合返回函数（possibly return more than one row）最为常见和常用的，也是postgressql的内置函数，下面介绍一下此类函数：函数 参数类型 返回类型 描述 generate_series(start, stop) int 或 bigint setof int 或...
函数返回值
weixin_51648979的博客
12-09 98
概念：函数执行就会返回一个对象，内部的函数有return，就可以返回实际的值，否返回None 类型：返回的任意类型，返回值类型取决于return后面的类型 用途：调用方返回数据 注意：在函数的体内出现多个return，但最后只能返回一个retur 如果在函数体内执行retur，意味后面的代码语句不会再执行 函数：必选函数、默认函数、可变长度函数（元组）、关键字可变函数（字典） 函数嵌套 函数可以嵌套使用，在函数内容调用另外一个函数，内层函数访问外层函数的变量不能重新赋值 函数分类：根据函数的返回值和函数
sql函数集合（具体的讲解函数例子帮助理解）
07-12
以上只是SQL函数集合中的一部分，实际中还有更多的函数，如位运算函数、窗口函数等，每个都有自己独特的用途。掌握并熟练运用这些函数，能有效提升SQL查询的效率和灵活性。在实际工作中，可以根据需求灵活选择和组合...
python集合函数
AoChengi的博客
07-25 1285
一、集合 1.1 集合的特征 集合是无序的，集合中的元素是唯一的，集合一般用于元组或者列表中的元素去重 1.2 集合的格式 格式 变量名=set() 变量名.add(元素) # 必须不能初始化值 或 变量名={元素，元素，，，} 注意：下面写法为一个空字典，为空默认是字典，如果有数据在根据格式判断为字典还是集合 name={} 1.3 添加元素 1.3.1 add 案例 nums = {11,24,45,96,28} nums.add(42) print(nums) #
PTA函数与指针6-3求集合数据的均方差
YHL20040123的博客
01-07 5247
应该是首发解答，本人才疏学浅，如有不足欢迎指正！原创不易，转载请标明出处，如有错误欢迎指正！题目作者：孙骏 单位：武汉理工大学。
函数如何返回结果集
wiler的专栏
02-08 1655
CREATE OR REPLACE package p_test as    type t_myrc is ref cursor;      function f_getdata return t_myrc;   end p_test;/     CREATE OR REPLACE package body p_test as    function   f_getdata return t_my
函数的返回值
最新发布
自我升级中
06-23 1737
函数的返回值可以有多种
day-12函数进阶
qq_45658696的博客
08-02 432
day12-函数进阶
C语言函数返回值解析
热门推荐
hixiaogui的博客
04-09 2万+
一般来说，函数在返回返回值的时候汇编代码一般都会将待返回的值放入eax寄存器暂存，接着再调用mov指令将eax中返回值写入对应的变量中，如下代码：做简单的sum运算， 1 #include&lt;stdio.h&gt; 2 #include&lt;stdlib.h&gt; 3 4 int sum(int ivar1,int ivar2) 5 { 6 return i...
C语言函数的参数和返回值
qq_27114221的博客
11-20 896
如果把函数比喻成一台机器，那么参数就是原材料，返回值就是最终产品；函数的作用就是根据不同的参数产生不同的返回值。 函数的参数 在函数定义中出现的参数可以看做是一个占位符，它没有数据，只能等到函数被调用时接收传递进来的数据，所以称为形式参数，简称形参。 函数被调用时给出的参数包含了实实在在的数据，会被函数内部的代码使用，所以称为实际参数，简称实参。 形参和实参的功能是作数据传送，发生
函数返回值问题
脚踏实地，仰望星空
12-19 2734
程序1： #include char *returnStr() { char *p="hello world!"; return p; } int main() { char *str; str=returnStr(); printf("%s\n", str); return 0; } 这个没有任何问题，因为"hello w
函数返回值 返回引用
浪子的专栏
07-27 6601
先看看该链接讨论的问题作为热身。http://topic.csdn.net/u/20070616/13/2a6a1739-1a69-4829-a90f-fdb19a61e095.html   函数返回值和返回引用是不同的 函数返回值时会产生一个临时变量作为函数返回值的副本，而返回引用时不会产生值的副本，既然是引用，那引用谁呢？这个问题必须清楚，否则将无法理解返回引用到底是个什么概
【Oracle】实现函数返回值为数据集合
Do_GH的博客
08-27 449
创建自定义类型 CREATE OR REPLACE TYPE O_SPLIT_STR AS OBJECT ( SPLIT_STR VARCHAR2(32) ); 创建嵌套表 CREATE OR REPLACE TYPE TYPE_SPLIT_STR AS TABLE OF O_SPLIT_STR; 创建函数 CREATE OR REPLACE FUNCTION F_SPLIT_STR ( str varchar2, --待分拆的字符串 split varchar2 --数据分隔符 ) RE
Python编程：函数与数据集合讲解
"本资源是一份关于Python编程...总结来说，本讲义深入介绍了Python中的数据集合以及函数的使用，对于理解和掌握Python编程基础具有重要意义。通过学习这些概念，开发者能够更好地组织代码，提高程序的效率和可维护性。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值