Score:0

Oracle SQL command without input prompt

lk flag

In Oracle Database I need to execute SQL command RECOVER DATABASE UNTIL CANCEL BACKUP CONTROLFILE;. After that I got input prompt. I should enter CANCEL. Is there a way to enter only one command with automatic CANCEL substitution? Thank you for your answers!

Glorfindel avatar
cn flag
This question is perhaps better off at [dba.se].
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.