Oracle table lock

http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/c21cnsis.htm http://www.twbbs.net.tw/1301826.html http://rchsh.itpub.net/post/8010/123945

Oracle 小筆記

— Create sequence create sequence TEST_SQ minvalue 1 maxvalue 9999999999 start with 21 increment by 1 cache 20; select test_sq.nextval from dual select test_sq.currval from dual https://172.20.10.6:5500/em/console/logon/logon https://172.20.10.6:5500/em/console/aboutApplication sqlplus sysman/sysman…Continue Reading …

oracle/sqlrelay/php 把 field 的 name 轉成小寫 sample code

// $__oradb->setOption(‘portability’, DB_PORTABILITY_LOWERCASE); require_once “config.php”; require_once “sqlrelay.php”; unset($__config[‘sqlrelay_dsn’]); $__config[‘sqlrelay_dsn’][]=”sqlrelay://xx_id:xx_pass@172.30.0.17:9000″; $sql=”select aaa,bbb from xxxx t where g_close_date is null”; $__now=get_microtime(); $__oradb=_fn_connect_sqlrelay(); $__oradb->setOption(‘portability’, DB_PORTABILITY_LOWERCASE); $result = $__oradb->query($sql); if (DB::isError($result)) { echo “db…Continue Reading …