- 博客(2)
- 资源 (2)
- 收藏
- 关注
原创 2021-03-26
posgresql存储过程返回记录集 CREATE OR REPLACE FUNCTION glam_data.p_test_return_set_of_reocrd() RETURNS setof glam_data.secu_basic_info AS $BODY$ declare secu glam_data.secu_basic_info; begin for secu in select * from glam_data.secu_basic_info sbi loop return next
2021-03-26 14:06:30 62
原创 Oracle谓词推入导致sql很慢的优化
优化前的SQL: select * from (select ta.fl_securityid,ta.fc_securitymarket,ta.fc_securitycode,ta.fl_investmenttypes,Fl_Balancetype,fl_circulation, ta.fc_settlecurrency, f...
2019-09-23 11:16:40 315
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人