菜鸟求助（关于多条件搜索分页存储过程的优化）

最新推荐文章于 2019-08-11 14:48:00 发布
最新推荐文章于 2019-08-11 14:48:00 发布
阅读量74 收藏
点赞数
原文链接：http://www.cnblogs.com/mygood/archive/2008/10/13/mssql2005.html
版权
以下是我实际应用中的存储过程，代码非常臃肿，关键是取下一页最后一条数据的ID，条件不用用变量来得到，所以就根据条件分别判断，造成每增加一个条件，代码就2倍增加。希望各位达人能够赐教，小弟不胜感激。
ContractedBlock.gif ExpandedBlockStart.gif Code
ALTER PROCEDURE [dbo].[Search_UserPage]
    @F_Nick nvarchar(100),
    @F_Gender tinyint,
    @NetType tinyint,
 @Page int,
 @PageSize int,
    @Province nvarchar(50),
    @Job nvarchar(50), 
 @OutCount int OUTPUT

AS

   BEGIN
       DECLARE @ID bigint
        DECLARE @DoWhere nvarchar(500)
        DECLARE @SQL nvarchar(1000)
        SET @DoWhere =' WHERE 1=1'
          SET NOCOUNT ON
              SET XACT_ABORT ON
            
                  BEGIN TRAN
            
               --搜索条件

             IF  @F_Nick <>'' 
             BEGIN
         SET    @DoWhere = @DoWhere + ' AND F_Nick like ''%/'+ @F_Nick +'%''escape ''/'''
              END        
        IF @F_Gender <>2
             BEGIN
               SET @DoWhere = @DoWhere + ' AND F_Gender='+convert(nvarchar(50),@F_Gender)
              END
      
          
          
         IF @NetType<>0
             BEGIN

              SET @DoWhere = @DoWhere + ' AND ((F_NetType & '+convert(nvarchar(50),@NetType)+')!=0)'
           
                END                
                
              IF @Province<>''
                  BEGIN
              SET @DoWhere = @DoWhere +' AND F_Province='''+@Province+''''
                  END

              IF @Job<>''
                  BEGIN
              SET @DoWhere = @DoWhere +' AND F_Job='''+@Job+''''
                  END
                 
       -- print (@DoWhere)         

      
     
                 

             --搜索条件结束
        
             IF @Page = 1 --第一页
                  
                 BEGIN

                   set @SQL='SELECT TOP('+convert(nvarchar(100),@PageSize)+') * FROM T_User'+ @DoWhere +' ORDER BY F_UID '

                   exec(@SQL)  
                     
                 END
                 
                     ELSE --取下一页，就是从这里开始的，

                        BEGIN
                             --取最后一条ID
                             IF  @F_Nick <>'' 
                              BEGIN

                                 IF @F_Gender <>2
                                    begin
                                       IF @NetType<>0   
                                           begin
                                              IF @Province<>''
                                                  begin
                                                      IF @Job<>''
                                                           begin
                                       SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                        F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                                           and (F_NetType & @NetType)!=0 and F_Province =@Province 
                                         and F_Job=@Job   ORDER BY F_UID 
                                                               end
                                                            else
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                        F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                                           and (F_NetType & @NetType)!=0 and F_Province =@Province 
                                            ORDER BY F_UID 
                                                              end
                                           
                                                     

                                                   end
                                                     else
                                                        begin
                                                       IF @Job<>''
                                                           begin
                                                  SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                        F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                                           and (F_NetType & @NetType)!=0  and F_Job=@Job
                                            ORDER BY F_UID 

                                                               end
                                                            else
                                                           begin
                                        SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                        F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                                           and (F_NetType & @NetType)!=0 
                                            ORDER BY F_UID 

                                                              end

                                                     

                                                           end
                                                     
                                            end  
                                             else
                                                begin
                                                   IF @Province<>''
                                                       begin
                                                         IF @Job<>''
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                              F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                              and F_Province =@Province and F_Job=@Job  ORDER BY F_UID
                                                               end
                                                            else
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                              F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender 
                              and F_Province =@Province  ORDER BY F_UID
                                                              end
                             
                             
                                                        end
                                                          else
                                                                begin
                                                     IF @Job<>''
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                    F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender
                                     and F_Job=@Job ORDER BY F_UID
                                                               end
                                                            else
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE 
                                    F_Nick like '%/'+  @F_Nick +'%'escape '/' and F_Gender=@F_Gender
                                     ORDER BY F_UID
                                                              end

                                  


                                                                 end
                                                   end

                                     end 

                                      else
                                        begin
                                            IF @NetType<>0
                                               BEGIN
                                                IF @Province<>''
                                                       begin
                                                 IF @Job<>''
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/' AND (F_NetType & @NetType)!=0
                                           and F_Province =@Province and F_Job=@Job ORDER BY F_UID
                                                               end
                                                            else
                                                           begin
                                      SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/' AND (F_NetType & @NetType)!=0
                                           and F_Province =@Province ORDER BY F_UID
                                                              end    
                                        

                                                       end
                                                           else
                                                              begin
                                                 IF @Job<>''
                                                           begin
                                         SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/' AND (F_NetType & @NetType)!=0
                                           and F_Job=@Job ORDER BY F_UID 
                                                               end
                                                            else
                                                           begin
                                     SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/' AND (F_NetType & @NetType)!=0
                                            ORDER BY F_UID 
                                                              end
                                          

                                                                 end 

                                                END
                                                  ELSE
                                                      BEGIN
                                                     IF @Province<>''
                                                           begin 
                                                     IF @Job<>''
                                                           begin
                                  SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/'
                                           and F_Province =@Province and F_Job=@Job ORDER BY F_UID
                                                               end
                                                            else
                                                           begin
                                  SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/'
                                           and F_Province =@Province ORDER BY F_UID
                                                              end
                                           

                                                            end
                                                               else
                                                                  begin
                                                       IF @Job<>''
                                                           begin
                                      SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/'
                                         and F_Job=@Job  ORDER BY F_UID
                                                               end
                                                            else
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                           WHERE F_Nick like '%/'+  @F_Nick +'%'escape '/'
                                            ORDER BY F_UID
                                                              end
                                             

                                                                    end 
                                                          END
                                          end

                                    
                              
                                END
                                  else
                                     begin
                                       IF @F_Gender <>2
                                           begin
                                             IF @NetType<>0
                                                begin
                                                        IF @Province<>''
                                                              begin
                                                               IF @Job<>''
                                                           begin
                                                                SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                                  WHERE F_Gender=@F_Gender and (F_NetType & @NetType)!=0
                                                   and F_Province =@Province and F_Job=@Job ORDER BY F_UID 
                                                                end
                                                            else
                                                           begin
                                  SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                                  WHERE F_Gender=@F_Gender and (F_NetType & @NetType)!=0
                                                   and F_Province =@Province ORDER BY F_UID 
                                                              end
                                                      

                                                               end
                                                                  else
                                                                    begin
                                                               IF @Job<>''
                                                           begin
                                       SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                                  WHERE F_Gender=@F_Gender and (F_NetType & @NetType)!=0
                                                  and F_Job=@Job  ORDER BY F_UID  
                                                               end
                                                            else
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                                  WHERE F_Gender=@F_Gender and (F_NetType & @NetType)!=0
                                                    ORDER BY F_UID  
                                                              end  
                                                        
                  
                                                                       end
                                                  end
                                                 else
                                                   begin
                                                                IF @Province<>''
                                                                    begin
                                                             IF @Job<>''
                                                           begin
                                      SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                      WHERE F_Gender=@F_Gender and F_Province =@Province and F_Job=@Job ORDER BY F_UID 
                                                               end
                                                            else
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                    WHERE F_Gender=@F_Gender and F_Province =@Province ORDER BY F_UID 
                                                              end
                                                      

                                                                      end
                                                                         else
                                                                             begin
                                                     IF @Job<>''
                                                           begin
                                      SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                      WHERE F_Gender=@F_Gender and F_Job=@Job ORDER BY F_UID   
                                                               end
                                                            else
                                                           begin
                                     SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User 
                                      WHERE F_Gender=@F_Gender ORDER BY F_UID   
                                                              end
                                                    
        
                                                                               end
                                                    end
                                 

                                                 
                                            end
                                               else
                                                  begin
                                                         IF @NetType<>0
                                                                  begin
                                                                   IF @Province<>''
                                                             begin
                                                      IF @Job<>''
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE (F_NetType & @NetType)!=0
                                    and F_Province =@Province and F_Job=@Job  ORDER BY F_UID 
                                                               end
                                                            else
                                                           begin
                                   SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE (F_NetType & @NetType)!=0
                                  and F_Province =@Province  ORDER BY F_UID 
                                                              end
                                                      

                                                              end  
                                                                 else
                                                                     begin
                                                            IF @Job<>''
                                                           begin
                                    SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE (F_NetType & @NetType)!=0
                                     and F_Job=@Job ORDER BY F_UID 
                                                               end
                                                            else
                                                           begin
                             SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User WHERE (F_NetType & @NetType)!=0
                             ORDER BY F_UID 
                                                              end          
                                                      

                                                                        end          

                                                                   end
                                                                     else
                                                                        begin
                                                                     IF @Province<>''
                                                                       begin
                                    IF @Job<>''
                                                 begin
                     SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User where F_Province =@Province and F_Job=@Job ORDER BY F_UID
                                                   end
                                                      else
                                                        begin
                              SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User where F_Province =@Province ORDER BY F_UID
                                                          end
                                                                

                                                                        end
                                                                            else
                                                                              begin
                         IF @Job<>''
                                begin
     SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User where  F_Job=@Job ORDER BY F_UID 
                                  end
                                     else
                               begin
     SELECT TOP((@Page - 1) * @PageSize) @ID=F_UID FROM T_User ORDER BY F_UID                                 
                                 end
                                                               
 
                                                                                end                                                                  
                                                                          end

                                                    end
                       

                                      end
--这里结束的

                          SET @SQL='SELECT TOP('+str(@PageSize)+') * FROM T_User '+ @DoWhere +' and F_UID>'+ str(@ID) +' ORDER BY F_UID '    
                             exec(@SQL)       
                 
                         END 
            

                 SET @OutCount=22


           SET XACT_ABORT OFF
          SET NOCOUNT OFF

   END

转载于:https://www.cnblogs.com/mygood/archive/2008/10/13/mssql2005.html

dianer5226
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
spring boot 复杂多条件分页排序列表查询
nu11_的博客
11-09 2780
Controller层就不写了，主要贴一下Service代码。 Service import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest
扩展GridView控件(索引) - 增加多个常用功能
lp_2007的专栏
10-11 3016
文章索引扩展GridView控件(1) - 鼠标经过行时改变行的样式扩展GridView控件(2) - 复合排序和排序状态提示扩展GridView控件(3) - 根据按钮的CommandName设置其客户端属性扩展GridView控件(4) - 联动复选框（复选框的全选和取消全选）扩展GridView控件(5) - 固定指定行、指定列扩展GridView控件(6) - 响应行的单击事件和双击事件扩
ElasticSearch 条件,分页，排序，多条件查询Demo
weixin_30613727的博客
08-11 699
原文： java1234，峰哥 1. 获取客户端连接demo import org.elasticsearch.client.transport.TransportClient; import org.elasticsearch.common.settings.Settings; import org.elasticsearch.common.transport.InetS...
要提高SQL查询效率where语句条件的先后次序应如何写
weixin_30915275的博客
04-03 495
我们要做到不但会写SQL，还要做到写出性能优良的SQL语句。（1）选择最有效率的表名顺序(只在基于规则的优化器中有效)：Oracle的解析器按照从右到左的顺序处理FROM子句中的表名，FROM子句中写在最后的表(基础表 driving table)将被最先处理，在FROM子句中包含多个表的情况下,你必须选择记录条数最少的表作为基础表。如果有3个以上的表连接查询, 那就需要选择交叉表(inters...
【转】实现多条件筛选、搜索、排序及分页的表格功能
Legolas4的博客
08-28 939
http://www.jianshu.com/p/d14ddd5f2537
批处理常用命令总结和WindowsXP下运行命令使用大全及优化
z22050519的专栏
11-29 1万+
关于批处理以及批处理常用命令的总结   【 一、什么是批处理 】 　批处理文件图标　批处理(Batch)，也称为批处理脚本。顾名思义，批处理就是对某对象进行批量的处理。批处理文件的扩展名为 bat 。 　　目前比较常见 的批处理包含两类：DOS批处理和PS批处理。PS批处理是基于强大的图片编辑软件Photoshop的，用来批量处理图片的脚本；而DOS批处理则是基于DOS命令的，用来自动地批
MS-SQL Server 基础类 - SQL语句
热门推荐
hz的专栏
03-01 1万+
 
WEB开发文档2 总结
小北
04-19 3874
转自：http://blog.donews.com/lvjiyong/archive/2006/06/29/931071.aspx怎样将后台生成的在内存中的图象显示到客户端Microsoft IE WebControls下载地址如何在DATAGRID中使用JAVASCRIPT脚本控制DataGrid中连接到下一页显示数据下载中文名文件时保存文件名乱码问题关于用ASP.net绘图的问题,请大虾指教那
asp.net 分页存储过程实例剖析心得
10-28
最近修改了个分页存储过程，作为菜鸟，还是从中获益良多，这里就开始今天的分页之旅了
C# winform调用SQL存储过程-菜鸟入门 详细注释
08-05
内容概要：简单的C# winform调用存储过程实例，创建存储过程入参，通过SqlConnection对象和SqlCommand对象调用存储过程，获取存储过程的出参并显示出来，详细代码注释，希望对用到C#调用存储过程的小伙伴有帮助 ...
菜鸟分页（含有存储过程）
09-22
在实践中，你可能会遇到各种复杂情况，如动态排序、多条件筛选等，但只要掌握了基础，就能逐步应对这些问题。现在，你可以尝试打开“分页”这个压缩包文件，里面应该包含了一个示例，帮助你更好地理解和实践这个分页...
多微网的分布式能量优化交易调度.zip
03-22
分布式能源交易：多微电网案例一种优化算法，可最大程度地减少互连的微电网系统之间的总体成本，该系统可以彼此交换能量。设置系统并迭代解决优化问题。在每次迭代中，首先，微电网针对给定的一组能源价格解决其局部...
MySQL存储过程的深入讲解（in、out、inout）
01-21
存储过程的优点 1、执行一次后，会将生成的二进制代码驻留缓冲区（便于下次执行），提高执行效率 2、SQL语句加上控制语句的集合，灵活性高 3、在服务器端存储，客户端调用时，降低网络负载 4、可多次重复被调用，可...
qt练习控件label控件-lineEdit控件样例代码
最新发布
07-30
qt练习控件label控件-lineEdit控件样例代码
【JCR一区级】麻雀搜索算法SSA-CNN-LSTM-Attention故障诊断分类预测【含源码 5689期】.zip
07-30
CSDN海神之光上传的全部代码均可运行，亲测可用，直接替换数据即可，适合小白； 1、代码压缩包内容 主函数：Main .m； 数据； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，可私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开除Main.m的其他m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描博主博客文章底部QQ名片； 4.1 CSDN博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作 智能优化算法-CNN-LSTM-Attention分类系列程序定制或科研合作方向： 4.4.1 遗传算法GA/蚁群算法ACO-CNN-LSTM-Attention分类 4.4.2 粒子群算法PSO/蛙跳算法SFLA-CNN-LSTM-Attention分类 4.4.3 灰狼算法GWO/狼群算法WPA-CNN-LSTM-Attention分类 4.4.4 鲸鱼算法WOA/麻雀算法SSA-CNN-LSTM-Attention分类 4.4.5 萤火虫算法FA/差分算法DE-CNN-LSTM-Attention分类
详解MATLAB Simulink通信系统建模与仿真
07-30
第1 章 MATLAB 基础与通信系统仿真 1.1 MATLAB 简介 1.2 MATLAB 程序设计 1.3 通信系统仿真 第2 章 Simulink 仿真基础 2.1 Simulink 简介 2.2 Simulink 工作环境 2.3 Simulink 仿真的基本方法 2.4 创建自己的模块库 2.5 S-函数的编写 第3 章 通信信号与系统分析 3.1 离散信号和系统 3.2 Fourier 分析 3.3 带通信号的低通等效 3.4 随机信号分析 第4 章 信道 4.1 加性高斯白噪声信道 4.2 多径衰落信道 第5 章 模拟调制 5.1 幅度调制 5.2 角度调制 第6 章 数字基带传输 6.1 概述 6.2 二进制基带信号传输 6.3 基带PAM 信号传输 6.4 带限信道的信号传输 第7 章 数字信号载波传输 7.1 概述 7.2 载波幅度调制（PAM） 7.3 载波相位调制（PSK） 7.4 正交幅度调制（QAM） 7.5 载波频率调制（FSK） 第8 章 信道编码和交织 8.1 概述 8.2 线性分组码
SCI一区】淘金算法GRO-CNN-BiLSTM-Mutilhead-Attention多变量时序预测含源码 5642.zip
07-30
CSDN海神之光上传的全部代码均可运行，亲测可用，直接替换数据即可，适合小白； 1、代码压缩包内容 主函数：Main .m； 数据； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，可私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开除Main.m的其他m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描博主博客文章底部QQ名片； 4.1 CSDN博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作 智能优化算法-CNN-BiLSTM-Mutilhead-Attention回归预测系列程序定制或科研合作方向： 4.4.1 遗传算法GA/蚁群算法ACO-CNN-BiLSTM-Mutilhead-Attention回归预测 4.4.2 粒子群算法PSO/蛙跳算法SFLA-CNN-BiLSTM-Mutilhead-Attention回归预测 4.4.3 灰狼算法GWO/狼群算法WPA-CNN-BiLSTM-Mutilhead-Attention回归预测 4.4.4 鲸鱼算法WOA/麻雀算法SSA-CNN-BiLSTM-Mutilhead-Attention回归预测 4.4.5 萤火虫算法FA/差分算法DE-CNN-BiLSTM-Mutilhead-Attention回归预测
oracle存储过程菜鸟教程
05-25
Oracle存储过程是一种预编译的程序，它可以在数据库服务器上执行。它们通常用于执行复杂的数据操作和事务处理。在Oracle中，存储过程可以通过PL/SQL编写。 以下是一个简单的Oracle存储过程示例： ``` CREATE OR REPLACE PROCEDURE get_employee_details (emp_id IN NUMBER, emp_name OUT VARCHAR2, emp_salary OUT NUMBER) IS BEGIN SELECT employee_name, salary INTO emp_name, emp_salary FROM employees WHERE employee_id = emp_id; END; ``` 这个存储过程接收一个员工ID作为输入参数，并返回该员工的姓名和薪水。存储过程中使用了SELECT语句来检索数据，并将结果存储在输出参数中。 要执行存储过程，可以使用以下命令： ``` DECLARE emp_name VARCHAR2(50); emp_salary NUMBER; BEGIN get_employee_details(1001, emp_name, emp_salary); DBMS_OUTPUT.PUT_LINE('Employee Name: ' || emp_name); DBMS_OUTPUT.PUT_LINE('Employee Salary: ' || emp_salary); END; ``` 在这个例子中，我们声明了两个变量来存储存储过程的输出值。然后，我们使用“get_employee_details”存储过程来获取员工1001的详细信息，并将结果存储在变量中。最后，我们使用DBMS_OUTPUT.PUT_LINE函数来打印结果。 这只是一个简单的例子，Oracle存储过程可以执行更复杂的数据操作和事务处理。如果您想深入学习Oracle存储过程，请参考Oracle官方文档或参考一些在线资源。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值