Skip to Main Content
  • Questions

  • view select statement as tailing output

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Abir.

Asked: August 31, 2016 - 8:03 pm UTC

Last updated: September 02, 2016 - 2:10 am UTC

Version: oracle 11g

Viewed 1000+ times

You Asked

Hello,

I am Abir.
i have table A on oracle 11g Database. The front-end application always inserting rows all the time on table A.Each time, to view the table rows i have to run a select query and execute them on sqlplus.
My question is
Is the a way to view the table inserting status in tailing fashion. Like When a row inserted on the table a tail or live view will automatically
show us the inserted row(just like tail -f or adrci).

Thanks

and Connor said...

Perhaps something like Continuous Query Notification might be of use here.

http://docs.oracle.com/database/121/ADFNS/adfns_cqn.htm#ADFNS018

You'll be "notified" when the data changes, and then you can take any action you want. But this action will definitely involve *requerying* the data.

Hope this helps.



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.