Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

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
343 views