|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
×
$ @# W8 K$ H% C; ^" B0 p% N/ y% ~- ~: _# o
oralce 查询TC数据库一些技巧
: l; w1 z+ T+ r8 A( G& ]: W, aC:\Users\Administrator>set oralce_sid=tc10;
6 r1 t$ ?3 p% L: G a# p* c设置oracle实例
$ e& b: b4 i/ i% _$ C! L. W/ \* \C:\Users\Administrator>sqplus/nolog; Z8 i; a6 K4 Z% Y
'sqplus' is not recognized as an internal or external command,( z- H9 g7 [* K' V
operable program or batch file.9 U @* p; V& e: d! K* F ]' w" O
C:\Users\Administrator>sqlplus/nolog
, Q- p. B( d" g3 eSQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 11 01:00:03 2014
% D7 {6 Y" e* rCopyright (c) 1982, 2010, Oracle. All rights reserved.
5 V& v" y: ^/ BSQL> conn /as sysdba;+ A& a* `0 u: M3 f* t& \: f2 V! R
使用sysdba直接连接数据库
' i- H' z1 d' P/ L9 E2 y1 O R7 iConnected.+ ?3 e2 l7 c) ~6 H; T
SQL> select owner from dba_all_tables where table_name like '%PITEM%';- L+ ^3 E& W4 E$ \0 d4 J
查找出所有的dba表，找到tc的PITEM的这个表的owner
: I& Y# S, K& iOWNER
0 t1 ^$ _+ |$ H$ R0 q0 p* i) s' U------------------------------
' k1 F/ k& ~% ?: [* B% ~% QTC_ADMINISTRATOR/ G& A. `6 o- x
TC_ADMINISTRATOR
# V7 p! S7 O1 v2 P+ qTC_ADMINISTRATOR1 l+ U N) Z& |- ~! F
TC_ADMINISTRATOR
, g9 Z$ ] X/ r3 m s5 [TC_ADMINISTRATOR
- W) m) v7 ]' B' v$ BTC_ADMINISTRATOR f" U* w% ]; O' ~* F
TC_ADMINISTRATOR
, F$ u2 V0 E- N$ P- NTC_ADMINISTRATOR: ^( t( Z7 m, r2 A5 Y
TC_ADMINISTRATOR/ `6 J3 N$ A9 C& i. D' {: f
9 rows selected.; `4 Y3 U3 p) k: F, d
SQL> select pitem_id from TC_ADMINISTRATOR.PITEM where rownum<10;8 ~2 ^% y B0 c y5 Y" A
通过添加owner可以直接查询PITEM表5 i. w' s, U: I0 O* X U$ M4 u
PITEM_ID5 } `. ^, m0 t) ]. K! K1 g' _
--------------------------------------------------------------------------------/ c7 S( Z8 P* K9 \; i
000001
, v& Y) b/ G/ z/ B0000026 ?4 i( ~0 Q3 L$ M y: I/ A
000003
" m- m8 m7 e" V/ t( D) k000004# n# F- j2 Z# ]( v( Z6 U9 d* P7 q3 E
0000050 z- Z& N1 t* G! k4 Y% K+ v
000006
! d) _7 {. C. t3 D000007
! i Z" d! l6 I9 n% P000008
$ k6 I2 d9 _+ @1 a' d6 ^/ T m000009# L( z; m l3 }" j
9 rows selected.: Q- z' T% B2 C& Z4 V" t: p) X
为了方便，切换使用owner帐号登录，这样就可以直接查找了+ ^* Y$ m! {% Q; |9 q& i
SQL> conn! t0 J1 ]' b: n: h8 Q% |
Enter user-name: TC_ADMINISTRATOR8 E" |6 h7 {# Y- j( t
Enter password:
# {! V( m3 b2 ]* N! SConnected./ t4 y7 P. {9 @* N; Y" W- f
SQL> select puid from PBOUNDINGBOX where rownum<10;
# i+ `8 h. J4 \ e/ Q% [+ tPUID: Z' s- f/ t f/ ]
---------------( _+ ?! o( @ {$ L! X/ q. N
R7aJs_c24VSRuB
; q9 X% ]* j8 ?) Q/ l8 h3 f( }, fxKWJfazn4VSRuB: \2 N7 w9 u2 m1 i) S% @6 R
yUZJs_c24VSRuB
7 m: E2 s" n) \( v/ E( D( p8 _0 i设置linesize可以调整显示
: |* g( P6 D3 Q2 _) w% \' t; PSQL> set linesize 2000! _1 @% W+ Y4 Y1 L
SQL> select * from PBOUNDINGBOX where rownum<10;
J) \# c# w& i& e' W$ ^, j' qPUID PX_MIN PY_MIN PZ_MIN PX_MAX PY_MAX PZ_MAX RPARENTU RPARENTC
: [* G2 Y) c7 t& [2 |--------------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ----------8 Q7 a, B: j6 c6 `# s
R7aJs_c24VSRuB -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 R7UJs_c24VSRuB 59
" {2 K n- e0 r& M8 nyUZJs_c24VSRuB -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 yUTJs_c24VSRuB 59
0 F# w2 Y( M7 p1 C7 qxKWJfazn4VSRuB 0 0 0 .1 .1 .1 xKQJfazn4VSRuB 59
$ a1 p* u' j. d
8 a& }' ?6 R( @6 S0 T' a. Y9 i |
|
发表于 2014-2-11 17:11:55
发表于 2018-2-26 10:22:12
