Kamsi's Blog

Kamsi's Blog

  • 분류 전체보기 (156) N
    • Database (25)
      • 공통 (2)
      • Oracle (14)
      • MySQL (2)
      • Tibero (1)
      • MSSql (0)
      • PostgreSQL (5)
    • JAVA (64)
      • Spring(eGovFrame) (25)
      • Spring Security (6)
      • Spring Boot (12)
      • iBatis(MyBatis) (0)
      • JSTL (1)
      • Tiles (1)
      • Webservice(REST) (8)
      • Common (5)
    • Eclipse (5)
    • Python (4) N
    • JavaScript (23)
      • NodeJS (13)
      • React (1)
    • PHP (1)
    • HTML5 (4)
    • CSS (7)
    • Kubernetes (3)
    • 정규식 (1)
    • 소스형상화 (6)
      • MAVEN (2)
      • ANT (1)
      • Gradle (1)
    • 기타 (4)
      • VirtualBox (1)
      • Excel (1)
  • HOME
  • TAG
  • MEDIA LOG
  • LOCATION LOG
  • GUEST BOOK
  • WRITE
RSS 피드
로그인
로그아웃 글쓰기 관리

Kamsi's Blog

컨텐츠 검색

태그

JWT websocket security chat SpringBoot Spring Boot spring webservice 노드js java config nodejs webflux SPRING4 schedule oracle Python 웹소켓 REACT restful 채팅

최근글

댓글

공지사항

아카이브

Database/공통(2)

  • DB별 insert후 자동 sequence Key 값을 가져오는 설정 방법

    MySql INSERT INTO CONTENT ( CREATED_DATE, TITLE, CONTENT, CONTENT_TYPE ) VALUES ( now(), #title#, #content#, #contentType# ) ]]> SELECT LAST_INSERT_ID() MSSQL INSERT INTO PRJ_INFO ( ... ) VALUES ( ... ) SELECT SCOPE_IDENTITY() Oracle SELECT message_id_seq.nextval FROM DUALINSERT INTO guestbook_message (message_id, guest_name, password, message) VALUES( #message_id#, #gName#, #pw#, #ms#)

    2015.04.23
  • DATABASE별 결과 값 RANDOM 으로 나오게 하기

    ORACLE SELECT * FROM TABLE_NAME SAMPLE (3)SELECT * FROM (SELECT * FROM TABLE_NAME ORDER BY DBMS_RANDOM.VALUE)WHERE ROWNUM < 3 MSSQLSELECT TOP 3 * FROM TABLE_NAME ORDER BY NEWID() MYSQLSELECT * FROM TABLE_NAME ORDER BY RAND() LIMIT 0,3

    2015.04.23
이전
1
다음
티스토리
© 2018 TISTORY. All rights reserved.

티스토리툴바