ktnd
- 浏览: 17289 次
- 性别:
- 来自: 上海
-
最新评论
文章列表
"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 better performance."
SELECT department_id,
MIN(salary) KEEP (DENSE_RANK FIRST ...
COLUMN
DATA TYPE
TYPE=’T’
TYPE=’C’
- 2009-05-26 22:13
- 浏览 1082
- 评论(0)
http://www.oracle.com/technology/obe/obe10gdb/bidw/sqlmodel/sqlmodel.htm
rule based inter-row calculation.
use case ...
- 2009-05-21 16:15
- 浏览 838
- 评论(0)
ftp -ni host << END_FTP
quote user username
quote pass password
mget *
bye
END_FTP
ftp -ni host << END_SCRIPT
user username password
mget *
bye
END_SCRIPT
http://www.inlumineconsulting.com:8080/website/scripting.ftp.html
- 2008-10-22 08:54
- 浏览 1036
- 评论(0)
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 substantial reductio ...
- 2008-08-06 11:23
- 浏览 975
- 评论(0)
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));
select colu ...
- 2008-06-11 09:57
- 浏览 1678
- 评论(0)
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 children stir her Bougainvillea blooms There are things tha ...
- 2008-06-07 16:04
- 浏览 1163
- 评论(0)
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;
lc_s ...
- 2008-05-24 11:05
- 浏览 1197
- 评论(0)
Author Book Author Books
--------+-------- --------+--------
poly | A poly | A,B,C
poly | B amy | D,E
poly | C ====>
amy | D
amy | E
HOW?
select author, to_ ...
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.SimpleDat ...
- 2008-05-22 23:24
- 浏览 1190
- 评论(0)
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)
)
2 Creat ...
DefragAll.bat
java 代码
defrag c: -v
defrag d: -v
defrag e: -v
- 2007-08-20 17:02
- 浏览 974
- 评论(0)
java 代码
import java.io.IOException;
import java.net.MalformedURLException;
import javax.media.ControllerEvent;
import javax.media.ControllerListener;
import javax.media.EndOfMediaEvent;
import javax.media.Manager;
import javax.media.MediaLocato ...
- 2007-08-20 16:54
- 浏览 1241
- 评论(0)
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, what's the sense ...
- 2007-04-13 00:29
- 浏览 1323
- 评论(0)