Recent Notes

Displaying keyword search results 1 - 7
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 October 09, 2009 19:27:22    Last update: October 09, 2009 19:30:01
PL/SQL code from Pandazen : CREATE OR REPLACE FUNCTION GET_INSERT_SCRIPT(V_TAB... Usage: To create the script for generating the INSERT statements: set head off set pages 0 set trims on set... Run the resulting script to generate the INSERT script: set pages 0 set trims on set lines 2000 ... PL/SQL code from Oracle Ask Tom set serveroutput on size 100000 set feedbac...
Created by Dr. Xi on March 24, 2009 23:40:51    Last update: March 24, 2009 23:41:34
The DECODE function is used to decode a key to a value , returning the default value if one is provided. It returns null if there's no match for keys and no default value is provided. select DECODE(&quarter_id, '1', 'Spring', '2',...
Created by Dr. Xi on March 24, 2009 23:28:19    Last update: March 24, 2009 23:29:35
The COALESCE function returns the first non-null expression in the expression list. It returns null when all expressions evaluate to null . This example is from Oracle documentation : SELECT product_id, list_price, min_price, COALESCE... Result: PRODUCT_ID LIST_PRICE MIN_PRICE Sale ...
Created by Dr. Xi on September 17, 2008 02:56:09    Last update: September 23, 2008 02:46:03
When a page is in a standalone window, window.focus() brings that page to the front. With tabbed browsing (in either IE, or Firefox), a popup window may be opened in a new tab. In that case, window.focus() has no effect. For testing purposes, this is the parent page: <html> <body> <script language="JavaScript"... and the popup page: <html> <body> <h2>The Popup</h2> </body>... I haven't found a solution to this when the popup is displayed in a tab. However, you can configure the browser so that it displays popups in a new window instead of a new tab. For IE, open up " Internet Options ", on the general tab under the " Tabs " section, click " Settings ". Under "When a popup is encountered", check...
Created by Dr. Xi on September 19, 2008 21:35:55    Last update: September 19, 2008 21:35:55
The Oracle NVL function lets you use an alternative value when a null is encountered. -- list name with email or 'N/A' if not availa...
Created by Dr. Xi on August 10, 2007 21:05:26    Last update: August 10, 2007 21:05:26
This style sheet transforms the struts-config.xml into HTML for easy viewing in a browser. It uses the DHTML JavaScript tooltip from http://www.walterzorn.com/tooltip/tooltip_e.htm . <?xml version="1.0" encoding="UTF-8"?> <xsl...