Question

When you want the system to execute a command you almost never have to give the full path to that command how can it be achieved?

Answer 1

SELECT EMP_NUM, EMP_LNAME, EMP_FNAME, Sum(INV_TOTAL) AS TOTALINVOICES FROM LGINVOICE, LGEMPLOYEE WHERE EMP_NUM = EMPLOYEE_ID GROUP BY EMP_NUM, EMP_LNAME, EMP_FNAME ORDER BY EMP_LNAME, EMP_FNAME

Answer 2

The path environment takes care of the mentioned situation. This path variable will list all of the directories in the system where such executable files are detected.  

Explanation:

• Thus this variable saves the user in memorizing and typing the locations of all commands. Finally echo command is used for displaying the search results in the console.  

• The only disadvantage in using this variable is, it might stop/hang while searching for invalid locations.