sql
喜欢一个人静静的听音乐
这个作者很懒,什么都没留下…
展开
-
postgreSql number 强制转换为boolean类型 别的数据库未测试
ALTER TABLE "public"."t_wf_action" ALTER COLUMN "is_delete" TYPE bool USING (is_delete::int::bool)原创 2021-08-06 16:23:54 · 751 阅读 · 0 评论 -
根据表名查询所有字段名
SELECT COLUMN_NAME as column_name,DATA_TYPE as data_type from user_tab_columns WHERE table_name = #{tableName}原创 2021-08-06 15:25:47 · 164 阅读 · 0 评论 -
postgreSql 存储过程语法
CREATE OR REPLACE FUNCTION "public"."home_count"("v_processor" varchar, "v_depart_id" varchar, "v_root_depart_id" varchar, "v_depart_name" varchar, "v_root_depart_name" varchar, "v_yearmonth" varchar) RETURNS TABLE("dcdb" int4, "dbfw" int4, "dbsw" int4,原创 2021-08-05 17:17:01 · 577 阅读 · 0 评论 -
postgreSql日期函数
当前时间只显示年月日,不显示时分秒 yyyy-MM-ddcurrent_date原创 2021-08-05 10:44:38 · 1497 阅读 · 0 评论 -
oracle postgreSql sql将列转换为一行并以逗号分隔;
1. oracle : wm_concat作用:将列转换为一行并以逗号分隔;SELECT * FROM ( SELECT a.group_id, a.group_name, a.group_sort, a.create_time, wm_concat(b.members_name) AS membersName FROM t_oa_pgroup a LEFT JOIN t_oa_pgroupmembers b ON a.group_id = b.group_id WHERE a.create_原创 2021-08-05 14:02:42 · 841 阅读 · 0 评论 -
递归查询 获得当前部门下所有上级部门ID集合
select departId,parentId FROM "SSJJ_IACENTER". T_IA_DEPARTMENT start with departId='013001' connect by prior parentId=departId;原创 2021-04-21 15:13:21 · 910 阅读 · 0 评论