text: -- Script generated by PLEX version 2.4.0 - more infos here: https://github.com/ogobrecht/plex
  -- Performance Hacks by Connor McDonald: https://connor-mcdonald.com/2019/05/17/hacking-together-faster-inserts/
  -- For strange line end replacements a big thank to SQL*Plus: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2377701.1 (SQL Failed With ORA-1756 In Sqlplus But Works In SQL Developer)
  prompt - insert   23 rows into CO_STORES
  set define off feedback off sqlblanklines on
  alter session set cursor_sharing = force;
  alter session set nls_numeric_characters = '.,';
  alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
  alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ssxff';
  alter session set nls_timestamp_tz_format = 'yyyy-mm-dd hh24:mi:ssxff tzr';
  begin
  insert all
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (1,'Online','https://www.example.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (2,'San Francisco',NULL,'Redwood Shores
  500 Oracle Parkway
  Redwood Shores, CA 94065',37.529395,-122.267237,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (3,'Seattle',NULL,'1501 Fourth Avenue
  Suite 1800
  Seattle, WA 98101',47.6053,-122.33221,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (4,'New York City',NULL,'205 Lexington Ave
  7th Floor
  New York, NY 10016',40.745216,-73.980518,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (5,'Chicago',NULL,'233 South Wacker Dr.
  45th Floor
  Chicago, IL 60606',41.878751,-87.636675,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (6,'London',NULL,'One South Place
  London
  EC2M 2RB',51.519281,-.087296,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (7,'Bucharest',NULL,'Floreasca Park
  43 Soseaua Pipera, corp B.
  Sector 2
  Bucharest , 014254
  RO',44.43225,26.10626,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (8,'Berlin',NULL,'Behrenstraße 42 (Humboldt Carré)
  10117 Berlin',52.5161,13.3873,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (9,'Utrecht',NULL,'Hertogswetering 163-167, 3543 AS Utrecht, Netherlands',52.103263,5.061644,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (10,'Madrid',NULL,'C/ José Echegaray 6B
  Las Rozas
  28230 Madrid',40.4929,-3.8737,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (11,'Johannesburg',NULL,'Woodmead North Office Park
  54 Maxwell Drive
  Jukskeiview, Sandton, 2196',-26.044222,28.094662,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (12,'Lagos',NULL,'1391 Tiamiyu Savage St, Victoria Island, Lagos, Nigeria',6.42806,3.42199,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (13,'Bengaluru',NULL,'193, Bannerghatta Main Rd, Industrial Area, Stage 2, BTM Layout, Bengaluru, Karnataka 560076, India',12.8939,77.5978,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (14,'Mumbai',NULL,'First International Financial Center
  Unit No. 501, Level 5
  No. C54 & 55, G Block
  Bandra Kurla Complex
  CTS No. 4207, Kolekalyan Village
  Mumbai - 400 051
  India',19.069405,72.870143,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (15,'New Dehli',NULL,'F-01/02, First Floor
  Salcon Rasvillas
  D-1, District Centre,
  Saket, New Delhi - 110017
  India',28.527693,77.220135,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (16,'Sydney',NULL,'Riverside Corporate Park
  4 Julius Avenue
  North Ryde
  NSW 2113',-33.797279,151.143826,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (17,'Perth',NULL,'Level 9
  225 St Georges Terrace
  Perth WA 6000',-31.953715,115.851645,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (18,'São Paulo',NULL,'Rua Dr. Jose Aureo Bustamante,
  455 - Vila Cordeiro,
  CEP 04710-090 São Paulo',-23.5475,-46.63611,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (19,'Buenos Aires',NULL,'Juana Manso 1069, Buenos Aires, Argentina',-34.61016,-58.362867,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (20,'Mexico City',NULL,'Montes Urales # 470 P3
  Col. Lomas de Chapultepec
  Delegación Miguel Hidalgo - C.P. 11000',19.428489,-99.205745,NULL,NULL,NULL,NULL,NULL)
  select * from dual;
  insert all
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (21,'Bejing',NULL,'China, Beijing Shi, Haidian Qu, Dongbeiwang W Rd, 8, 100085',40.0572,116.290061,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (22,'Tokyo',NULL,'2 Chome-5-? Kitaaoyama, Minato City, Tokyo 107-0061, Japan',35.671534,139.718584,NULL,NULL,NULL,NULL,NULL)
  into CO_STORES(STORE_ID,STORE_NAME,WEB_ADDRESS,PHYSICAL_ADDRESS,LATITUDE,LONGITUDE,LOGO,LOGO_MIME_TYPE,LOGO_FILENAME,LOGO_CHARSET,LOGO_LAST_UPDATED) values (23,'Tel Aviv',NULL,'B, Aharon Bart St 18, Petah Tikva, 4951400, Israel',32.100664,34.862138,NULL,NULL,NULL,NULL,NULL)
  select * from dual;
  end;
  /
  commit;
  alter session set cursor_sharing = exact;
  
  