Help with pro SQL dump and Oracle Apex sql commands
870680Jun 22 2011 — edited Jun 22 2011Hello I am a student and encountering issues in a task I am attempting. I have a pro SQL database dump which I want to import into Oracle apex to create a database app but I havnt found any method for doing this so I decided to manual create the tables in the APEX object browser now I have reached the stage where I am trying to use the insert code and data from the SQL dump but it appears APEX wont accept the format it is in for example its current format is:
INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`,`active`)
VALUES
(1,'Afghanistan','AF','AFG',1,1),
(2,'Albania','AL','ALB',1,1),
(3,'Algeria','DZ','DZA',1,1),
(4,'American Samoa','AS','ASM',1,1),
(5,'Andorra','AD','AND',1,1),
(6,'Angola','AO','AGO',1,1),
(7,'Anguilla','AI','AIA',1,1);
Can anyone give me advice on what I'm doing wrong or if possible is there an easier way to import a SQL dump into APEX??
Any help will be greatly appreciated, Thanks in advance