oralce 查询tc数据库一些技巧

admin

oralce 查询TC数据库一些技巧
C:\Users\Administrator>set oralce_sid=tc10;
设置oracle实例
0 U/ `* O5 m: A% gC:\Users\Administrator>sqplus/nolog
'sqplus' is not recognized as an internal or external command,
1 h5 E0 {" U$ a% p% u3 y" ]9 y) A- y$ Ooperable program or batch file.
C:\Users\Administrator>sqlplus/nolog
5 P- R; V* c2 A+ v* _: c0 W# qSQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 11 01:00:03 2014
" M5 p  v0 g1 _! ?2 N" c- j/ iCopyright (c) 1982, 2010, Oracle.  All rights reserved.
SQL> conn /as sysdba;
使用sysdba直接连接数据库
2 \# Q% J. f6 |+ oConnected.
SQL> select owner from dba_all_tables where table_name like '%PITEM%';
0 y9 p6 Z: }+ [1 ]查找出所有的dba表，找到tc的PITEM的这个表的owner
! A* F0 P) U, {. v3 \OWNER
------------------------------
TC_ADMINISTRATOR
TC_ADMINISTRATOR
TC_ADMINISTRATOR
TC_ADMINISTRATOR
+ Z3 r: D3 P5 X3 C2 tTC_ADMINISTRATOR
TC_ADMINISTRATOR
8 y0 s  j4 C6 `3 BTC_ADMINISTRATOR
+ S% U! y& R4 Q# U& j  eTC_ADMINISTRATOR
TC_ADMINISTRATOR
& b9 t7 Y$ N- A7 ]! D) @9 rows selected.
# x+ m8 m* [; s* S, VSQL> select pitem_id from TC_ADMINISTRATOR.PITEM where rownum<10;
; m6 X* w3 {3 i0 Y通过添加owner可以直接查询PITEM表
PITEM_ID
--------------------------------------------------------------------------------
$ M& e0 K9 P7 i9 ]& b0 m8 O' J000001
000002
- r5 w4 v" @5 d000003
000004
* E+ ^4 H9 c4 K; z1 I: @000005
0 C5 G- `7 \7 Y: }1 G0 `# m; Y000006
; U, x' d. y: W3 ~) T" \, V. J000007
000008
000009
9 rows selected.
为了方便，切换使用owner帐号登录，这样就可以直接查找了
  x( l9 s, m9 y" V; x( mSQL> conn
0 Q! D. x6 m- q) ~& ^Enter user-name: TC_ADMINISTRATOR
Enter password:
Connected.
SQL> select puid from PBOUNDINGBOX where rownum<10;
% M! X' ?" S6 v2 w% \( _PUID
2 g) L% M4 Z8 M---------------
& W6 m, _+ z4 k' C* Q3 R3 RR7aJs_c24VSRuB
4 f4 ?" B1 `2 @3 _/ d( e5 ^" g! pxKWJfazn4VSRuB
yUZJs_c24VSRuB
" B5 v8 \9 y4 Z6 [设置linesize可以调整显示
( {; I. A/ z2 {0 Y( d9 _: JSQL> set linesize 2000
SQL> select * from PBOUNDINGBOX where rownum<10;
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
& q3 W# @% z' c6 S' f% XyUZJs_c24VSRuB     -.08328 -.08708333 -.07975309 .194439264 .087083333 .260555556 yUTJs_c24VSRuB       59
0 L, P( ^5 W% f% }1 `xKWJfazn4VSRuB           0          0          0         .1         .1         .1 xKQJfazn4VSRuB       59

a150159

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