Wikia

Vim Tips Wiki

Changes: Describe a SQL table from Vim

Edit

Back to page

(Move categories to tip template)
(Remove html character entities)
 
Line 18: Line 18:
   
 
f=aTempFile.sql
 
f=aTempFile.sql
u=<uName>
+
u=<uName>
p=&lt;pWord&gt;
+
p=<pWord>
d=&lt;dBase&gt;
+
d=<dBase>
   
 
echo "/* describe for $1"
 
echo "/* describe for $1"
echo "describe $1;" &gt; $f;
+
echo "describe $1;" > $f;
echo "quit;" &gt;&gt; $f;
+
echo "quit;" >> $f;
   
 
sqlplus -S $u/$p@$d @$f
 
sqlplus -S $u/$p@$d @$f
Line 33: Line 33:
 
Your path needs to include the script (as well as sqlplus), then from Vim you type:
 
Your path needs to include the script (as well as sqlplus), then from Vim you type:
   
:r !describe &lt;tableName&gt;
+
:r !describe <tableName>
   
 
That inserts a listing of the table columns, complete with Java/C comments.
 
That inserts a listing of the table columns, complete with Java/C comments.

Latest revision as of 08:34, September 28, 2008

Tip 156 Printable Monobook Previous Next

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.

CommentsEdit

Around Wikia's network

Random Wiki