Recent Notes

Displaying keyword search results 1 - 3
Created by Dr. Xi on July 29, 2009 20:58:51    Last update: July 29, 2009 20:58:51
You need to set several system variables in order to run a SQL script to update a column with JavaScript code: SQLT: set sqlt off The default SQLT (SQL terminator) is semicolon, which is used in JavaScript as statement terminator. Blank lines: set sqlblanklines on Blank lines are abundant in JavaScript. Don't let them terminate your SQL statement No variable substitution: set define off The ampersand is a JavaScript operator, which is also used by SQL*Plus for variable substitution. You should turn variable substitution off to preserve the JavaScript code. Finally, use slash (/) on a blank line to terminate your SQL code. Example: UPDATE events set JSCODE = 'var a = 1; var ...
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 November 12, 2008 22:56:00    Last update: November 12, 2008 22:56:00
Set the PAGESIZE system variable to 0 to suppress headings in SELECT results. This is helpful when retrieving source code for packages or stored procedures: SQL> set pagesize 0 SQL> show pages pagesize...