This dialog has three areas: Set Options, Value, and Screen Buffer. The Environment option enables you to set system variables to alter the SQL*Plus environment for your current session. By default, SQL*Plus saves the file to AFIEDT.BUFĭefine Editor defines the editor that is invoked InvokeEditor loads the contents of the SQL*Plus buffer into an editor.The Editor option has two alternatives: Invoke Editor and DefineEditor. The Clear option clears the screen buffer and the screen of the SQL*Plus application window. Note: A maximum of 3625 characters can be pasted from the Clipboard to the SQL*Plus command-line during a single paste operation. The Paste option pastes the contents of the Clipboard to the SQL*Plus command-line. The Copy keyboard shortcut is only available when no SQL operations are running in the SQL*Plus session When a SQL operation is running, Ctrl+C cancels the running operation.
#Sql server client gui windows#
The Copy option copies selected text to the ClipboardĪfter you copy text to the Clipboard, you can paste the text into other Windows applications, such as Microsoft Excel and Microsoft Word. The Exit option commits all pending database changes and closes the SQL*Plus application window. When no SQL*Plus operation is running, Ctrl+C copies selected text. The Cancel keyboard shortcut is only available when a SQL operation is running in the SQL*Plus session. The Cancel option cancels an in-progress operation. Typically this will be the last statement that was executed. The Run option lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. Spool File stores query results in a file By default, SQL*Plus assigns the LST extension to spool files You can specify a different extension in the File name text box You can edit the results with the Editor option on the Edit menu, and print the file from a Windows text editor.The Spool option has two alternatives: Spool File and Spool Off The Spool File option is the same as the SPOOL command with the REPLACE option SQL*Plus for Windows does not support the SPOOL OUT option. The Save As option saves the contents of the SQL*Plus buffer in a script.īy default, SQL*Plus assigns the SQL extension to scripts.You can specify a different extension in the File name text box. 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