Database/SQL

SQL :: CMD :: Tip :: 커맨드상에서 name라인 줄이기

Dongkkase 2008. 11. 20. 15:38
반응형
 C:\Documents and Settings\Administrator>cd\

C:\>net start OracleServiceorcl
OracleServiceORCL 서비스를 시작합니다.....................
OracleServiceORCL 서비스가 잘 시작되었습니다.


C:\>sqlplus "sys/tiger as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 목 11월 20 14:05:15 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


다음에 접속됨:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> show user
USER은 "SYS"입니다

SQL> select instance_name, host_name, status
     2  from v$instance;


    INSTANCE_NAME
    ----------------
    HOST_NAME                                                                     STATUS
    ------------------------------------------------------------- ------------
    orcl
    Z                                                                                     OPEN

SQL> col  INSTANCE_NAME format a10
SQL> col HOST_NAME format a10



SQL> select instance_name, host_name, status
       2  from v$instance;

    INSTANCE_N HOST_NAME   STATUS
    ------------ ------------- ------------
    orcl             Z                  OPEN



반응형