21. 在oracle table中如何抓取memo類型字段為空的資料記錄? select remark from oms_flowrec where trim(' ' from remark) is not null ; 22. 如何用bbb表的資料去更新aaa表的資料(有關(guān)聯(lián)的字段) update aaa set bns_snm=(select bns_snm from bbb where aaa.dpt_no=bbb.dpt_no) where bbb.dpt_no is not null; 23. p4計算機(jī)安裝方法 將symcjit.dll改為sysmcjit.old 24. 何查詢server是不是ops? select * from v$option; 如果parallel server=true則有ops能 25. 何查詢每個用戶的權(quán)限? select * from dba_sys_privs; 26. 如何將表移動表空間? alter table table_name move tablespace_name; 27. 如何將索引移動表空間? alter index index_name rebuild tablespace tablespace_name; 28. 在linux,unix下如何激活dba studio? oemapp dbastudio 29. 查詢鎖的狀況的對象有? v$lock, v$locked_object, v$session, v$sqlarea, v$process ; 查詢鎖的表的方法: select s.sid session_id, s.username, decode(lmode, 0, 'none', 1, 'null', 2, 'row-s (ss)', 3, 'row-x (sx)', 4, 'share', 5, 's/row-x (ssx)', 6, 'exclusive', to_char(lmode)) mode_held, decode(request, 0, 'none', 1, 'null', 2, 'row-s (ss)', 3, 'row-x (sx)', 4, 'share', 5, 's/row-x (ssx)', 6, 'exclusive', to_char(request)) mode_requested, o.owner||'.'||o.object_name||' ('||o.object_type||')', s.type lock_type, l.id1 lock_id1, l.id2 lock_id2 from v$lock l, sys.dba_objects o, v$session s where l.sid = s.sid and l.id1 = o.object_id ; 30. 如何解鎖? alter system kill session ‘sid,serir#’;
