how to run multiple queries in .txt file on sql plus

realNameHidden - Aug 26 '23 - - Dev Community

step 1 : create file with .txt extension

step 2 : write the sql queries that you want to execute inside the .txt file

step 3 : copy the location of the file

step 4 : run the file as below

for example :

i have created the file script.txt

Image description

now for running this

Image description

output :

Image description

if you are not getting the queries that are executed then run the command

Image description

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .