반응형 오라클 게시판/오라클(Oracle)14 오라클(Oracle) 테이블 용량 및 칼럼 정보 확인 1. tablespace조회 select file_name,tablespace_name from dba_data_files; 2. tablespace의 segment조회 select SEGMENT_NAME,TABLESPACE_NAME,BYTES, ROUND(BYTES /1024/1024,2) from dba_segments WHERE TABLESPACE_NAME ='EIS' ORDER BY BYTES DESC; --Table_Size 조회 select segment_name ,TO_NUMBER(sum(bytes))/1024/1024 from user_extents GROUP BY segment_name 3. 계정체크 SELECT USERNAME, ACCOUNT_STATUS, TO_CHAR(LOCK_DAT.. 2011. 1. 4. 오라클에서 난수 발생하기 오라클에서 난수 발생하기 Below are some examples of using the package. E.g.: Generating a random number (positive or negative) SQL> select dbms_random.random from dual; RANDOM _____________ 1393936551 E.g.: Generating a random number between 0 and 1. SQL> select dbms_random.value from dual; VALUE _____________ 1 E.g.: Generating a random number from a range, between 1 to 1000. SQL> select dbms_random.value.. 2011. 1. 4. 이전 1 2 다음 반응형
