#
PL/SQL Developer 7.0 - New Features感興趣的功能(未測(cè)試)
Refactoring
The refactoring function allows you to quickly reorganize your PL/SQL code. It works on the selected code, or ?if no selection is made ?on the current statement. Refactoring functions include ?Rename item ?Convert selection to procedure ?Convert selection to local constant ? Convert selection to global constant ?Replace assignment with initialization.
Excel export
The Excel export function now adds the SQL Text on a second page of the excel sheet.
Session Filters
You can define session filters to limit the sessions displayed and/or to define which columns you want to see and in which order. You can include/omit columns from the v$session table, or add additional column joined from other tables. At the top of the Session Window you can select which filter you want to use:
好久沒(méi)有買計(jì)算機(jī)相關(guān)的書了, 今天在購(gòu)書中心買了三本, 打算春節(jié)期間看看(不知有沒(méi)有時(shí)間)
1. <<Joel On Software>>
2. <<Effective Enterprise Java>>
3. <<Effective Oracle By Design>>
都是中文版的, 爭(zhēng)取在春節(jié)期間翻翻
年底了。事情可真多啊，離職，新工作，回家......
周五晚喝了個(gè)爛醉，本來(lái)要side的時(shí)間拿來(lái)休息了。
anyway, 祝各位
春節(jié)快樂(lè)!
摘要: Session.evict(), Session.setReadOnly()的用法
閱讀全文
摘要: Spring集成Commons FileUpload, 實(shí)現(xiàn)文件上傳
閱讀全文
摘要: 現(xiàn)在的ORM(如Hibernate)性能一直不是很理想, 一些大型的J2EE項(xiàng)目還是以JDBC為主, 但一直對(duì)SP(Stored Procedure)有抵制情緒, 搞得SQL滿天飛, 因最近幾周用PL/SQL弄?dú)v史數(shù)據(jù)遷移的問(wèn)題, 順便整理一下JDBC調(diào)用SP.
閱讀全文
Implicit Cursor FOR Loop
DECLARE
type_name VARCHAR2(10) := 'TABLE';
BEGIN
FOR item IN (SELECT object_name, status FROM user_objects WHERE object_type = type_name) LOOP
dbms_output.put_line('Table = ' || item.object_name || ', Status = ' || item.status);
END LOOP;
END;
/
Explicit Cursor FOR Loop
DECLARE
CURSOR c(type_name VARCHAR2) IS
SELECT object_name, status FROM user_objects WHERE object_type = type_name;
c_rec c%ROWTYPE;
BEGIN
FOR item IN c('TABLE') LOOP
dbms_output.put_line('Table = ' || item.object_name || ', Status = ' || item.status);
END LOOP;
OPEN c('TABLE');
LOOP
FETCH c INTO c_rec;
EXIT WHEN c%NOTFOUND;
dbms_output.put_line('Table = ' || c_rec.object_name || ', Status = ' || c_rec.status);
END LOOP;
CLOSE c;
END;
/
參考:
1. PL/SQL User's Guide and Reference
2. Java Oracle Database Development
Oracle已經(jīng)建議使用lob代替long, 但舊應(yīng)用中還有一些long類型, 在insert into select from中無(wú)法使用
long to long
declare
test_type long;
begin
select detail into test_type from table_long;
insert into table_long2(detail) values(test_type);
commit;
end;
/long to lob
insert into table_clob(detail) select to_lob(detail) from table_long; note: cannot use LOB locators selected from remote tables
參考:
1.
http://www.itpub.net/304707.html2. Oracle SQL Reference