Skip to Main Content
Feature Request FR-3216
Product Area SQL Workshop
Status CLOSED

2 Voters

Code Generation in Quick SQL, creates random ordered tables, and the script execution fails.

yannis Public · Jun 21 2023

Idea Summary

When Generating SQL code in Quick SQL,  it would be nice to calculate table dependencies and generate first, tables without dependencies, then generate the tables with dependencies in an order that any referenced table is created before the table that is referencing them will be created. That way when the user creates a large model and run the generated script, it will not break because a table that is needed is not there “yet”.

Use Case
Quick SQL is a very powerful tool. Development time is decreased drastically and the accuracy of triggers and packages is guaranteed! 

I have developed a medium size model (62 tables). Every time it regenerates the SQL the order of the tables is different as a result it is rather impossible to run the script 100% correctly.

I have to manually put the create table statements in order,  to allow the script to run!

We reviewed this idea carefully and came to the conclusion that it does not constitute an appropriate APEX feature request.

Comments

Comments

  • jayson hanes Admin OP 1.9 years ago

    QuickSQL has grown in popularity and to expand that growth it is now in a standalone Git Hub Repository accessed here https://github.com/oracle/quicksql.  ORDS 23.3+ ships with the latest version of QuickSQL which is then used in APEX. Issues and Enhancements should be directed to the git repository.

  • yannis OP 10 months ago

    Thank you. This does not answer the original point.

  • jayson hanes Admin OP 10 months ago

    The APEX team does not support QuickSQL any longer.. so file that issue on the above github.