sql - 表格顶点oracle中的范围填充表

Question

再会！我有一个填写表格，表格是P1_FIRSTand P1_LAST，填完之后我想要。例如P1_FIRST = L4819222 and P1_LAST = L4819225。我按创建。在Test2表中，L4819222, L4819223, L4819224, L4819225已创建记录。感谢您的帮助

我之前曾寻求帮助，他们帮助了我，但是当极端值已经在表中时，该选项是合适的。在此变体中，极值仅在形式中。 范围填充表

标签： sqloracle11goracle-apex

Answer 1

There's no difference whether you use values stored in a table or item values, query remains the same. Actually, it is even a little bit simpler.

As you already have those items, now

• create a button
  • let it Submit the page
• create a process which will run when you press the button

• process will perform this:

  INSERT INTO test2 (val)
  SELECT    SUBSTR (:P1_FIRST, 1, 1)
        || TO_CHAR (
              (  TO_NUMBER (REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + LEVEL
               - 1))
           AS val
   FROM dual
   CONNECT BY LEVEL <=
                  TO_NUMBER (
                     REGEXP_SUBSTR (:P1_LAST, '\d+$'))
               - TO_NUMBER (
                     REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + 1;