oracledba.help
Scripts

testdata.create.sql

<- Scripts

-- H:\app\sql\testdata.create.sql
set verify off

PROMPT +------------------+
PROMPT | Create Test Data |
PROMPT +------------------+
PROMPT
ACCEPT v_schema PROMPT 'Schema name to create [X15]: ' DEFAULT 'X15'
ACCEPT v_table  PROMPT 'Table name to create [TEST1]: ' DEFAULT 'TEST1'
PROMPT


-- Process
PROMPT Processing...

DROP TABLE &v_schema..&v_table;
-- DROP TABLE X15.TEST1;

CREATE USER &v_schema IDENTIFIED BY "&v_schema"
DEFAULT   TABLESPACE users
TEMPORARY TABLESPACE temp;
ACCEPT v_confirm PROMPT 'User Account Created'
GRANT connect,resource TO &v_schema;
GRANT UNLIMITED TABLESPACE TO &v_schema;


CREATE TABLE &v_schema..&v_table (
  &v_table._ID number,
  NAME        varchar2(255) default NULL,
  CITY        varchar2(255),
  COUNTRY     varchar2(100) default NULL,
  CONSTRAINT &v_table._pk PRIMARY KEY("&v_table._ID") USING INDEX TABLESPACE users
);
ACCEPT v_confirm PROMPT 'Table Created - Pause'

INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (1,'Adria T. Spears','Oranienburg','Panama');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (2,'Berk J. Stevens','Cuttack','Costa Rica');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (3,'Bryar X. Weiss','Schwalbach','Papua New Guinea');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (4,'Odette G. Rush','Castel Volturno','Honduras');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (5,'Veda R. Morales','Chandrapur','Wallis and Futuna');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (6,'Sean Y. Lester','Marano Lagunare','Congo, the Democratic Republic of the');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (7,'Patience X. Mcfadden','Vottem','Netherlands');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (8,'Luke Z. Ray','Halen','Guadeloupe');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (9,'Claudia H. Martin','San Giovanni la Punta','Hungary');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (10,'Ria X. Peters','Coreglia Antelminelli','Montserrat');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (11,'Yetta A. Santos','Trani','Thailand');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (12,'Seth X. Cote','Reggio nell''Emilia','British Indian Ocean Territory');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (13,'Jasmine M. Medina','Adrano','Bonaire, Sint Eustatius and Saba');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (14,'Brittany N. Holder','Wechelderzande','Eritrea');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (15,'Cyrus F. Leonard','Bojano','Aruba');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (16,'Ursula Q. Gates','Mosciano Sant''Angelo','Hungary');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (17,'Davis U. Knight','Hanret','Kiribati');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (18,'Melanie M. Sullivan','Kapiti','Switzerland');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (19,'Quinlan X. Mcintosh','Coimbatore','Germany');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (20,'Norman O. Haley','Coltauco','Sweden');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (21,'Ferdinand B. Powell','Valparaíso','Cocos (Keeling) Islands');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (22,'Dalton B. Case','Filot','Qatar');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (23,'Stewart Y. Sullivan','Adelaide','Samoa');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (24,'Neve Z. Alvarado','Bergen','Tanzania');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (25,'Hoyt M. Poole','Melville','Cape Verde');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (26,'Janna M. Hanson','Bierges','Cuba');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (27,'Shannon C. Hester','Sheffield','Mexico');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (28,'Iola F. Jensen','Pinneberg','Gibraltar');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (29,'Ursa R. Cote','Conselice','Iran');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (30,'Julian W. Parsons','Chestermere','Japan');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (31,'Thane V. Norton','Gatineau','Tonga');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (32,'Geraldine H. Bird','Varanasi','Wallis and Futuna');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (33,'Damian K. Marshall','Woodstock','Nepal');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (34,'Blake Z. Morin','Bellefontaine','Venezuela');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (35,'Alexis D. House','Markham','Colombia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (36,'Naomi V. Roberson','Friedrichshafen','Estonia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (37,'Malik N. Pugh','Cardigan','Bhutan');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (38,'Jaime Y. Rojas','Vucht','Malta');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (39,'Martin Y. Nicholson','Brora','Philippines');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (40,'Denise E. Maddox','Timaukel','Mozambique');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (41,'Audrey P. Stanley','Lacombe County','South Africa');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (42,'Ira S. Melendez','Fürth','Iceland');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (43,'Quinn I. Alford','Thorold','Saint Lucia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (44,'James Y. Riddle','Porpetto','Chad');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (45,'Rhona A. Cameron','Hudson''s Hope','Luxembourg');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (46,'Galena E. Chase','LaSalle','Australia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (47,'Kylan D. Crosby','Galway','Aruba');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (48,'Linda E. Norton','Steendorp','Uganda');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (49,'Kai F. Pena','Saint-Hilarion','Saint Barthélemy');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (50,'Josiah A. Oneil','Opprebais','Barbados');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (51,'Orlando J. Hawkins','Herk-de-Stad','Antarctica');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (52,'Lisandra T. Osborne','Meerut Cantonment','Uganda');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (53,'Adena W. Jarvis','Jaboatão dos Guararapes','Wallis and Futuna');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (54,'Ishmael I. Bender','Augusta','Tonga');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (55,'Winifred I. Preston','Baddeck','China');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (56,'Colt D. Dodson','Bellevue','Burundi');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (57,'Courtney Q. Delgado','Chatillon','Sweden');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (58,'Leonard L. Savage','Norman Wells','Libya');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (59,'Xaviera E. Velasquez','Braives','Denmark');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (60,'Steven K. Gould','Shimla','Maldives');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (61,'Justina P. Wood','Zele','Timor-Leste');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (62,'Ivor Y. Hunter','Georgia','Russian Federation');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (63,'Marsden R. Dalton','Ödemis','Mayotte');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (64,'Abraham R. Dotson','Meerhout','Malaysia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (65,'Penelope E. Drake','Ferlach','Guernsey');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (66,'Yuri S. Ramirez','Colchester','Kenya');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (67,'Harrison Q. Martin','Raymond','Israel');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (68,'Karly G. Frazier','Asso','Egypt');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (69,'Alexis I. Ware','Sanzeno','Nigeria');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (70,'Inga J. Kennedy','St. Asaph','Qatar');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (71,'Austin B. Avila','Recklinghausen','Russian Federation');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (72,'Alfreda J. Rivera','Parrano','Timor-Leste');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (73,'Clementine H. Hensley','Helkijn','Nauru');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (74,'Kylynn B. Mueller','Gander','Brunei');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (75,'Ria F. Flores','Paulista','Norway');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (76,'Sydney Q. Keller','Allahabad','Saint Lucia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (77,'Dorian L. Henderson','Muzaffarnagar','Montserrat');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (78,'Ivory J. Perez','Meise','Sweden');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (79,'Nehru D. Ferrell','Eindhoven','Namibia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (80,'Ali W. Allison','Los Sauces','Guinea-Bissau');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (81,'Dacey U. Dillon','Nocciano','Anguilla');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (82,'Plato B. Atkins','Roxboro','Syria');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (83,'Cade S. Luna','Rutland','Turkey');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (84,'Xantha T. Roberson','Warburg','Sao Tome and Principe');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (85,'Keely Q. Ramirez','St. Catharines','Austria');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (86,'Gillian S. Flynn','Ehein','Congo, the Democratic Republic of the');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (87,'Willa C. Stevenson','Colwood','Sao Tome and Principe');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (88,'Chester Z. Slater','Terrance','Ukraine');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (89,'Amena W. Emerson','Springfield','Italy');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (90,'Keith X. Anthony','Grafton','Mali');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (91,'Vernon O. Collins','Trinità d''Agultu e Vignola','Korea, South');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (92,'Martena E. Irwin','Grand-RosiŽre-Hottomont','Morocco');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (93,'Ryan I. Rasmussen','Ujjain','Japan');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (94,'Cadman Y. Ramsey','San Isidro de El General','Trinidad and Tobago');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (95,'Prescott V. Holman','Mandi Burewala','Australia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (96,'Callum T. Kidd','Kansas City','France');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (97,'Erin Q. Velez','Linkebeek','Guam');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (98,'Nyssa N. Gregory','North Bay','Australia');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (99,'Cailin C. Potts','Sant''Elena','Cuba');
INSERT INTO &v_schema..&v_table (&v_table._ID,NAME,CITY,COUNTRY) VALUES (100,'Delilah K. Mercado','Spiere','Tajikistan');
COMMIT;
ACCEPT v_confirm PROMPT 'Test Data Created - Pause'

-- QC
SELECT * FROM &v_schema..&v_table;


-- End
PROMPT
PROMPT *** Process Completed ***
PROMPT