#
PL/SQL Developer 7.0 - New Features感兴趣的功能(未测试)
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:
好久没有买计算机相关的书了, 今天在购书中心买了三本, 打算春节期间看看(不知有没有时间)
1. <<Joel On Software>>
2. <<Effective Enterprise Java>>
3. <<Effective Oracle By Design>>
都是中文版的, 争取在春节期间翻翻
年底了。事情可真多啊，离职，新工作，回家......
周五晚喝了个烂醉，本来要side的时间拿来休息了。
anyway, 祝各位
春节快乐!
摘要: Session.evict(), Session.setReadOnly()的用法
阅读全文
摘要: Spring集成Commons FileUpload, 实现文件上传
阅读全文
摘要: 现在的ORM(如Hibernate)性能一直不是很理想, 一些大型的J2EE项目还是以JDBC为主, 但一直对SP(Stored Procedure)有抵制情绪, 搞得SQL满天飞, 因最近几周用PL/SQL弄历史数据迁移的问题, 顺便整理一下JDBC调用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已经建议使用lob代替long, 但旧应用中还有一些long类型, 在insert into select from中无法使用
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