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!

How to model in Apex?

marioWJul 30 2020 — edited Jul 31 2020

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

This post has been answered by AndyH on Jul 31 2020
Jump to Answer

Comments

mNem

As a suggestion, please post the class file that requires minimal effort from someone who may want to look into your issue - i.e. a class file that compiles and can be copy pasted. Additionally post all dependencies required and the expected result.

morgalr

I think you would have a lot better luck, reading a line, and then doing the mods you choose, then writing the line out to the new file so:

read in

mod or not

write out

loop until done

rename the old file

rename the new file

close it all up

Simple... is always better if it works just as well.

1 - 2

Post Details

Added on Jul 30 2020
4 comments
279 views