Skip to Main Content
Forums

SQL & PL/SQL

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!

pl/sql procedure to process data to make register table

shuvroMar 12 2020 — edited Mar 12 2020

Hi everyone. i'm working on 18c database.

I have a table  named TAB_TF, where data are inserted day wise in following way. (e.g. 1-Jan data inserted in TAB_TF )  :-

                                TAB_TF   

FILE_DATETF_IDCOMPANYTF_VALUE
1-JanTF0001BD00101102025
1-JanTF0002BD001013211200000
1-JanTF0003BD001011418369.74
1-JanTF0004BD001011816500
1-JanTF0005BD00101104750

In day 2 (i.e. 2-Jan), TAF_TF table is inserted with following values:-

                               TAB_TF  

FILE_DATETF_IDCOMPANYTF_VALUE
2-JanTF0001BD00101102025
2-JanTF0003BD001011418369.74
2-JanTF0004BD001011816500
2-JanTF0005BD00101104750
2-JanTF0006BD001013211200000
2-JanTF0007BD001011418369.74

Note : Here we can seen that , TF0002 is end it's life cycle and TF0006 & TF0007 are inserted and ready to start its life cycle.

Now, help me in writing an pl/sql procedure, such that i can make a register data (in another table called REGISTER_TAB_TF) based on all values in following structure. (i.e the table contains all TF_ID with status on and off)

          REGISTER_TAB_TF

TF_IDCOMPANYTF_VALUE
TF0001BD00101102025
TF0002BD001013211200000
TF0003BD001011418369.74
TF0004BD001011816500
TF0005BD00101104750
TF0006BD001013211200000
TF0007BD001011418369.74

Thanks in advance.
Comments
Post Details
Added on Mar 12 2020
4 comments
246 views