1 Reply Latest reply on Aug 14, 2017 4:53 AM by Tyagi Tushar

    Need Help for Data Loading

    336d8a3e-55fa-4652-9e79-1abb395ee6d0

      Any one here who has worked with advance data loading. Like in my case i want to upload data of particular month but instead of adding month column in data(for loading) i want to give a parameter to user to select that particular month.

        • 1. Re: Need Help for Data Loading
          Tyagi Tushar

          Are you using APEX data loading wizard? Notice that four pages are created when we use APEX wizard, browse, map, validate and action.

           

          On first page, add a select list for user to select month. Suppose he select January and the item name for select list is  "P1_MONTH".

           

          Now you may follow two approaches here.

           

          1. You may add a after insert trigger on your table.

          after insert for each row,

          update table_name

          set month = :p1_month.

           

          2.  On fourth page of your data loading wizard, after insert process, add a plsql process,

          update table_name

          set month = :p1_month

          where month is null;

          This obviously assumes that all previous data if any , already consist of some value in month column.