- Community Home
- >
- HPE Community, Taiwan
- >
- HP-UX
- >
- 系統管理
- >
- script 寫法二
系統管理
1753672
會員
5328
線上
108799
解決方案
論壇
類別
Company
Local Language
返回
論壇
討論平台
返回
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
部落格
信息
社區語言
語言
論壇
部落格
文章選項
- 訂閱此主題的RSS 提要
- 將此主題標記為未讀
- 將主題標記為已讀
- 將主題在本帳號置頂
- 標示為書籤
- 訂閱此主題
- 列印此頁
- 將文章標記為未讀
- 標示為書籤
- 訂閱此主題
- 靜音
- 訂閱此主題的RSS 提要
- 高亮顯示此文章
- 列印此文章
- 提報不當內容
在 08-13-2005 01:33 PM
在 08-13-2005 01:33 PM
script 寫法二
我的output 如下:
我要只要取,從SYSTEM開始往下7列,其他都不要,請問要怎樣寫比較好
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$tablespace;
NAME
------------------------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
LOGMNRTS
7 rows selected.
我要只要取,從SYSTEM開始往下7列,其他都不要,請問要怎樣寫比較好
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$tablespace;
NAME
------------------------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
LOGMNRTS
7 rows selected.
1則回覆 1
- 將文章標記為未讀
- 標示為書籤
- 訂閱此主題
- 靜音
- 訂閱此主題的RSS 提要
- 高亮顯示此文章
- 列印此文章
- 提報不當內容
在 08-13-2005 03:34 PM
在 08-13-2005 03:34 PM
script 寫法二
簡單的程式
================================================
#!/bin/ksh
TMP_FILE=/tmp/$$.TXT
`sqlplus -s username/passwd@XXXXX > ${TMP_FILE} << eof
set pagesize 0 linesize 2048 heading off
select name from v$tablespace;
exit
eof`
integer NSYSTEM=`grep -n "SYSTEM" ${TMP_FILE}|awk -F: '{print $1}'`
integer NEND=${NSYSTEM}+6
sed -n "${NSYSTEM}","${NEND}"p ${TMP_FILE}
rm -f ${TMP_FILE}
================================================
如果你的v$tablespace資料只有7筆的話, 只需要自sqlplus至eof就可以了. header會被濾掉.
================================================
#!/bin/ksh
TMP_FILE=/tmp/$$.TXT
`sqlplus -s username/passwd@XXXXX > ${TMP_FILE} << eof
set pagesize 0 linesize 2048 heading off
select name from v$tablespace;
exit
eof`
integer NSYSTEM=`grep -n "SYSTEM" ${TMP_FILE}|awk -F: '{print $1}'`
integer NEND=${NSYSTEM}+6
sed -n "${NSYSTEM}","${NEND}"p ${TMP_FILE}
rm -f ${TMP_FILE}
================================================
如果你的v$tablespace資料只有7筆的話, 只需要自sqlplus至eof就可以了. header會被濾掉.
以上表述為作者個人觀點,不代表惠普公司,使用本網站,請遵守網站使用規則和條款
© 版权所有 2024 慧与发展有限责任合伙企业