Oracle中插入一条数据并且返回该条数据的id

Oracle中插入一条数据并且返回该条数据的id：/*
    create or replace procedure worktask_content_Insert
    （

           theme varchar2,
           type varchar2,
           status varchar2,
           source varchar2,
           content   varchar2,
           slave varchar2,
           progress varchar2,
           conversionschedule varchar2,
           meetingid varchar2,
           scheduleid varchar2,
           scale varchar2,
           liableperson varchar2,
           coadjutant varchar2,
           starttime varchar2,
           endtime varchar2,
           completiondate varchar2,
           beforestarttime varchar2,
           starttype varchar2,
           beforeendtime varchar2,
           endtype varchar2,
           revise varchar2,
           departmentstask varchar2,
           sontask varchar2,
           taskcoding varchar2,
           createid varchar2,
           libdeparid varchar2,
           fathertaskid varchar2,
           maxid out varchar2
    ）
    as
          maxtaskid varchar2（50）;
    begin

         --插入数据
         insert into worktask_content values（sq_worktask_content.nextval,theme, type ,status,source,content,slave,progress,conversionschedule,meetingid,scheduleid,scale,liableperson,coadjutant,starttime, endtime ,
         completiondate,beforestarttime,starttype,beforeendtime,endtype,revise,departmentstask,sontask,taskcoding,createid,libdeparid,fathertaskid）;
         --查出最大值
        select MAX（taskid） into maxtaskid from worktask_content;

        maxid:=maxtaskid;
        --修改数据
        update worktask_content set fathertaskid=maxtaskid where taskid=maxtaskid;


        commit;

         Exception
                   When others then
                    Rollback;
    end;
*/
/
    -- declare
     -- b_id varchar（14）;
   -- begin
    -- worktask_content_Insert（"23","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1",b_id）;
    -- dbms_output.put_line（b_id）;
   -- end;


    -- select * from worktask_content
/EZDML支持在Oracle和SQL Server异构数据库之间导出备份和导入恢复数据Oracle存储过程代码实例一则相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（2）

评论声明

尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款