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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |