oralce 查询tc数据库一些技巧

admin

oralce 查询TC数据库一些技巧
C:\Users\Administrator>set oralce_sid=tc10;
' k4 p# u* J( ~, F+ ]# d3 \设置oracle实例
6 f+ b3 m/ @% O2 c: fC:\Users\Administrator>sqplus/nolog
6 d" c2 V/ A- c5 c8 P( g'sqplus' is not recognized as an internal or external command,
operable program or batch file.
; |) Q, J) N/ {9 e2 l) FC:\Users\Administrator>sqlplus/nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 11 01:00:03 2014
6 k' d, [( {8 L& z7 R" k/ }% {Copyright (c) 1982, 2010, Oracle.  All rights reserved.
7 Q9 Z, I0 j" }# `! u4 BSQL> conn /as sysdba;
- l8 S$ v; k9 V! m/ g! _- x1 y" q使用sysdba直接连接数据库
' w6 n1 m0 _; l  z2 A2 G) SConnected.
SQL> select owner from dba_all_tables where table_name like '%PITEM%';
查找出所有的dba表，找到tc的PITEM的这个表的owner
# O+ c1 [) Z: f8 s+ O8 IOWNER
( [% c( }) A6 }, o  g" [0 j9 M0 Z------------------------------
TC_ADMINISTRATOR
TC_ADMINISTRATOR
" v9 {  ?% @6 @1 O  {6 a% h" E' a7 iTC_ADMINISTRATOR
TC_ADMINISTRATOR
3 Z2 ?- D* f9 w4 \9 ~$ C4 m6 _3 {TC_ADMINISTRATOR
0 w4 m% i3 @- J8 W2 o; iTC_ADMINISTRATOR
TC_ADMINISTRATOR
5 R7 B+ K7 _$ {$ R. y1 [1 A9 zTC_ADMINISTRATOR
5 g4 g, J2 o, m9 f% iTC_ADMINISTRATOR
8 |0 ^3 G, U4 h, G6 e; X2 c9 rows selected.
SQL> select pitem_id from TC_ADMINISTRATOR.PITEM where rownum<10;
通过添加owner可以直接查询PITEM表
PITEM_ID
--------------------------------------------------------------------------------
000001
000002
000003
7 e* |* k8 r4 K. B000004
000005
000006
) G3 c' M' F. u0 B000007
000008
000009
2 l/ l! |; ~/ ^9 rows selected.
1 d( E4 ^* m1 Z' G为了方便，切换使用owner帐号登录，这样就可以直接查找了
SQL> conn
2 x1 x4 F2 A6 O5 \9 L: `4 QEnter user-name: TC_ADMINISTRATOR
, o  d, n! z0 j8 P7 A9 e2 r5 tEnter password:
3 U- a9 u0 l$ q2 P4 U) \; dConnected.
7 W9 O* `+ P6 M/ P# OSQL> select puid from PBOUNDINGBOX where rownum<10;
% Z; ^" z& h; V! V( Z6 o' b7 r) |5 iPUID
---------------
R7aJs_c24VSRuB
' ~. R$ x! ^# \$ O8 B7 W  ^/ ^xKWJfazn4VSRuB
yUZJs_c24VSRuB
设置linesize可以调整显示
) h4 E7 G3 a# \1 \. k- b' }6 X0 X3 _SQL> set linesize 2000
SQL> select * from PBOUNDINGBOX where rownum<10;
# F, B0 F; M  V/ x# _9 g2 P% `PUID                PX_MIN     PY_MIN     PZ_MIN     PX_MAX     PY_MAX     PZ_MAX RPARENTU          RPARENTC
--------------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ----------
R7aJs_c24VSRuB     -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 R7UJs_c24VSRuB       59
* }3 f& Z# z& \! i5 Z+ l$ J. }yUZJs_c24VSRuB     -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 yUTJs_c24VSRuB       59
xKWJfazn4VSRuB           0          0          0         .1         .1         .1 xKQJfazn4VSRuB       59
8 \) }0 h  k/ v  T% N6 F# ], d# g
6 l5 q& ~8 ^1 p5 s

a150159

请问这个查出的内容是什么呢？select * from PBOUNDINGBOX where rownum<10;