Life is Awesome!!!

SQL> select empno, ename, dname from emp natural join dept; EMPNO ENAME DNAME ---------- ---------- -------------- 7369 SMITH RESEARCH 7499 ALLEN SALES 7521 WARD SALES 7566 JONES RESEARCH 7654 MARTIN SALES 7698 BLAKE SALES 7782 CLARK ACCOUNTING EMPNO ENAME DNAME ---------- ---------- -------------- 7788 SCOTT RESEARCH 7839 KING ACCOUNTING 7844 TURNER SALES 7876 ADAMS RESEARCH 7900 JAMES SALES 79..

SQL> select * from t; MY_COLUMN ---------- 1234567890 1.2346E+12 1.2346E+19 SQL> set numformat 999999999999999999999999999999999999999.999999999999999999 문자열 개시 "9999999999..." 너무 깁니다. 최대 크기는 49 문자입니다. SQL> set numformat 9999999999999999999999999999999.999999999999999999 문자열 개시 "9999999999..." 너무 깁니다. 최대 크기는 49 문자입니다. SQL> set numformat 999999999999999999999999.9999999999 SQL> set numformat 9999..

SQL> set pagesize 10 SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE ---------- ---------- ---------- ---------- -------- - 7369 SMITH CLERK 7902 80/12/17 7499 ALLEN SALESMAN 7698 81/02/20 7521 WARD SALESMAN 7698 81/02/22 7566 JONES MANAGER 7839 81/04/02 7654 MARTIN SALESMAN 7698 81/09/28 7698 BLAKE MANAGER 7839 81/05/01 7782 CLARK MANAGER 7839 81/06/09 EMPNO ENAME JOB MGR HIREDATE --------..

SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- ---------- ---------- -------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 80/12/17 800 20 7499 ALLEN SALESMAN 7698 81/02/20 1600 300 30 7521 WARD SALESMAN 7698 81/02/22 1250 500 30 7566 JONES MANAGER 7839 81/04/02 2975 20 7654 MARTIN SALESMAN 7698 81/09/28 1250 1400 30 7698 BLAKE MANAGER 7839 8..

SQL> show sga Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes

오라클 끄기~ shutdown normal - 하던작업 완전 종료후 immediate - 현재 트랜젝션 종료후 디비 종료 abort - 현재작업 무시 바로 종료 (사고칠려면..) 오라클 켜기~ startup nomount mount open SQL> startup nomount ORACLE 인스턴스가 시작되었습니다. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes .... .. . alter database mount; - alter database open;

9i - http://IP_address/isqlplus 10g - http://IP_address:5560/isqlplus ㅋ

1.cmd창에서 sqlplus/nolog 2. conn/as sysdab (서버 컴퓨터에서만 적용됨....설마 모르는사람은 없겠죠?ㅋsysdba) 3. alter user scott identified by tiger account unlock; scott : lock 걸린 계정명 tiger : 사용할 암호

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 폴더의 listener.ora 파일에 hostname 을 컴퓨터이름으로 변경해주면~ 완료~>.

create table....나 alter table.... 나.. 위와같은 DDL 은 autocommit 이다.. transaction 시~ 생각을 좀 해둬야 할 사항들이다..