Scripts allow users to save and execute SQL queries. Users type queries in SQL*Plus and save them using the 'save' command followed by a file name with a '.sql' extension. To add additional queries to a script, users append to the existing file using the save menu. Saved scripts can then be executed by using the 'start' or '@'' command followed by the file name.