Recent Notes
Displaying keyword search results 1 - 2
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...
