Skip to Main Content
Forums

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!

one form to add data to multiple tables

User_1EUWLMay 6 2022 — edited May 6 2022

Schermafbeelding 2022-05-06 om 21.06.05.pngSchermafbeelding 2022-05-06 om 21.04.40.pngHi,
I'm new with oracle apex.
for a school draft I have a normalized database (country, city, municipality, correspondent, Person as spin off of the correspondent and institution as spin off of the correspondent table).
the database is fine, but the second part is to create forms to fill the database.
i want to have one form where i can type in the information about te person.
when I submit, I want to write the filled in in formation to the different database tables example by elk sql procedure. how can I do that in apex?

i have started creating a form whit items that shown or hide based on the type of correspondent you can fill in person details or institution details.

Comments

CloudDB
YES

You can directly connect using jdbc thin method without install the oracle client in your local.

SQL Developer's default connection to the database is using the thin JDBC driver.
Defaulting to using the JDBC thin driver means there is no requirement for an Oracle
client install minimizing the configuration and footprint.

http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html

Edited by: hitgon on Jan 2, 2013 5:36 PM
Reddy G
Thanks for ur replay..

can you tell me what information i need to provide for JDBC...in SQL developer I can see Custom JDBC URL option in Advanced part..
is there doc which will provide the step by step..
Jim Smith
Youdon't need to use the Advanced connection, Basic connection is sufficient.

You just need to provide a host, port number (probably 1521), and a SID or SERVICE. You can get these from the tnsnames file if you have one or from your DBA.
1 - 3

Post Details

Added on May 6 2022
#apex, #apex-discussions, #form, #multiple
4 comments
3,998 views