맥으로 오라클 쓰기 정말 힘들다!

일단 오라클 자체는 여러 블로그를 뒤적거리며 어찌저찌 깔았다.

그리고 그보다 심한 난관은 바로.. 수업을 위해 새로운 계정을 생성하는 것이었다..!!!!

 

scott계정은 워낙 흔하게 쓰여서인지 버전 상관없이 그나마 쉽게 생성했지만

hr 계정인가 oe 계정인가는.. 대체 어떻게 깔라는건지 블로그를 봐도 뭐가 하나도 안됐다.

이것땜에 주말 내내 계속 끙끙거렸는데 오늘 드디어 강사님과 합심해 해결했다!!!!! 

 

나처럼 블로그 이곳저곳을 뒤지고, 따라해봐도 뭐가 안되고, 모르겠는 생초보를 위해 자료도 공유하고 나도 정리해둘겸 글을 쓴다.

 

일단, 오라클 설치는 다른 블로그가 정말 친절하고 똑똑하게 잘 알려주니 다른 블로그를 참고할 것.

나도 실행하다 가끔 무한로딩 걸리고 안켜지고 그런다.. 그럴 땐 다시

 

[MacOS] M1 맥북 도커로 ORACLE DB 실행하기

Intro M1 맥북을 처음 구입 한 이후로 약 1년 반동안, 오라클 데이터베이스를 띄우기 위해 참 많은 노력을 했었습니다. 원래부터 Oracle이 MacOS를 정식 지원을 하지는 않았지만, 그나마 이전의 맥북에

shanepark.tistory.com

이 분의 블로그에 들어가 보곤 한다.

댓글에도 나와 비슷한 문제를 겪는 분이 많아 도움이 꽤 된다!

 

 

새로운 계정을 만들기 위해서는

 

[ORACLE] 2탄. 맥북 M1 docker를 활용한 HR세팅

#oracle #M1 #docker 배경 오라클DB는 M1의 경우 도커위에서 실행하기 때문에 hr 계정을 찾으면 찾을 ...

blog.naver.com

이분의 블로그를 참고했다. 

 

잘 따라한 건 아니고.. 저장된 루트가 달라서 (그리고 모르겠음 사실) 터미널에 나오는데로 한건데ㅠ 왜 이 분이 알려주신 것과 다른지..

암튼 오라클이 저장된 루트를 따라 어찌저찌 스키마 샘플파일들을 오라클에 저장하는 것까지는 성공했지만 그 뒤로 파일이 영원히 열리지 않았다.. 루트의 문제인것 같은데 이틀동안 해결을 못했었다.

 

저거 말고도 여러 방법의 명령어를 썼지만.. 안됐고 내가 결국 oe 계정을 만들었던 방법은

순수 노가다였다. 

 

일단 오라클 디벨로퍼를 열고 시스템 계정에 들어간다.

 

create user oe identified by oe account unlock;
grant connect,resource to oe;

그 후 하나씩 실행시켜주면 oe 계정이 생성된다. 

'grant connect,resource to oe;' 는 권한을 부여해주는 구문이다. 

 

그리고 실행문에 내가 포함해두지 않은 

'alter user oe quota 30M on users;'는 oe 계정에서 테이블을 생성할때 크기를 정하는 구문이다. 

이건 user 권한이 없다는 오류가 뜨면 넣어주고, 아니면 필수로 넣지 않아도 된다!

 

다 됐으면 왼쪽 상단의 접속 아래 있는 초록 + 버튼을 눌러 oe 계정을 만들어준다.

난 이름, 사용자이름, 비번까지 다 oe 로 통일했다.

그리고 맥은 꼭 SID(I)를 xe로 해둬야 한다!!

 

이렇게 하면 oe 계정이 무사히 만들어지는데 

여기에 테이블을 만들고 한 행씩.. 데이터를 집어 넣으면 된다.

진짜 오늘 하루 내가 고생해서 하나하나 다 편집한.... 쿼리구문ㅠㅠ 강사님도 오류 뜨면 함께 봐주시느라 고생하셨다.. 

drop table CUSTOMERS;



CREATE TABLE  CUSTOMERS  
   (CUSTOMER_ID  NUMBER(6,0), 
    CUST_FIRST_NAME  VARCHAR2(20 BYTE), 
    CUST_LAST_NAME  VARCHAR2(20 BYTE) , 
   
    NLS_LANGUAGE  VARCHAR2(3 BYTE), 
    NLS_TERRITORY  VARCHAR2(30 BYTE), 
    CREDIT_LIMIT  NUMBER(9,2), 
    CUST_EMAIL  VARCHAR2(30 BYTE), 
    ACCOUNT_MGR_ID  NUMBER(6,0), 
   
    DATE_OF_BIRTH  DATE, 
    MARITAL_STATUS  VARCHAR2(20 BYTE), 
    GENDER  VARCHAR2(1 BYTE), 
    INCOME_LEVEL  VARCHAR2(20 BYTE)
);

 

일단 이렇게 CUSTOMERS 테이블 만들기

 

Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (242,'Mary','Lemmon','us','AMERICA',2400,'Mary.Lemmon@PUFFIN.COM',145,to_date('62/07/18','RR/MM/DD'),'married','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (240,'Malcolm','Kanth','us','AMERICA',2400,'Malcolm.Kanth@PIPIT.COM',145,to_date('55/06/19','RR/MM/DD'),'married','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (241,'Malcolm','Broderick','us','AMERICA',2400,'Malcolm.Broderick@PLOVER.COM',145,to_date('52/06/28','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (242,'Mary','Lemmon','us','AMERICA',2400,'Mary.Lemmon@PUFFIN.COM',145,to_date('62/07/18','RR/MM/DD'),'married','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (243,'Mary','Collins','us','AMERICA',2400,'Mary.Collins@PYRRHULOXIA.COM',145,to_date('55/08/18','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (244,'Matt','Gueney','us','AMERICA',2400,'Matt.Gueney@REDPOLL.COM',145,to_date('52/08/27','RR/MM/DD'),'single','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (245,'Max','von Sydow','us','AMERICA',2400,'Max.vonSydow@REDSTART.COM',145,to_date('67/09/07','RR/MM/DD'),'single','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (246,'Max','Schell','us','AMERICA',2400,'Max.Schell@SANDERLING.COM',145,to_date('84/09/16','RR/MM/DD'),'married','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (247,'Cynda','Whitcraft','us','AMERICA',2400,'Cynda.Whitcraft@SANDPIPER.COM',145,to_date('54/10/16','RR/MM/DD'),'married','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (248,'Donald','Minnelli','us','AMERICA',2400,'Donald.Minnelli@SCAUP.COM',145,to_date('53/10/26','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (249,'Hannah','Broderick','us','AMERICA',2400,'Hannah.Broderick@SHRIKE.COM',145,to_date('75/11/16','RR/MM/DD'),'married','M','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (250,'Dan','Williams','us','AMERICA',2400,'Dan.Williams@SISKIN.COM',145,to_date('84/11/25','RR/MM/DD'),'single','M','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (251,'Raul','Wilder','us','AMERICA',2500,'Raul.Wilder@STILT.COM',145,to_date('45/12/15','RR/MM/DD'),'married','M','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (252,'Shah Rukh','Field','us','AMERICA',2500,'ShahRukh.Field@WHIMBREL.COM',145,to_date('57/12/25','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (253,'Sally','Bogart','us','AMERICA',2500,'Sally.Bogart@WILLET.COM',145,to_date('85/01/14','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (254,'Bruce','Bates','us','AMERICA',3500,'Bruce.Bates@COWBIRD.COM',145,to_date('40/01/25','RR/MM/DD'),'single','M','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (255,'Brooke','Shepherd','us','AMERICA',3500,'Brooke.Shepherd@KILLDEER.COM',145,to_date('85/02/13','RR/MM/DD'),'married','M','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (256,'Ben','de Niro','us','AMERICA',3500,'Ben.deNiro@KINGLET.COM',145,to_date('80/02/24','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (257,'Emmet','Walken','us','AMERICA',3600,'Emmet.Walken@LIMPKIN.COM',145,to_date('75/03/15','RR/MM/DD'),'married','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (258,'Ellen','Palin','us','AMERICA',3600,'Ellen.Palin@LONGSPUR.COM',145,to_date('77/04/14','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (259,'Denholm','von Sydow','us','AMERICA',3600,'Denholm.vonSydow@MERGANSER.COM',145,to_date('43/04/24','RR/MM/DD'),'single','F','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (260,'Ellen','Khan','us','AMERICA',3600,'Ellen.Khan@VERDIN.COM',149,to_date('62/05/14','RR/MM/DD'),'married','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (262,'Fred','Reynolds','us','AMERICA',3600,'Fred.Reynolds@WATERTHRUSH.COM',149,to_date('58/07/13','RR/MM/DD'),'married','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (263,'Fred','Lithgow','us','AMERICA',3600,'Fred.Lithgow@WHIMBREL.COM',149,to_date('79/07/23','RR/MM/DD'),'single','M','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (264,'George','Adjani','us','AMERICA',3600,'George.Adjani@WILLET.COM',149,to_date('47/08/12','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (265,'Irene','Laughton','us','AMERICA',3600,'Irene.Laughton@ANHINGA.COM',149,to_date('73/08/22','RR/MM/DD'),'single','F','J: 190,000 - 249,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (267,'Prem','Walken','us','AMERICA',3700,'Prem.Walken@BRANT.COM',145,to_date('53/09/11','RR/MM/DD'),'married','F','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (268,'Kyle','Schneider','us','AMERICA',3700,'Kyle.Schneider@DUNLIN.COM',145,to_date('52/09/21','RR/MM/DD'),'single','F','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (269,'Kyle','Martin','us','AMERICA',3700,'Kyle.Martin@EIDER.COM',145,to_date('58/10/11','RR/MM/DD'),'married','F','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (271,'Shelley','Peckinpah','us','AMERICA',3700,'Shelley.Peckinpah@GODWIT.COM',145,to_date('87/11/20','RR/MM/DD'),'single','F','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (272,'Prem','Garcia','us','AMERICA',3700,'Prem.Garcia@JACANA.COM',145,to_date('60/12/10','RR/MM/DD'),'married','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (273,'Bo','Hitchcock','us','AMERICA',5000,'Bo.Hitchcock@ANHINGA.COM',145,to_date('54/01/09','RR/MM/DD'),'married','M','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (274,'Bob','McCarthy','us','AMERICA',5000,'Bob.McCarthy@ANI.COM',149,to_date('46/01/19','RR/MM/DD'),'single','M','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (276,'Dom','Hoskins','us','AMERICA',5000,'Dom.Hoskins@AVOCET.COM',149,to_date('51/03/10','RR/MM/DD'),'married','M','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (277,'Don','Siegel','us','AMERICA',5000,'Don.Siegel@BITTERN.COM',149,to_date('50/03/20','RR/MM/DD'),'single','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (278,'Gvtz','Bradford','us','AMERICA',5000,'Gvtz.Bradford@BULBUL.COM',149,to_date('64/04/08','RR/MM/DD'),'married','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (280,'Rob','MacLaine','us','AMERICA',5000,'Rob.MacLaine@COOT.COM',149,to_date('49/05/09','RR/MM/DD'),'married','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (281,'Don','Barkin','us','AMERICA',5000,'Don.Barkin@CORMORANT.COM',149,to_date('56/05/18','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (282,'Kurt','Danson','us','AMERICA',5000,'Kurt.Danson@COWBIRD.COM',145,to_date('88/06/07','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (308,'Glenda','Dunaway','zhs','CHINA',1200,'Glenda.Dunaway@DOWITCHER.COM',148,to_date('57/07/08','RR/MM/DD'),'married','M','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (309,'Glenda','Bates','zhs','CHINA',1200,'Glenda.Bates@DIPPER.COM',148,to_date('55/07/18','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (323,'Goetz','Falk','hi','INDIA',5000,'Goetz.Falk@VEERY.COM',148,to_date('80/08/06','RR/MM/DD'),'married','F','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (326,'Hal','Olin','d','GERMANY',2400,'Hal.Olin@FLICKER.COM',147,to_date('59/09/06','RR/MM/DD'),'married','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (327,'Hannah','Kanth','d','GERMANY',2400,'Hannah.Kanth@GADWALL.COM',147,to_date('56/09/15','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (328,'Hannah','Field','d','GERMANY',2400,'Hannah.Field@GALLINULE.COM',147,to_date('85/10/06','RR/MM/DD'),'married','F','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (333,'Margret','Powell','i','ITALY',1200,'Margret.Powell@ANI.COM',147,to_date('53/10/16','RR/MM/DD'),'single','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (334,'Harry Mean','Taylor','us','AMERICA',1200,'HarryMean.Taylor@REDPOLL.COM',147,to_date('81/11/15','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (335,'Margrit','Garner','i','ITALY',500,'Margrit.Garner@STILT.COM',147,to_date('82/12/05','RR/MM/DD'),'married','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (337,'Maria','Warden','i','ITALY',500,'Maria.Warden@TANAGER.COM',147,to_date('73/01/03','RR/MM/DD'),'married','F','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (339,'Marilou','Landis','i','ITALY',500,'Marilou.Landis@TATTLER.COM',147,to_date('33/01/13','RR/MM/DD'),'single','M','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (361,'Marilou','Chapman','i','ITALY',500,'Marilou.Chapman@TEAL.COM',147,to_date('89/08/11','RR/MM/DD'),'single','F','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (363,'Kathy','Lambert','i','ITALY',2400,'Kathy.Lambert@COOT.COM',147,to_date('56/08/31','RR/MM/DD'),'married','M','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (360,'Helmut','Capshaw','zhs','CHINA',3600,'Helmut.Capshaw@TROGON.COM',148,to_date('77/08/01','RR/MM/DD'),'married','M','J: 190,000 - 249,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (341,'Keir','George','i','ITALY',700,'Keir.George@VIREO.COM',147,to_date('63/02/03','RR/MM/DD'),'married','F','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (342,'Marlon','Laughton','i','ITALY',2400,'Marlon.Laughton@CORMORANT.COM',147,to_date('47/02/13','RR/MM/DD'),'single','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (343,'Keir','Chandar','i','ITALY',700,'Keir.Chandar@WATERTHRUSH.COM',147,to_date('60/03/04','RR/MM/DD'),'married','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (344,'Marlon','Godard','ja','JAPAN',2400,'Marlon.Godard@MOORHEN.COM',148,to_date('60/03/14','RR/MM/DD'),'single','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (345,'Keir','Weaver','i','ITALY',700,'Keir.Weaver@WHIMBREL.COM',147,to_date('62/04/04','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (346,'Marlon','Clapton','i','ITALY',2400,'Marlon.Clapton@COWBIRD.COM',147,to_date('88/04/13','RR/MM/DD'),'married','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (347,'Kelly','Quinlan','i','ITALY',3600,'Kelly.Quinlan@PYRRHULOXIA.COM',147,to_date('29/05/03','RR/MM/DD'),'married','F','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (348,'Kelly','Lange','i','ITALY',3600,'Kelly.Lange@SANDPIPER.COM',147,to_date('71/05/14','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (349,'Ken','Glenn','i','ITALY',3600,'Ken.Glenn@SAW-WHET.COM',147,to_date('67/06/03','RR/MM/DD'),'married','M','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (350,'Ken','Chopra','i','ITALY',3600,'Ken.Chopra@SCAUP.COM',147,to_date('51/06/13','RR/MM/DD'),'single','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (351,'Ken','Wenders','i','ITALY',3600,'Ken.Wenders@REDPOLL.COM',147,to_date('62/07/03','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (380,'Meryl','Holden','hi','INDIA',3700,'Meryl.Holden@DIPPER.COM',148,to_date('61/10/10','RR/MM/DD'),'single','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (447,'Richard','Coppola','i','ITALY',500,'Richard.Coppola@SISKIN.COM',147,to_date('81/10/30','RR/MM/DD'),'married','F','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (449,'Rick','Romero','i','ITALY',1500,'Rick.Romero@LONGSPUR.COM',147,to_date('51/12/10','RR/MM/DD'),'single','F','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (450,'Rick','Lyon','i','ITALY',1500,'Rick.Lyon@MERGANSER.COM',147,to_date('41/01/01','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (451,'Ridley','Hackman','i','ITALY',700,'Ridley.Hackman@ANHINGA.COM',147,to_date('50/01/11','RR/MM/DD'),'single','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (453,'Ridley','Young','hi','INDIA',700,'Ridley.Young@CHUKAR.COM',148,to_date('45/02/10','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (454,'Rob','Russell','hi','INDIA',5000,'Rob.Russell@VERDIN.COM',148,to_date('77/03/02','RR/MM/DD'),'married','M','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (458,'Robert','de Niro','hi','INDIA',3700,'Robert.deNiro@DOWITCHER.COM',148,to_date('86/03/12','RR/MM/DD'),'single','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (466,'Rodolfo','Hershey','hi','INDIA',5000,'Rodolfo.Hershey@VIREO.COM',148,to_date('47/04/11','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (467,'Rodolfo','Dench','hi','INDIA',5000,'Rodolfo.Dench@SCOTER.COM',148,to_date('71/05/01','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (470,'Roger','Mastroianni','hi','INDIA',3700,'Roger.Mastroianni@CREEPER.COM',148,to_date('67/05/31','RR/MM/DD'),'married','M','L: 300,000 and above');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (473,'Rolf','Ashby','hi','INDIA',5000,'Rolf.Ashby@WATERTHRUSH.COM',148,to_date('49/06/10','RR/MM/DD'),'single','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (474,'Romy','Sharif','hi','INDIA',5000,'Romy.Sharif@SNIPE.COM',148,to_date('76/06/29','RR/MM/DD'),'married','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (476,'Rosanne','Hopkins','hi','INDIA',300,'Rosanne.Hopkins@ANI.COM',148,to_date('79/07/30','RR/MM/DD'),'married','M','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (477,'Rosanne','Douglas','hi','INDIA',300,'Rosanne.Douglas@ANHINGA.COM',148,to_date('70/08/09','RR/MM/DD'),'single','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (478,'Rosanne','Baldwin','hi','INDIA',300,'Rosanne.Baldwin@AUKLET.COM',148,to_date('67/08/29','RR/MM/DD'),'married','F','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (480,'Roxanne','Michalkow','hi','INDIA',1200,'Roxanne.Michalkow@EIDER.COM',148,to_date('73/09/18','RR/MM/DD'),'single','M','L: 300,000 and above');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (481,'Roy','Hulce','hi','INDIA',5000,'Roy.Hulce@SISKIN.COM',148,to_date('67/09/28','RR/MM/DD'),'married','F','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (482,'Roy','Dunaway','hi','INDIA',5000,'Roy.Dunaway@WHIMBREL.COM',148,to_date('55/10/28','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (487,'Rufus','Dvrrie','hi','INDIA',1900,'Rufus.Dvrrie@PLOVER.COM',148,to_date('60/11/26','RR/MM/DD'),'married','M','J: 190,000 - 249,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (488,'Rufus','Belushi','hi','INDIA',1900,'Rufus.Belushi@PUFFIN.COM',148,to_date('52/12/26','RR/MM/DD'),'married','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (492,'Sally','Edwards','hi','INDIA',2500,'Sally.Edwards@TURNSTONE.COM',148,to_date('80/01/06','RR/MM/DD'),'married','F','K: 250,000 - 299,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (101,'Constantin','Welles','us','AMERICA',100,'Constantin.Welles@ANHINGA.COM',145,to_date('72/02/20','RR/MM/DD'),'married','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (102,'Harrison','Pacino','us','AMERICA',100,'Harrison.Pacino@ANI.COM',145,to_date('53/03/02','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (103,'Manisha','Taylor','us','AMERICA',100,'Manisha.Taylor@AUKLET.COM',145,to_date('83/03/22','RR/MM/DD'),'married','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (104,'Harrison','Sutherland','us','AMERICA',100,'Harrison.Sutherland@GODWIT.COM',145,to_date('72/03/31','RR/MM/DD'),'single','F','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (105,'Matthias','MacGraw','us','AMERICA',100,'Matthias.MacGraw@GOLDENEYE.COM',145,to_date('69/04/21','RR/MM/DD'),'married','F','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (106,'Matthias','Hannah','us','AMERICA',100,'Matthias.Hannah@GREBE.COM',145,to_date('60/04/30','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (107,'Matthias','Cruise','us','AMERICA',100,'Matthias.Cruise@GROSBEAK.COM',145,to_date('69/05/21','RR/MM/DD'),'married','F','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (108,'Meenakshi','Mason','us','AMERICA',100,'Meenakshi.Mason@JACANA.COM',145,to_date('57/06/20','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (109,'Christian','Cage','us','AMERICA',100,'Christian.Cage@KINGLET.COM',145,to_date('38/06/30','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (110,'Charlie','Sutherland','us','AMERICA',200,'Charlie.Sutherland@LIMPKIN.COM',145,to_date('51/07/20','RR/MM/DD'),'married','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (111,'Charlie','Pacino','us','AMERICA',200,'Charlie.Pacino@LONGSPUR.COM',145,to_date('48/07/29','RR/MM/DD'),'single','M','G: 130,000 - 149,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (112,'Guillaume','Jackson','us','AMERICA',200,'Guillaume.Jackson@MOORHEN.COM',145,to_date('54/08/19','RR/MM/DD'),'married','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (113,'Daniel','Costner','us','AMERICA',200,'Daniel.Costner@PARULA.COM',145,to_date('77/08/29','RR/MM/DD'),'single','M','I: 170,000 - 189,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (114,'Dianne','Derek','us','AMERICA',200,'Dianne.Derek@SAW-WHET.COM',145,to_date('48/09/17','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (115,'Geraldine','Schneider','us','AMERICA',200,'Geraldine.Schneider@SCAUP.COM',145,to_date('31/10/18','RR/MM/DD'),'married','M','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (116,'Geraldine','Martin','us','AMERICA',200,'Geraldine.Martin@SCOTER.COM',145,to_date('27/10/28','RR/MM/DD'),'single','M','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (117,'Guillaume','Edwards','us','AMERICA',200,'Guillaume.Edwards@SHRIKE.COM',145,to_date('52/11/16','RR/MM/DD'),'married','M','E: 90,000 - 109,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (118,'Maurice','Mahoney','us','AMERICA',200,'Maurice.Mahoney@SNIPE.COM',145,to_date('66/11/27','RR/MM/DD'),'single','M','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (120,'Diane','Higgins','us','AMERICA',200,'Diane.Higgins@TANAGER.COM',145,to_date('84/12/26','RR/MM/DD'),'single','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (121,'Dianne','Sen','us','AMERICA',200,'Dianne.Sen@TATTLER.COM',145,to_date('53/01/15','RR/MM/DD'),'married','M','H: 150,000 - 169,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (122,'Maurice','Daltrey','us','AMERICA',200,'Maurice.Daltrey@TEAL.COM',145,to_date('43/02/15','RR/MM/DD'),'married','M','A: Below 30,000');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (123,'Elizabeth','Brown','us','AMERICA',200,'Elizabeth.Brown@THRASHER.COM',145,to_date('49/02/24','RR/MM/DD'),'single','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (125,'Dianne','Andrews','us','AMERICA',200,'Dianne.Andrews@TURNSTONE.COM',145,to_date('59/03/27','RR/MM/DD'),'single','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (126,'Charles','Field','us','AMERICA',300,'Charles.Field@BECARD.COM',145,to_date('46/04/16','RR/MM/DD'),'married','F','F: 110,000 - 129,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (127,'Charles','Broderick','us','AMERICA',300,'Charles.Broderick@BITTERN.COM',145,to_date('43/04/26','RR/MM/DD'),'single','F','B: 30,000 - 49,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (129,'Louis','Jackson','us','AMERICA',400,'Louis.Jackson@CARACARA.COM',145,to_date('39/05/26','RR/MM/DD'),'single','M','D: 70,000 - 89,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (130,'Louis','Edwards','us','AMERICA',400,'Louis.Edwards@CHACHALACA.COM',145,to_date('44/06/14','RR/MM/DD'),'married','M','C: 50,000 - 69,999');
Insert into CUSTOMERS (CUSTOMER_ID,CUST_FIRST_NAME,CUST_LAST_NAME,NLS_LANGUAGE,NLS_TERRITORY,CREDIT_LIMIT,CUST_EMAIL,ACCOUNT_MGR_ID,DATE_OF_BIRTH,MARITAL_STATUS,GENDER,INCOME_LEVEL) values (131,'Doris','Dutt','us','AMERICA',400,'Doris.Dutt@CHUKAR.COM',145,to_date('76/07/14','RR/MM/DD'),'married','F','C: 50,000 - 69,999');

사실 여기에 한줄이 빠졌다.. 강사님이 그렇게 주심;

근데 실습하다보면 버전차이인지 조금씩 다르기도 해서 크게 상관없을 듯 해 그냥 킵고잉

 

저걸 다 복붙해서 드레그 한 후 실행하면 '1행이 추가되었습니다' 가 한 200번 나오면서 테이블 안에 값이 들어간다!!

 

나 정말 오늘 대단했다.. 

ㅋㅋ 암튼 다 만들었다면 

새로고침하면 이렇게 값이 보인다. 데이터를 눌러도 값이 잘 나오는 것을 확인할 수 있다!

 

하나하나 수정했던 이유는 무슨이유인지 값을 못 읽는 부분이 있어서였다.

다행히 강사님이 그건 수업 때 어차피 사용하지 않을거니 그냥 지우라고 하셨다. 

이번 수업을 들으면 전에 뭐 때문에 값을 못 읽었던 건지, 더 잘 알 수 있게되지 않을까.. ㅜ

 

어쨌든 해내서 다행이다. 강사님께 감사의 의미로 커피를 사드렸고,, ㅋㅋ 은혜에 보답하고자 강사님 편하게 수업하시라고 맥을 쓰는 수업 동료들에게 내가 손수 편집한 쿼리문을 퍼트렸다~~~ 

 

다들 잘 실행되는 것을 보면 뿌듯하다. 역시 배워서는 남주는 것!

휴,, 이젠 나도 공부를 하려 가야겠다! 

 

'( '-' ).。oO ( SQL ) > Oracle' 카테고리의 다른 글

맥북 오라클 실행 전 터미널 설정  (0) 2024.06.13

+ Recent posts