Run the file using the START or RUN commands from the SQL*Plus command prompt. Retrieve the file using the Open option on the File menu.Įdit the file using the Editor option on the Edit menu. Save Append adds the contents of the SQL*Plus buffer to the end of the file you specify.
Save Replace replaces the contents of an existing file with the contents of the SQL*Plus buffer SQL*Plus creates the file if it does not exist. Save Create saves the contents of the SQL*Plus buffer in a script By default, SQL*Plus assigns the SQL extension to scripts You can specify a different extension in the File name text box.The Save option has three alternatives: Save Create, Save Replace, and Save Append If you supply no file extension, SQL*Plus looks for scripts with the SQL extension The script should contain a single SQL or PL/SQL statement such as SELECT It should not contain multiple statements, and it should not contain SQL*Plus commands such as SET. The Open option retrieves a previously stored script
0 kommentar(er)
