2008-08-06
全文显示

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 OracleDatabaseMetaData to include remarks in the metadata. This can result in a subs ...
  • 11:23
  • 浏览 (11)
  • 评论 (0)
2008-06-11
全文显示

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)); select to_number(column_value) as num from table(sys.KU$_VCNT(1,2,3,4,5,6,7,8,9)); ...
2008-06-07
全文显示

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 the ground remembers her Wooden spoons, her childre ...
2008-05-24
全文显示

Another Way to Solve Last Problem.

http://www.oracle.com/technology/oramag/code/tips2004/050304.html 1. create a function to concatenate strings. CREATE OR REPLACE FUNCTION rowtocol( p_slct IN VARCHAR2, p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2 AUTHID CURRENT_USER AS TYPE c_refcur IS REF CURSOR; ...
2008-05-23
全文显示

User-defined Aggregate Function in Oracle

Author Book Author Books --------+-------- --------+-------- poly | A poly | A,B,C poly | B amy | D,E poly | C ====> amy | D amy | E   HOW? sel ...
2008-05-22
全文显示

Groovy Code To Export Oracle Procedures

It's really a pleasure to code in groovy. My first try: import groovy.sql.Sql sql = Sql.newInstance("jdbc:oracle:thin:@ip:port:db","usr","pwd","oracle.jdbc.driver.OracleDriver") def base = "/usr/" def names = [] def today = new java.text.SimpleDateFormat("yyyyMMddHH").format(new Date()) ...
2008-05-22
全文显示

A Simple PLSQL Source Control Repository in Oracle

Create A Simple PL/SQL Source Control Repository in Oracle Using Trigger 1 Create a table as repository of pl/sql source code create table CVS ( P_VER NUMBER, P_TEXT LONG, P_NAME VARCHAR2(100), P_OWNER VARCHAR2(30), P_TYPE VARCHAR2(30), P_DATE DATE, P_USER VARCHAR2(30) ...
2007-08-20
全文显示

Defrag multiple partitions continuously.

DefragAll.bat java 代码 defrag c: -v    defrag d: -v    defrag e: -v   
  • 17:02
  • 浏览 (174)
  • 评论 (0)
2007-08-20
全文显示

Play sound with java.

java 代码 import java.io.IOException;    import java.net.MalformedURLException;       import javax.media.ControllerEvent;    import javax.media.ControllerListener;    import javax.media.End ...
  • 16:54
  • 浏览 (292)
  • 评论 (0)
2007-04-13
全文显示

The Riddle

  Criminal Minds 第二季第一集片尾曲 http://pic13.pic.wretch.cc/photos/4/h/hyuk/11/1150252579.mp3 Five For Fighting - The Riddle Words & Song by John Ondrasik There was a man back in '95在一九九五年，有一個男人 Whose heart ran out of summers在夏天揮別了這個世界 But before he died, I asked him不過在他過世前，我問他 Wait, ...