Comments by Member 8445821

Member 8445821 17-Mar-14 7:19am View

Dear Lukeer,
I can able to draw a semi circle using AddArc() but the thing is i want to draw the same with Axis Scale. Can you please help on that.

Member 8445821 29-Jul-13 6:37am View

In Oracle Sql Developer,the records are loading fastly. While trying from code alone it gets delayed. We have installed 11g client in that machine too. Will it wont support?

Member 8445821 29-Jul-13 6:33am View

Deleted

In Oracle Sql Developer,the records are loading fastly. While trying from code alone it gets delayed.

Member 8445821 10-Apr-13 1:56am View

Thanks Juhi Paunikar. I have verified whether iam closing the connections or not.It remains opened.So Now i changed to close the connections.Will check and say you whether the error still persists. Thanks once again.

Member 8445821 28-Mar-13 7:31am View

table will be like as follows:

[date_time] [590] [592]
2013-03-28 16:54:00 1645 1
2013-03-28 16:54:05 1645 1
2013-03-28 16:54:10 1645 1
2013-03-28 16:54:15 1645 1
2013-03-28 16:54:20 1645 1
2013-03-28 16:54:25 1645 1
2013-03-28 16:54:30 1645 1
2013-03-28 16:54:35 1645 0
2013-03-28 16:54:40 1645 0
2013-03-28 16:54:45 1645 0
2013-03-28 16:54:50 1646 1
2013-03-28 16:54:55 1646 1
2013-03-28 16:55:00 1646 1
2013-03-28 16:55:05 1646 1
2013-03-28 16:55:10 1646 1
2013-03-28 16:55:15 1646 1
2013-03-28 16:55:20 1646 1
2013-03-28 16:55:25 1646 0
2013-03-28 16:55:30 1646 0
2013-03-28 16:55:35 1646 0
2013-03-28 16:55:40 1647 1
2013-03-28 16:55:45 1647 1
2013-03-28 16:55:50 1647 1
2013-03-28 16:55:55 1647 1
2013-03-28 16:56:00 1647 1
2013-03-28 16:56:05 1647 1

Process 1645 started execution:

2013-03-28 16:54:00 1645 1

process 1645 completed during:

2013-03-28 16:54:35 1645 0

Next Process Started:
2013-03-28 16:54:50 1646 1

the value of [590] here incremented once the value of [592] changes from 0 to 1

now i want to calculate the total duration from 1645 completion to 1646 initialization which will be

2013-03-28 16:54:35 1645 0
2013-03-28 16:54:40 1645 0
2013-03-28 16:54:45 1645 0
2013-03-28 16:54:50 1645 1

so (2013-03-28 16:54:50) - (2013-03-28 16:54:35) = 15 secs will be the answer

Member 8445821 28-Mar-13 6:09am View

Dear Maciej,
Process end as well as start are identified by [592].If the values of [592] becomes 1,it means process have been started and when the value changes to 0 it indicates that the process have been stopped.If you need a ID column means you can use [590] as ID and it will get incremented when [592] changes from 0 to 1

Member 8445821 28-Mar-13 5:43am View

Dear Maciej Los,

In the above table,column [592] have the values either 0 or 1.when the value is 1 it means process was in progress and when the process completes the value of [592] changes to 0.Now, I want to calculate the process delay (ie) the time between taken between two process.Likewise i need to calculate the process delay for a day as well as for month.

In other words,I need to calculate the total duration of [592] when it was 0 for a day as well as for a month.

Comments by Member 8445821 (Top 7 by date)