Ad blocker interference detected!
Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers
Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.
created November 7, 2001 · complexity basic · author Demian L. Neidetcher · version 5.7
Here is a bash script to call from Vim, when you want information about a table while you are editing SQL code. Put the script in a file named describe.
#!/usr/bin/bash f=aTempFile.sql u=<uName> p=<pWord> d=<dBase> echo "/* describe for $1" echo "describe $1;" > $f; echo "quit;" >> $f; sqlplus -S $u/$p@$d @$f rm -f $f; echo " end describe for $1 */"
Your path needs to include the script (as well as sqlplus), then from Vim you type:
:r !describe <tableName>
That inserts a listing of the table columns, complete with Java/C comments.