shell Script를 이용한 오라클 사용

본문

shell Script를 이용한 오라클 사용

[kang@dev2 kang]$ cat test.sh #!/bin/sh # This script comes from dbakorea.pe.kr. # made by kang myung gyu # Oracle계정 지정 ORACLE_ACCOUNT="sqlplus -s scott/tiger" # 질의한 결과를 저장할 파일 지정 REPORT_FILE=`date +%Y%m%d`.txt # 질의문 QUERY="select tname, tabtype from tab;" # 오라클 질의 실행 { echo set linesize 400 echo set pagesize 500 echo col mem_name format a10 echo col mem_email format a30 echo col mem_addr_detail format a30 echo prompt [$ORACLE_ACCOUNT가 소유한 테이블목록] echo ${QUERY} } | ${ORACLE_ACCOUNT} > ${REPORT_FILE} [kang@dev2 kang]$ chmod 700 test.sh [kang@dev2 kang]$ ./test.sh [kang@dev2 kang]$ cat 20020208.txt [sqlplus -s scott/tiger가 소유한 테이블목록] TNAME                          TABTYPE ------------------------------ ------- BONUS                          TABLE CHICKEN                        TABLE DEPT                           TABLE DES_TEST                       TABLE DUMMY                          TABLE EGG                            TABLE EMP                            TABLE EXT_TEST                       TABLE FIX_TABLE                      TABLE FLIGHT_SCHEDULE                TABLE HMC_DOC                        TABLE INSERT_TEST                    TABLE IOT_TEST                       TABLE JOB_TEST                       TABLE MEM1                           TABLE MEM2                           TABLE MEM3                           TABLE PLAN_TABLE                     TABLE SALGRADE                       TABLE SHOP_RECORD                    TABLE STUDENT                        TABLE S_CUSTOMER                     TABLE S_DEPT                         TABLE S_EMP                          TABLE S_IMAGE                        TABLE S_INVENTORY                    TABLE S_ITEM                         TABLE S_LONGTEXT                     TABLE S_ORD                          TABLE S_PRODUCT                      TABLE S_REGION                       TABLE S_TITLE                        TABLE S_WAREHOUSE                    TABLE TBLMESSAGE                     TABLE TEMP_TABLE                     TABLE TEST                           TABLE TEST_TMP                       TABLE T_SMS_IN_LOG                   TABLE VAR_TABLE                      TABLE V_MEM                          VIEW X                              TABLE 41 rows selected. [kang@dev2 kang]$ This article comes from dbakorea.pe.kr (Leave this line as is)

관련자료

• 이전
  자동증가컬럼 사용

  작성일 2005.04.13 03:41
• 다음
  윈도에서의 오라클9i 아키텍처

  작성일 2005.04.13 03:39