Forum Stats

  • 3,735,212 Users
  • 2,247,145 Discussions
  • 7,857,783 Comments

Discussions

How to model in Apex?

marioW
marioW Member Posts: 20 Green Ribbon
edited Jul 31, 2020 3:11PM in APEX Discussions

Dear Experts

I am new to Apex and I am just using the free Online Apex Solution on  https://apex.oracle.com

I need more than one table and I know a little bit how to use the "Quick SQL" tool in Apex.

These are my questions:

a.) is it possible to use an extern SQL Modeler graphically and bring this model to online apex? What would be the easiest solution?

b.) how is it possible to handle a M:M Relation with the "Quick SQL" Tool in Apex

c.) is there possibility to build a model graphically in Apex and to do reverse engineering?

Sorry for my beginner questions and thanks a lot
Mario

Nachricht geändert durch user10569602

Best Answer

  • AndyH
    AndyH Member Posts: 648 Bronze Trophy
    edited Jul 31, 2020 2:19PM Accepted Answer

    DDL files are SQL files, so if you have DDL files saying something like 'CREATE TABLE WIBBLE (A NUMBER)' then can run this whenever a SQL file is required.

Answers

  • Sylvain Martel
    Sylvain Martel Member Posts: 684 Bronze Trophy
    edited Jul 31, 2020 9:40AM

    Hello Mario,

    So, a couple of thoughts for you.

    Quick SQL is a pretty snazzy tool but it doesn't "interface" with SQL Modeler.  It's a kickstart type of tool to get you going quickly.  APEX is just another tool of the Oracle database.  So, since you are quite familiar with SQL Modeler, just design your data model in SQL Modeler and generate the scripts for the db objects to create in the apex.oracle.com instance.  All you would have to do is execute the script(s) in SQL Workshop.

    apex.oracle.com is a great way to explorer and discover APEX, but since you seem a profesional developer, why don't you create an autonomous database cloud account?  You might end up having more flexibility to play around the database, APEX and SQL Dev Web.

    Hope this helps!

  • marioW
    marioW Member Posts: 20 Green Ribbon
    edited Jul 31, 2020 10:35AM

    Dear Sylvain

    Thanks for your answer. I am working with young students on a little project using Apex. For receiving an autonomous database cloud account one have to publish a credit card, which is not possible with young students. Therefore I will try to do the work with the local sql developer data modeler.

    My problem is that I think to need a SQL-File for the data model for Apex to import the tables. But I only manage it to  generate DDL-Files in the data modeler. Could you give me a hint/Link how to plan a model graphically in the modeler, get it to SQL-Code and save it as a SQL File for apex ....

    Thanks a lot

    Mario

  • AndyH
    AndyH Member Posts: 648 Bronze Trophy
    edited Jul 31, 2020 2:19PM Accepted Answer

    DDL files are SQL files, so if you have DDL files saying something like 'CREATE TABLE WIBBLE (A NUMBER)' then can run this whenever a SQL file is required.

  • marioW
    marioW Member Posts: 20 Green Ribbon
    edited Jul 31, 2020 3:11PM

    Hello AndyH

    You are absolutely right. One can copy and paste generated DDL and put it to Apex. With SQL Workshop via SQL Commands or SQL-Scripts it is executeable and one can save/download it as SQL-File.

    Thanks all of you for your help!

    Mario

Sign In or Register to comment.