Oracle 기본 SQL
table list 보기
show create table
참조 : http://earlruby.org/2009/01/creating-auto-increment-columns-in-oracle/
clob handling mybatis
참조 : http://stove99.tistory.com/22
maven 설정
참조 : http://stove99.tistory.com/25
sqlplus 명령어
참조 : http://blog.naver.com/PostView.nhn?blogId=chansury&logNo=120046344870
너무 간만이라 @_@ 헷갈린다.
select * from tab;
show create table
set heading off;auto-increment
set echo off;
Set pages 999;
set long 90000;
spool ddl_list.sql
select dbms_metadata.get_ddl('TABLE','테이블 명','DB 명') from dual;
spool off;
참조 : http://earlruby.org/2009/01/creating-auto-increment-columns-in-oracle/
clob handling mybatis
참조 : http://stove99.tistory.com/22
maven 설정
참조 : http://stove99.tistory.com/25
sqlplus 명령어
참조 : http://blog.naver.com/PostView.nhn?blogId=chansury&logNo=120046344870
너무 간만이라 @_@ 헷갈린다.
댓글
댓글 쓰기