`
cary1130
  • 浏览: 197659 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

pl/sql function record

 
阅读更多
最近写procedure时用到了几个pl/sql function,记录一下,省得以后再用还得查。
1,DBMS_UTILITY.format_error_backtrace--错误的堆栈信息,比sqlerrm好用,sqlerrm只有错误,没有哪行报出来的,以后的错误处理中尽量用DBMS_UTILITY.format_error_backtrace代替sqlerrm
2,DBMS_LOCK.sleep(30);--睡眠30秒,同java中的sleep()
分享到:
评论

相关推荐

    PL/SQL Developer8.04官网程序_keygen_汉化

     函数:Create or replace function funcname(参数列表) return 返回值 as PL/SQL语句块  为便于理解,举例如下:  问题:假设有一张表t1,有f1和f2两个字段,f1为number类型,f2为varchar2类型,要往t1里写两条...

    plsqldev12.0.4.1826x64主程序+ v12中文包+keygen

    A Standard Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a PL/SQL source: The Test Window now supports Oracle12c implicit ...

    PLSQLDeveloper下载

    其语法结构为: 过程:Create or replace procedure procname(参数列表) as PL/SQL语句块 函数:Create or replace function funcname(参数列表) return 返回值 as PL/SQL语句块 为便于理解,举例如下: 问题:假设...

    plsqldev14.0.0.1961x32多语言版+sn.rar

    For these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. In the screenshots above “GIT Extensions” has been used. Worksets A ...

    Oracle P/L SQL实现FTP上传、下载功能

    Oracle P/L SQL实现FTP上传、下载功能,以下是此过程包的头部,包体经常打包处理plb,感兴趣用户可以下载下来。 --Oracle上的FTP功能 Create or Replace Package UTL_FTP AUTHID CURRENT_USER as Type Connection ...

    PLSQL.Developer(X32) v12.0.1.1814主程序+ v11中文包+keygen

    A Standard Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a PL/SQL source: The Test Window now supports Oracle12c implicit results...

    plsqldev12.0.4.1826x32主程序+ v12中文包+keygen

    A Standard Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a PL/SQL source: The Test Window now supports Oracle12c implicit ...

    PLSQL.Developer(X64) v12.0.1.1814 主程序+ v11中文包+keygen

    A Standard Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a PL/SQL source: The Test Window now supports Oracle12c implicit results...

    plsqldev14.0.1.1965x64多语言版+sn.rar

    Using the “SQL Window: Hide Editor” function would incorrectly reposition the vertical splitter The Debugger did not always show correct variable values in local subprograms Object Browser Filter ...

    plsqldev13.0.3.1902x32主程序+ v12中文包+keygen

    32位版本的 PLSQL 正式版。 安装中文包时请注意安装路径是否为PLSQL程序的路径。 安装请查看说明。...An error message about "GetTickCount64" could appear when starting PL/SQL Developer on Windows XP

    plsqldev13.0.3.1902x64主程序+ v12中文包+keygen

    64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。...An error message about "GetTickCount64" could appear when starting PL/SQL Developer on Windows XP

    Oracle8i_9i数据库基础

    §1.3 SQL、SQL*Plus及 PL/SQL 25 §1.3.1 SQL和SQL*PLUS的差别 25 §1.3.2 PL/SQL语言 27 §1.4 登录到SQL*PLUS 27 §1.4.1 UNIX环境 27 §1.4.2 Windows NT和WINDOWS/2000环境 29 §1.5 常用SQL*PLUS 附加命令简介...

    plsqldev14.0.0.1961x64多语言版+sn.rar

    For these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. In the screenshots above “GIT Extensions” has been used. Worksets A ...

    oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串

     数据查询语言 (Data Query Language, DQL) 是SQL语言中,负责进行数据查询而不会对数据本身进行修改的语句,这是最基本的SQL语句。例如:SELECT(查询)  数据控制语言Data Controlling Language(DCL),用来...

    精髓Oralcle讲课笔记

    -- 首先,以超级管理员的身份登录oracle sqlplus sys/bjsxt as sysdba --然后,解除对scott用户的锁 alter user scott account unlock; ... --(默认全局数据库名orcl) 1、select ename, sal * 12 from ...

Global site tag (gtag.js) - Google Analytics