1000명의 회원 목록을 데이터베이스 실습 데이터로 드립니다. {유목민 알폰스}

회원 1000명에 대한 DB 실습용 데이터를 테스트용으로 드립니다.

샘플 100명의 데이터 입니다. 자료를 다운로드 하시면 더 많은 목록들이 있고 종류는

insert문 TXT버전과 엑셀표 xls버전 입니다. 

 

※ 이 자료는 불법적인 개인정보가 아닙니다. 무작위로 생성한 테스트 데이터입니다.

REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM527','채','현우','M',82,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM528','마','도하','M',52,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM529','홍','준서','M',40,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM530','김','지훈','M',85,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM531','박','서우','M',42,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM532','이','이든','M',22,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM533','송','지한','M',98,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM534','진','이현','M',85,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM535','권','다온','M',63,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM536','우','은호','M',45,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM537','전','정우','M',72,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM538','성','유찬','M',67,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM539','민','하진','M',88,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM540','정','시온','M',49,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM541','곽','하온','M',16,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM542','지','지우','M',40,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM543','서','하민','M',29,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM544','조','시안','M',65,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM545','손','주안','M',56,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM546','장','시현','M',31,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM547','강','한결','M',57,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM548','노','승우','M',45,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM549','차','시후','M',69,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM550','고','도율','M',95,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM551','하','율','M',74,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM552','황','민재','M',71,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM553','윤','재윤','M',76,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM554','원','하율','M',53,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM555','최','태오','M',24,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM556','채','지오','M',28,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM557','마','지환','M',84,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM558','홍','태윤','M',45,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM559','김','도겸','M',68,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM560','박','윤호','M',91,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM561','이','수현','M',87,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM562','송','라온','M',91,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM563','진','진우','M',43,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM564','권','단우','M',98,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM565','우','윤재','M',80,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM566','전','준','M',38,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM567','성','지율','M',65,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM568','민','도경','M',42,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM569','정','로이','M',39,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM570','곽','우빈','M',33,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM571','지','시원','M',35,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM572','서','하람','M',42,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM573','조','유안','M',100,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM574','손','현준','M',52,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM575','장','서후','M',59,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM576','강','도준','M',75,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM577','노','하늘','M',99,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM578','차','시율','M',29,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM579','고','태양','M',63,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM580','하','하랑','M',41,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM581','황','시완','M',50,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM582','윤','지원','M',56,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM583','원','지민','M',23,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM584','최','도훈','M',16,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM585','채','은찬','M',37,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM586','마','주호','M',53,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM587','홍','재이','M',37,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM588','김','이한','M',81,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM589','박','재하','M',30,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM590','이','승현','M',30,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM591','송','민호','M',35,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM592','진','도원','M',59,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM593','권','윤','M',58,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM594','우','건','M',30,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM595','전','아인','M',46,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM596','성','민찬','M',82,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM597','민','정후','M',64,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM598','정','시환','M',81,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM599','곽','재원','M',94,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM600','지','민우','M',82,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM601','서','서호','M',50,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM602','조','도영','M',79,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM603','손','시훈','M',73,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM604','장','준혁','M',69,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM605','강','서율','M',47,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM606','노','예성','M',32,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM607','차','온유','M',46,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM608','고','은성','M',75,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM609','하','건후','M',68,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM610','황','승민','M',73,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM611','윤','현','M',56,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM612','원','태준','M',33,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM613','최','준희','M',87,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM614','채','서원','M',77,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM615','마','리안','M',93,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM616','홍','태민','M',23,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM617','김','규민','M',44,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM618','박','지완','M',66,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM619','이','태하','M',78,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM620','송','강민','M',96,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM621','진','재현','M',55,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM622','권','재민','M',87,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM623','우','유건','M',87,to_date('23/07/10','RR/MM/DD'),null);
Insert into EXPORT_TABLE (MEM_ID, SUR_NAME, GIVEN_NAME, SEX, AGE, CDT, UDT) values ('MEM624','전','재율','M',84,to_date('23/07/10','RR/MM/DD'),null);

 

엑셀데이터 샘플

 

 

By. 유목민 알폰스 - Alphonse Elric