Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help with pro SQL dump and Oracle Apex sql commands

870680Jun 22 2011 — edited Jun 22 2011
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2011
Added on Jun 22 2011
3 comments
215 views