oracle
zjhgx
Cobol工程师
展开
-
合并字段
<br /> Hi,<br /><br />I would like to remove the duplicates from the string seperated by coma using the pl/sql functions.<br />How can I achieve this?<br /><br />ThanksQwerty<br /><br />Posts: 876 <br />Registered: 12/03/08 Re: Removing转载 2010-07-29 18:57:00 · 555 阅读 · 0 评论 -
String Aggregation Techniques
<br />On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Using the SCOTT.EMP table as an example, we might want to retrieve a list of employees for each depar转载 2010-07-29 19:00:00 · 471 阅读 · 0 评论 -
存储过程的一个例子
<br /> <br />spool gec13_merge_security_master.log;<br /><br />prompt create temp table<br />select to_char(sysdate, 'HH24:MI:SS') as begin_time from dual;<br />CREATE table GECDBA.GEC_ASSET_TEMP<br />(<br /> ASSET_ID NUMBER(38, 0),<br /> CUS原创 2010-10-08 20:15:00 · 324 阅读 · 0 评论 -
关于在PACKAGE里看LOG
create or replace PACKAGE BODY TEST_PKG AS PROCEDURE LOG_TEST(P_JOB_NAME IN VARCHAR2) IS BEGIN DBMS_OUTPUT.ENABLE(100000); D原创 2011-09-01 16:21:13 · 466 阅读 · 0 评论 -
在ORACLE 10g里遇到“无效的月份”错误
需要执行alter session set nls_language=american;alter session set nls_date_format='DD-MON-YY'; 注意在SQL PLUS DEVELOPER里加上后运行BUILD script后还是存在这个错误,需要把这两句代码写进脚本里执行。 可能在中文环境里会遇到这个问题原创 2013-02-24 15:33:40 · 467 阅读 · 0 评论