0
I’m developing a call panel. I have a query that results in the client call (name/password/Guiche), this query shows the result for 10 seconds, after that it is empty until the next call.
I need that each time this query has content (numrow>0), register in another table the information. So I’ll get the information from the latest panel calls.
How can I do that?
You can create a precedent and put in it your query and one more to insert in the other table, you can do the verification in the programming language you are using to make the panel.
– Caique Romero
Wouldn’t it be enough to check the last 10 calls ? Something like select * from (select name, phone, datatime from call order by datatime ) Where rownum <= 10
– Motta