DEV Community

realNameHidden
realNameHidden

Posted on

2 1 1 1 1

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

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

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Community—every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple “thank you” goes a long way—express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay