I want to insert the account number into CMF_INTERIM_BILLS.TRACKING_ID,TRACKING_ID_SERV columns are composite primary key in the table CMF_INTERIM_BILLS.
The logic behind this is that
Only 1 row is to be inserted into CMF_INTERIM_BILLS table then the bip.sh script runs for a particular account number .When the bip.sh runs the entry for that particular account number
is deleted from CMF_INTERIM_BILLS automatically.
How to implement this logic? Please correct my above code.
The usual solution is to write a script to generate you SQL for the insert. If you insert ... select ... UNION select .... you can do multiple rows at a time. Then you just pipe it to sqlplus.
There are file loaders, too. I forget the name, but Oracle External Tables (mapping files as tables) are very fast and pretty easy, but requires access to the configured dir on the server. JAVA can pass in blocks that can be insert'd, select'd as tables, too.
I have big large snapshot file which contains every process start time and end time. One server snapshot contains many Application handle. My task is to identify the process id for which the end time is not there or empty also if the completion time is not on the same date then I need to kill.
... (6 Replies)