Oracle: Funtion return cursor values

SQL> — ref cursor
SQL> create or replace package pkg_types as
2 type refcursor is ref cursor;
3 end;
4 /
Package created.SQL> create or replace function f_return_refcursor
2 return pkg_types.refcursor
3 as
4 refcur pkg_types.refcursor;
5 begin
6 open refcur for select * from emp;
7 return refcur;
8 [...]

(M$) Oracle: ORA-12705

error “ORA-12705: Cannot access NLS data files or invalid environment specified”
解法:
至 \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE 下有一個 NLS_LANG 機碼
請把這個值, 改成你想要的字符集.
就Taiwan BIG5, 可改為 TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5

SQL*Plus: trimspool

當你在SQL*Plus裡, 做的任何動作.. 包括指令,及output的訊息等等
都會spool寫入到你指定的檔案裡

亂數取記錄

selecting random record.
select employees,name from
(select employees,name from usertable order by dbms_random.value)
where rownum < = 5
update: ref: http://forums.oracle.com/

Oracle: url

1. http://www.adp-gmbh.ch/
2. http://www.psoug.org/library.html

exp and imp in Oracle

ref: http://www.adp-gmbh.ch/ora/admin/imp_exp.html

exp and imp in Oracle

exp and imp are the executables that allow to make exports and imports of data objects (such as tables). Therefore, logical backups can be made with exp.
exp/imp allow to transfer the data accross databases that reside on different hardware plattforms and/or on different Oracle versions. If the [...]

keep looking »