The whole idea is to return all instance_name regardless if it exceeded the limit of max_time. For example if some of Instance_name might not have more than 60s so, it will return 'NULL' unless the instance_name hav more than 60s, it will return the value of Max_time_api...
I want something to return like this: INSTANCE_NAME...........GENESIS_PORT................MAX_TIME_API MatlMgr_QueryLeaded.....50039.....................updateMachineAttr: 61.5635s MatlMgr_Script..........50016.....................startLotOnMachines: 60.7425s MatlMgr_ConfigUpdate....50019..........................NULL MatlMgr_Misc............50031..........................NULL --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
