On Mar 16, 9:53 pm, Jack <[email protected]> wrote:
> 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
Then provide DDL and sample data so someone else can run your queries
and possibly discover the 'problem'.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
