iteye_7258-CSDN博客

原创 How to make aggregate function work on non-sort key

"When you need a value from the first or last row of a sorted group, but the needed value is not the sort key, the FIRST and LAST functions eliminate the need for self-joins or views and enable...

2011-10-10 00:45:30 83

原创 STATTAB FIELD DESCRIPTION (DBMS_STATS)

COLUMNDATA TYPETYPE=’T’TYPE=’C’TYPE=’I’TYPE=’S’(Oracle 9i)STATIDVARCHAR2(30)User settableUser settableUser settableUser settable...

2009-05-26 22:13:30 90

原创 Model Clause

http://www.oracle.com/technology/obe/obe10gdb/bidw/sqlmodel/sqlmodel.htm rule based inter-row calculation. use case ...

2009-05-21 16:15:39 94

原创 FTP login script

ftp -ni host << END_FTPquote user usernamequote pass passwordmget *byeEND_FTP ftp -ni host << END_SCRIPTuser username passwordmget *byeEND_SCRIPT http://www.inluminecons...

2008-10-22 08:54:40 141

原创 Usable Oracle Supported Connection Properties

remarkReporting Boolean------------- TRUE if getTables and getColumns should report TABLE_REMARKS. This is equivalent to using setRemarksReporting. The default value is FALSE. The value TRUE causes...

2008-08-06 11:23:34 83

Generate a table with number sequence in sql

Generate a table with number sequence in sql========= 1 Pre-defined collection types in Oracle---------select to_number(column_value) as num from table(sys.dbms_debug_vc2coll(1,2,3,4,5,6,7,8,9))...

2008-06-11 09:57:00 102

A baby sleeps in all our bones,so scared to be ...

Passing Afternoon -- Iron & Wine There are times that walk from you like some passing afternoon Summer warmed the open window of her honeymoon And she chose a yard to burn but th...

2008-06-07 16:04:04 130

Another Way to Solve Last Problem.

http://www.oracle.com/technology/oramag/code/tips2004/050304.html1. create a function to concatenate strings.CREATE OR REPLACE FUNCTION rowtocol( p_slct IN VARCHAR2, p_dlmtr IN VARCHA...

2008-05-24 11:05:07 90

User-defined Aggregate Function in Oracle

Author Book Author Books--------+-------- --------+--------poly | A poly | A,B,Cpoly | B ...

2008-05-23 22:07:13 113

Groovy Code To Export Oracle Procedures

It's really a pleasure to code in groovy.My first try: import groovy.sql.Sqlsql = Sql.newInstance("jdbc:oracle:thin:@ip:port:db","usr","pwd","oracle.jdbc.driver.OracleDriver")def base = "/usr/"...

2008-05-22 23:24:33 87

A Simple PLSQL Source Control Repository in Oracle

Create A Simple PL/SQL Source Control Repository in Oracle Using Trigger1 Create a table as repository of pl/sql source codecreate table CVS( P_VER NUMBER, P_TEXT LONG, P_NAME VARCHAR2(10...

2008-05-22 21:44:22 109

Defrag multiple partitions continuously.

DefragAll.batjava 代码 defrag c: -v defrag d: -v defrag e: -v

2007-08-20 17:02:00 63

Play sound with java.

java 代码 import java.io.IOException; import java.net.MalformedURLException; import javax.media.ControllerEvent; import javax.media.ControllerListener; import ...

2007-08-20 16:54:56 73

The Riddle

Criminal Minds 第二季第一集片尾曲http://pic13.pic.wretch.cc/photos/4/h/hyuk/11/1150252579.mp3Five For Fighting - The RiddleWords & Song by John OndrasikThere was a man back in '95在一九九五年，有一個男人Whose...

2007-04-13 00:29:59 171

ktnd