Skip to Main Content
Forums

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLcl apex export split problem

Andrey DokuchaevOct 14 2021 — edited Oct 28 2021

Hi!
If your application page number has more than 5 digit then "-split" option produce not page_NNNNN.sql file, but page_NNNNN_XXX.sql where XXX just some ORDER BY suffix. Therefore, the same page may be sliced to different result files (comparing to previous run).
For example:

  1. You have only pages 100001 and 100005. Result: page_10000_001.sql for page 100001, page_10000_002.sql for page 100005 (for example, I don't remeber exact file names);
  2. You have added page 100002. Result: page_10000_001.sql for 100001, page_10000_002.sql for page 100002 and page_10000_003.sql for page 100005.
    This "feature" ruins possibility of correct APEX-Git (and any other versioning system) binding. Is there a way for "-slice" option to always save APEX page into .sql file with static name (based only on page number)?

Comments

Post Details

Added on Oct 14 2021
7 comments
342 views