Query or Stored procedure?
Posted by:
Echo 76
Date: July 12, 2012 03:25PM
Hello,
I am trying to solve my problem but without success. I have a table with production data which are stored from machines. one of the field (from many) is DateTime and another is machine status.
++++++++++++++++++++++++++++++++++++++++
+ DateTime + Status +
++++++++++++++++++++++++++++++++++++++++
2012-06-02 11:56:57+ Production +
2012-06-02 11:57:27+ Production +
2012-06-02 11:57:57+ Error +
2012-06-02 11:58:28+ Error +
2012-06-02 11:58:57+ Production +
2012-06-02 11:59:27+ Waiting for start +
... + ... +
++++++++++++++++++++++++++++++++++++++++
I need to count time totals for each machine status during time period. Is it possible to solve it with sql query? When yes how? Or is it better to use stored procedure?
Thanks in advance
Michael
Subject
Views
Written By
Posted
Query or Stored procedure?
2432
July 12, 2012 03:25PM
1255
July 13, 2012 02:58AM
1288
July 13, 2012 10:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.