|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
9 O Z; D% `2 [2 p4 Ooralce 查询TC数据库一些技巧
9 `6 n$ A; v0 C1 d. C6 q$ {+ m2 {- \$ UC:\Users\Administrator>set oralce_sid=tc10;) o4 \: p8 L- Z& S. F3 C
设置oracle实例
G$ ?' n" U' cC:\Users\Administrator>sqplus/nolog. y8 A2 @8 a y+ ^1 V7 g! p$ B
'sqplus' is not recognized as an internal or external command,4 r; c- }6 }9 f6 I; w. w$ }( p
operable program or batch file.4 u- P" E* a( z1 {; `2 Q+ s1 i
C:\Users\Administrator>sqlplus/nolog- B, ?& z& [% _4 o+ T& \ f
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 11 01:00:03 2014
* \) m* I/ z. yCopyright (c) 1982, 2010, Oracle. All rights reserved.+ j- ?+ Z% ?# |) B; k
SQL> conn /as sysdba;
6 Y8 q# D1 a; S* `" d& Z' b/ h, C使用sysdba直接连接数据库
, `- x4 v" n6 ~0 r5 m, h0 n8 N( cConnected.; u: F3 X, A! w& w8 U0 N
SQL> select owner from dba_all_tables where table_name like '%PITEM%';6 @" T; e; S: j0 ?
查找出所有的dba表,找到tc的PITEM的这个表的owner
/ p7 w1 C2 u7 P3 N5 }OWNER
' ^1 k* X1 G! j: Y2 B6 l$ z------------------------------
) m. p( N) g6 E4 T, ZTC_ADMINISTRATOR
( W5 C- t+ ^3 X% sTC_ADMINISTRATOR
. n% S A5 |. o+ E6 GTC_ADMINISTRATOR
$ `9 Y/ e. i5 g+ f: L0 X/ ~TC_ADMINISTRATOR
" d: V5 k: t& O! MTC_ADMINISTRATOR
5 N8 }& }% P9 p' x5 K5 tTC_ADMINISTRATOR
" ?9 t: A( f8 z- n; O8 R& [) ZTC_ADMINISTRATOR
% g( Q: J8 s \TC_ADMINISTRATOR/ j8 A% w) S5 Q0 y9 P$ y7 g
TC_ADMINISTRATOR$ K1 d4 _1 b7 ~4 p6 Q
9 rows selected.
/ s$ Y+ G7 e1 X3 o* P/ d7 vSQL> select pitem_id from TC_ADMINISTRATOR.PITEM where rownum<10;" D9 y' n( M$ l8 D8 }. l
通过添加owner可以直接查询PITEM表
6 H @: v5 K5 [, }: _1 ~6 jPITEM_ID
! b1 `0 z) q& v( W--------------------------------------------------------------------------------
; h! U& F- c/ s0 ?6 k( F" y1 `000001
% x* r, F5 ~; `' s000002
& e" k. o# l- n) ^2 c* T000003
6 L$ x; d1 o, {# c( [- N000004; }7 h: F6 s$ d: S) l
000005$ n: L5 X3 x5 ?
000006
, _! q$ P' Q# M, q C( l8 f/ K% @0000076 T4 @. v# c/ q+ Z2 R6 V
000008
2 ~5 a! F+ f& d9 ~: ]; z9 |) F9 u' B000009" p7 }# F, N" W- v, W$ \. y
9 rows selected./ U; ?0 C( ? I7 x, D: m
为了方便,切换使用owner帐号登录,这样就可以直接查找了' Z1 y P; r1 |% ?/ v* g
SQL> conn7 O2 s5 s U7 Q, Z+ ]& W% Z
Enter user-name: TC_ADMINISTRATOR
( R$ R- G* h8 L' l* L) E6 `& R! m, FEnter password:3 {& a& J. H a
Connected.
g# }8 R1 M7 i: a0 p3 {SQL> select puid from PBOUNDINGBOX where rownum<10;
6 G+ W6 K; G9 D9 \, G4 aPUID3 u+ `: T) S; k9 B" T! Z, i1 e: j
---------------
& M9 @/ u/ W, w4 A* L% g( V5 eR7aJs_c24VSRuB
3 G3 {) w0 Y- L! H, h% b1 H+ i+ RxKWJfazn4VSRuB
7 H: E) i0 X9 V3 m" x" ^5 _+ QyUZJs_c24VSRuB# _ v0 M+ {6 R0 y+ N7 @1 z
设置linesize可以调整显示% x9 \. N- N1 I4 c8 |$ m
SQL> set linesize 2000, ?0 i: }9 o4 r6 D- n/ O
SQL> select * from PBOUNDINGBOX where rownum<10;
' o. d1 ?5 U; O2 @; SPUID PX_MIN PY_MIN PZ_MIN PX_MAX PY_MAX PZ_MAX RPARENTU RPARENTC. z# K' S8 r6 f
--------------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ----------
M7 [) m$ m( _R7aJs_c24VSRuB -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 R7UJs_c24VSRuB 59' L8 ]- ]& [9 k9 I/ y8 D
yUZJs_c24VSRuB -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 yUTJs_c24VSRuB 59' K3 g# u4 z, ^0 L: h
xKWJfazn4VSRuB 0 0 0 .1 .1 .1 xKQJfazn4VSRuB 590 x3 ]: k! H s4 O3 v3 J
+ k7 x1 _+ S G5 E2 L |
|