Recent Notes

Displaying keyword search results 1 - 2
Created by Dr. Xi on September 10, 2008 15:51:42    Last update: November 26, 2008 21:14:46
Variable Description SET AUTO [COMMIT] {ON | OFF | IMM [EDIATE] | n} Controls when Oracle Database commits pending changes to the database. SET CMDS [EP] {; | c | ON | OFF} Sets the non-alphanumeric character used to separate multiple SQL*Plus commands entered on one line to c. SET CON [CAT] {. | c | ON | OFF} Sets the character you can use to terminate a substitution variable reference if you wish to immediately follow the variable with a character that SQL*Plus would otherwise interpret as a part of the substitution variable name. SET ECHO {ON | OFF} Controls whether the START (@) command lists each command in a script as the command is executed. SET EDITF [ILE] file_name[.ext] Sets the default filename...
Created by Dr. Xi on September 10, 2008 19:52:55    Last update: September 10, 2008 19:52:55
A substitution variable is preceded by one or two ampersands (&). When you run a SQL command with substitution variables, you'll be prompted for the value of each variable. The one ampersand version prompts for a value and use it for the current query. The two ampersands version uses the value for the current query and remembers it. Just like you did a DEFINE myvar 'The Value' , so you won't be prompted again for subsequent queries using the same variable. To enter a literal ampersand, you need to SET ESC on and use the escape character before the ampersand (&). You can also use substitution variables with a script, but you follow the ampersand by a number instead of a name. When you call...