Everyone a great god, the younger brother a first-time oracle database, to perform a specific SQL view the results regularly, SQL execution result is shown in figure,


Wrote a stored procedure is compiled through, but when to join the job is an error to comment,

CodePudding user response:

How search dbms_job calls, or dbms_schedual. Job how to use

CodePudding user response:

dbms_scheduler

CodePudding user response:

Order inside out, not a stored procedure call timing task, but timing task to call a stored procedure,
Who performed regularly, see, look, to guarantee that point in time someone see it,

CodePudding user response:

What is the purpose of return several cursor? The caller to receive can provide the corresponding parameters,

CodePudding user response:

Too many mistakes, need to solve them one by one.

CodePudding user response:

reference AHUA1001 reply: 3/f

order inside out, not a stored procedure call timing task, but timing task to call a stored procedure,
Who performed regularly, see, look, to guarantee that point in time someone see,

Because of the large table data, execution efficiency is not high, so I want to perform regularly to extract data as a result, for the maintenance staff query analysis,

CodePudding user response:

references 4 floor selling fruit net reply:

return for what is the purpose of the cursor? The caller to receive can provide the corresponding parameters,

Introductory is zero, just want to make a simple timing to extract data stored procedure, and then execute regularly,

CodePudding user response:

refer to 7th floor martinlans response:

Quote: refer to 4th floor selling fruit net reply:

What is the purpose of return several cursor? The caller to receive can provide the corresponding parameters,

Introductory is zero, just want to make a simple timing to extract data stored procedure, and then execute regularly,

That there was a problem will cause you to understand there is a problem, first of all, you want a stored procedure is used to extract data, is not time to extract data, time is a function of the timer, you can write a timer, and let the timer timing the execution of the stored procedure, you wrote in this way can we achieve the stored procedure timing to extract data, display data as to how are you going to show, that is your desk