쿼리문 간단 정리 (2006.03.15 )

예전 카페에서 폐지 공지가 와서 자료를 옮겨 놓습니다.

 

<<<<<<<<<<<<<<<< Any >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
select ~ from ~ where ~ 컬럼 = any ( select 문장 )
select ~ from ~ where ~ not 컬럼 = any ( select 문장 )
 
select usmo, usmame, usrarea
   from forumusrlist
 where usrkindcode = any (select kindcode from forumtbl );
 
<<<<<<<<<<<<<<<< Exists >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
select ~ from ~ where ~ exists ( select문장 )
 
select usmo. usmame fromforumusrlist
 where exists (select * from forumtb );
 
<<<<<<<<<<<<<<<< Some >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
select ~ from ~ where ~ 컬럼 = some ( select 문장 )
 
<<<<<<<<<<<<<<<< Case>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
select
(case 필드명
when 1 then '01'
 else '02'
 end) as pcard_stat
from table_name
<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
CREATE TABLE test
(
  MEMBER_ID       VARCHAR2(20 BYTE)             NOT NULL,
  REGIST_DTIME    VARCHAR2(14 BYTE),
  CCC_WEB_ID      VARCHAR2(20 BYTE),
  CCC_WEB_PASSWD  VARCHAR2(45 BYTE)
)

ALTER TABLE test RENAME COLUMN CCC_WEB_ID TO WEB_ID
ALTER TABLE test RENAME COLUMN CCC_WEB_PASSWD TO WEB_PASSWD
 
ALTER TABLE test  drop column REGIST_DTIME;