- 博客(6)
- 资源 (1)
- 收藏
- 关注
原创 Using UTL_FILE in Oracle10g XE
Getting Started In order to use UTL_FILE package, which is owned by SYS, you have to grant EXECUTE privilege to user after you log in as SYS. Execute the following commands at SQL> prompt after ...
2013-12-20 15:33:02 76
原创 PL/SQL 编码规范
浏览地址:http://www.williamrobertson.net/documents/plsqlcodingstandards.html
2013-12-20 10:03:03 124
原创 使用Torquebox在Windows下面进行Rails的部署
一、安装Torquebox 参考:http://torquebox.org/getting-started/3.0.1/first-steps.html#first-steps-windowshttp://torquebox.org/documentation/3.0.1/JAVA_HOME=D:\Program Files\Java\jdk1.7.0_21JBOSS_HOME=D:\torq...
2013-12-16 07:16:36 146
原创 Creating and Unpacking Delimited Strings in SQL
Recently a friend asked me for this. I see it a lot on OraFaq as a question in the forums so here are the basics of working with delimited strings. I will show the various common methods for creating...
2013-12-10 17:18:28 188
原创 Oracle Pipelined Table Functions
在实际的应用中,为了让PL/SQL 函数返回数据的多个行,必须通过返回一个 REF CURSOR 或一个数据集合来完成。REF CURSOR 的这种情况局限于可以从查询中选择的数据,而整个集合在可以返回前,必须进行具体化。 9i 通过引入的管道化表函数纠正了后一种情况。表函数是返回整个行的集(通常作为一个集合)的函数,可以直接从 SQL 语句中进行查询,就好像它是一个真正的数据库表一样。管道化表...
2013-12-10 17:04:13 93
原创 Oracle DBMS_UTILITY.comma_to_table & table_to_comma
he DBMS_UTILITY.comma_to_table and DBMS_UTILITY.table_to_comma procedures allow you to split and rejoin the values in a CSV record. DECLARE l_list1 VARCHAR2(50) := 'A,B,C,D,E,F,G,H,I,J'; l...
2013-12-10 16:57:58 557
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人