Re: Oracle 11g SQL + PL/SQL + SQL*Plus + RDBMS syntax support

On Wed, Sep 12, 2012 at 1:59 AM, William Robertson <william@williamrobertson.net> wrote:

Interesting - the quoting issue goes away if you set filetype=sqloracle. My plsql.vim just sources that so I can't think any reason for it to have its own parsing rules for quoted text. It seems fixed if you comment out the following lines:

syn match       plsqlCharLiteral        "'[^']'"
syn match       plsqlStringLiteral      "'\([^']\|''\)*'"
syn match       plsqlStringError        "'.*$"

I can't see a colourscheme defined in my plsql.vim or sqloracle.vim, although I'd be interested to hear how you get on with katia.vim and gfn=Consolas:h8:cANSI. The colourscheme is PL/SQL-friendly, though should also be OK with Perl, shellscript etc (although I haven't quite worked out why Korn shell "[[" comes up red - trying to fix that...)

I'd also be interested to hear whet you think of my subtle tab character highlighting - it's set up in plsql.vim but activated in _gvimrc or an ftplugin script, with

let c_show_tabs = 1

In fact I also have an ftplugin/plsql.vim containing:

if exists("b:did_plsql_ftplugin")
   finish
endif
let b:did_plsql_ftplugin = 1

setlocal textwidth=160   " 80 character lines
setlocal expandtab smarttab
setlocal ts=3 sw=3 autoindent
colorscheme katia
let c_show_tabs = 1
let c_space_errors = 1

--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

What I download is the archive named gvim-windows.zip in your link site. You hardcoded the colorscheme in the ftpplugin/plsql.vim. This was the "plsql.vim" I meant... 

My personal font is  

   set gfn=consolas:h10:cANSI

   set gfw=Yahei_Mono:h10.5:cGB2312

the normal part seems not much too different with yours.

I have binded files with a suffix of ".sql"  to filetype plsql. If I open a new buffer, I will first :set ft=plsql.  I commented the three lines you mentioned, but the quoting still not worked as ft=sqloracle.  I navigated the plsql.vim, but I did not find where you override the mark of ' besides those three lines.

About the colorscheme... actually I didt not quite get used to your colorscheme. I prefer dark background with colorful keywords. I am using a theme called "diablo3"  downloaded from vim.org.

c_show_tabs and c_space_errors are good features and I will take them. And the textwidth I will set to 240 (120 characters per line) along with ts=2, sw=2 in my personal use. This is a team code convention I have to follow...

--
Our enemy shall fall.

Death to all who oppose us!!

--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php