On Sun, Nov 2, 2008 at 2:45 PM, Jerrygreat <[EMAIL PROTECTED]> wrote: > > > Hello, Buddies, > I must use Unix vim editor to edit a very large xxx.sql file. I have the > following urgent sytax question, I wonder if any friend can help me a > liittle.... > (I just bought a vim book, however, I am still not good enough.. ) > > 1. I have a lot of lines with break like below: > ALTER TABLE "HCDCNV"."SUBLEDGER_ENTRY" ENABLE CONSTRAINT > "SUBLEDGER_ENRTY_FK5" ; > ...
This plugin will not specifically help with your issue (reformatting ALTER and CREATE statements), but it will help with many of SQL related tasks. This one: SQLUtilities : SQL utilities - Formatting, generate - columns lists, procedures for databases http://www.vim.org/scripts/script.php?script_id=492 Will allow you to reformat SELECT statements of any size into a nice readable format. This one: dbext.vim : Provides database access to many dbms (Oracle, Sybase, Microsoft, MySQL, DBI,..) http://www.vim.org/scripts/script.php?script_id=356 Will help in a number of ways: 1. It will allow you to execute and query the database from within Vim. 2. Works with the autoload/sqlcomplete.vim to allow you to perform table and column (and more) name completion while you code. 3. Works with many different filetypes and can parse a statement prompting you for parameters. This allows you to execute your code without having to unmangle your strings in Java, Perl, Javascript and others. HTH, Dave --~--~---------~--~----~------------~-------~--~----~ You received this message from the "vim_use" maillist. For more information, visit http://www.vim.org/maillist.php -~----------~----~----~----~------~----~------~--~---
