SELECT A.SID ,A.SERIAL# ,C.OBJECT_NAME

FROM V$SESSION A, V$LOCK B, DBA_OBJECTS C

WHERE A.SID  = B.SID  

    AND B.ID1  = C.OBJECT_ID

    AND B.TYPE = 'TM'

    AND C.OBJECT_NAME = '테이블명'

ALTER SYSTEM KILL SESSION 'SID, SERIAL#';

%ForEachTable() {
        COMMENT ON TABLE %TableName IS '%EntityName';
        %ForEachColumn() { 
                COMMENT ON COLUMN %TableName.%ColName IS '%AttName';
         }
}

SELECT

    A.TABLE_NAME

    , B.COMMENTS
FROM   ALL_TABLES A

        , ALL_TAB_COMMENTS B
WHERE  A.TABLE_NAME = B.TABLE_NAME
ORDER BY A.TABLE_NAME;

     A.OWNER

   , A.TABLE_NAME

   , A.COLUMN_ID

    , A.COLUMN_NAME

    , B.COMMENTS

    , A.DATA_TYPE

    , A.DATA_LENGTH

    , A.NULLABLE
FROM   ALL_TAB_COLUMNS A

     , ALL_COL_COMMENTS B
WHERE  A.TABLE_NAME = B.TABLE_NAME
      AND  A.COLUMN_NAME = B.COLUMN_NAME
      AND A.OWNER = 'SCOTT'      /*owner name*/
      AND A.TABLE_NAME = 'EMPLOY' /*table name*/
ORDER BY A.TABLE_NAME, A.COLUMN_ID