June 22, 2020

Run .sql file in Oracle SQL developer

Problem: Some times we have to execute insert queries of a table that we exported in .sql file. For multiple .sql files having huge data, it's not easy to execute those queries using copy and paste in SQL Developer tools.

 Solution: To execute .sql file you just need to write the path of your .sql file after @ and then file name with extension with delimiter ';' in the end. Select the complete command and press yellow highlighted green triangular button to execute sql script command. Just follow the below image for the reference.
Sample command:
@F:\myData.sql

0 comments:

Post a Comment

Disclaimer

We shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its response or damage to your system. We do not guarantee that the integrity or security of this communication has been maintained or that this communication is free of viruses, interceptions or interferences. Anyone communicating with us by email accepts the risks involved and their consequences. We accept no liability for any damage caused by any virus transmitted by this site.