Automate Oracle SQL Developer script

Navigation
2

I would like to know if it is possible to automate a script in the Oracle database manager.

What happens is that I have to run 3 lines or queries, every day. And I would like to know if there is a way to make automated.

The queries are 3 select, that is, I only consult some data to see the status.

    
asked by mijares93 03.01.2017 в 18:05
source

1 answer

1

It occurs to me:

  • create a store procedure with the logic of your select
  • create a job that executes the store procedure
  • regarding the data query you can do it in different ways: schedule tasks, send emails, through your application show a select etc.
    • answered by 28.12.2018 в 16:02
    What is the best way to use an event in javascript? [closed] Update value within a for batch