Displaying keyword search results 1 - 6
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 rlwrapCreate 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 September 01, 2008 02:19:31 Last update: May 23, 2009 16:50:10
Use this bookmarklet to set or delete cookies in a web page. If you leave the expires date as is, the cookie will be deleted. Add this link to your bookmarks to install the bookmarklet.
Created by Dr. Xi on March 02, 2009 23:29:08 Last update: March 28, 2009 21:35:41
An HTML form contains more than what meets the eye. This bookmarklet displays information about form fields in the page. When there are multiple forms on the page, successive invocations of the bookmarklet display each form in turn. Add this link to your bookmarks. Here's the code:
Created by Dr. Xi on August 28, 2008 22:52:01 Last update: March 28, 2009 16:50:42
Created by Dr. Xi on August 10, 2007 21:05:26 Last update: August 10, 2007 21:05:26
<?xml version="1.0" encoding="UTF-8"?> <xsl...