21. 在oracle table中如何抓取memo类型字段为空的资料记录? select remark from oms_flowrec where trim(' ' from remark) is not null ; 22. 如何用bbb表的资料去更新aaa表的资料(有关联的字段) 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计算机安装方法 将symcjit.dll改为sysmcjit.old 24. 何查询server是不是ops? select * from v$option; 如果parallel server=true则有ops能 25. 何查询每个用户的权限? 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#’;
