Recent Notes

Displaying keyword search results 1 - 3
Created by Dr. Xi on February 06, 2012 12:14:11    Last update: February 07, 2012 15:39:35
Oracle sqlplus command line tools does not support command line editing out-of-the-box. But on Linux there's a handy utility that enables command line editing with any command line tool: rlwrap - readline wrapper. Install rlwrap: $ sudo apt-get install rlwrap Create a keywords file .sql.dict (optional, but convenient): false null true access add as asc begin by chec... It would be nice to add the tables names also. Create an alias for sqlplus (put it in .bashrc ): alias sqlplus='rlwrap -f $HOME/.sql.dict sqlplus'
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...