Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Help with pro SQL dump and Oracle Apex sql commands
icon9.gif  Help with pro SQL dump and Oracle Apex sql commands [message #512857] Wed, 22 June 2011 09:37 Go to next message
Messages: 1
Registered: June 2011
Junior Member
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`)
(4,'American Samoa','AS','ASM',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
Re: Help with pro SQL dump and Oracle Apex sql commands [message #512911 is a reply to message #512857] Wed, 22 June 2011 16:00 Go to previous message
Messages: 21765
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Invalid syntax. Check this discussion, dealing with the same problem as yours.
Previous Topic: report-start only by pressing on go button, not by entering page
Next Topic: How to Create an Application with no template and custom made CSS
Goto Forum:

Current Time: Mon May 29 03:07:44 CDT 2023