6/18/2023 0 Comments Oracle sql command line client![]() ![]() Select * from EMPLOYEES where employee_id = &1 In our script, the where condition should be typed in substitution variable as follows.Important note when running SQL script with parameter from cmd Sqlplus hr/hr To run SQL Script with parameters, we need to type this command. To run SQL Script without parameters, we need to type this command.Change the current directory to the directory where your script is available.Press Windows + R from your keyboard, then type cmd and press enter.To Run SQL Script from windows command line CMD : ![]() So that’s why we prepare this article to guide you through the steps required to perform this task to get all employee’s information that doesn’t need a parameter and another one to get a certain employee information. Sometimes we have a requirement to run a particular SQL script from windows command line “CMD” with or without parameters.
0 Comments
Leave a Reply. |