Current Position:Home > How to use tabular records ?

How to use tabular records ?

Update:11-30Source: network consolidation
Below are the steps I want to :
1) retrieve data from a table
2) put these data into a mutiple records, It is a tabular records designed by the data block wizard.
3) modify data
4) save data into another table

The Best Answer

I don't think the previous post would actually work, or at least it would be really difficult to implement.
One way would be to base your table off a package, ref cursor tables etc and write the data to the other table on insert and update.
You have to decide how you want to handle delete, both tables or whatever.
You could also create a DB trigger.
Why are you doing this though? I doubt seriously there is any need. If you trying to "version" the changes you could do a recursive relationship wih a date stamp as the FK. Or just flag the column as old and select not nulls, date stamp would still be a good thing though in case you want to review history.
Hope this helps
  • How to use tabular records ? Update:11-30

    Below are the steps I want to : 1) retrieve data from a table 2) put these data into a mutiple records, It is a tabular records designed by the data block wizard. 3) modify data 4) save data into another table thxI don't think the previous post would

  • How to get an item data from a tabular recorder? Update:11-30

    Hi Since a data item(column)in a tabular recoders has only one name,I don't know how to use the one name to access the different row data. Plz tell me how to do.thx. LeeThanks! I've got it work! Now I can associate many product to a specific ProductN

  • BDC recording for FNVM t-code Update:11-30

    Hello Team Now i have got a requiment to add a new condition type in FNVM t-code. i am trying to acheive this by using BDC but i am not able to do the recording. when i am trying to do the recording, i am not able to capture the POPUP values which i

  • Pagination for the flash chart Update:11-30

    Hi, I have a apex application where in one page I display certain value (in tabular format) based on few criteria and also in the same page for the same criteria I have a flash chart which should show the same values (as that of the tabular format) i

  • How to save more than 2 records at a time in tabular form? Update:10-11

    I have a table name SAMPLE_TABLE, which has SNO,NAME items and one sequence name is SEQ_SAMPLE. i have one form based on SAMPLE_TABLE. my form is in tabular format, which has 5 records. in the layout wizard only NAME is displayed. SNO doesnot display

  • Excel OutPut and Dynamically select No of Records in tabular Canvas Update:10-11

    Hi, I have Oracle foms 10g R2 I have two queries. 1. If I select spreadsheet(Excel) output format in report the items disperse and it is not formatted as it appears during development, what is the reason and how can I fix it. 2. I have canvas on whic

  • Adding a Record in Tabular Form Update:10-11

    I created a tabular report using apex_collections. Now I have created by apex_collection.add_member . It is successfully adding a new record. But I need to jump off to the last screen to view the blank record. Any solution to display that in the curr

  • How to save all records in the Tabular form page temoprarily Update:10-11

    Hi All, I am very new for HTML DB. I created 5 tabular form using HTML DB Wizard. I want that whenever I open any tabular form page and click the add row button in that page then I should add as many record as we need but it should not save in the da

  • Processing mutliple records on multiple pages in a tabular form Update:10-11

    I'm a newbie to Apex (4.0). I have a tabular form displaying 500 rows records in multiple pages. The row selector is selected by defaulted ie. all rows have been checked. Upon unselecting items in multiple page, the Multi Row Delete (Post Processing

  • Displaying all the records in a tabular form on a single page Update:10-11

    Hello, After setting up a data entry page, I have hit an unexpected problem. The logic in my page requires that all the records in my tabular form should be displayed . The tabular form is based on a collection, and the user selects rows through a ch