(2/3) windows下vim配置dbext插件连接oracle直接执行sql语句--补充配置OBI ODBC interface 安装odbc数据源，让字段显示没有那么宽

港控/mmm° 2023-02-24 08:14 7阅读 0赞

### 1 显示结果如下 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70][]

###  2 找github对应perl版本和vim版本号 ###

echo has('perl')

return 0

主要原因是  vim  perl  如果操作系统64   最好vim和perl的版本也是64位  然后vim  和perl的版本必须对应上

将安装的perl配置到环境变量   vim  8.2.     perl  5.28

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 4][]

### 3  下载perl文件并安装    ###

在 vim  点击  :echo has('perl')  如果为 0  看上面的步骤  vim 和perl的版本是否对应上

配置perl的环境变量

PATH
    D:\ware\Strawberry\perl\bin
    
    PERL
    D:\ware\Perl

安装模块

这里 可以 查看  dbext 的文档  :h dbext   5.5 DBI Installation

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 5][]

cpan 
     install DBI
     install DBD::ODBC
     install DBD::Oracle

### 4 安装odbc数据源 ###

![20200708181929193.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 6][]

## ##

### 5 配置\_vimrc  ###

let g:dbext_default_profile_oracle_ODBC = 'type=ODBC:user=username:passwd=password:dsnname=oracle'
    
    let g:dbext_default_profile = 'oracle_ODBC'

### 6 需要安装插件  vim-easy-align ###

字段多  字段名和字段可能没有对齐

Plug 'https://github.com/junegunn/vim-easy-align.git'

设置分隔符为  |

这里可以查看我的另外一篇博客  [\_vimrc的配置 ][vimrc] 有点乱，就不一一列举了

" Start interactive EasyAlign in visual mode (e.g. vipga)
    xmap ga <Plug>(EasyAlign)
     
    " Start interactive EasyAlign for a motion/text object (e.g. gaip)
    nmap ga <Plug>(EasyAlign)

在查询结果额vim界面，输入

vipga*|

## ##

### 参考链接： ###

[https://blog.csdn.net/weixin\_30879169/article/details/95108244][https_blog.csdn.net_weixin_30879169_article_details_95108244]

[https://blog.csdn.net/Aggressive\_snail/article/details/53396432][https_blog.csdn.net_Aggressive_snail_article_details_53396432]

[https://www.cnblogs.com/juandx/p/5630837.html][https_www.cnblogs.com_juandx_p_5630837.html]

[https://blog.csdn.net/grape875499765/article/details/49304559][https_blog.csdn.net_grape875499765_article_details_49304559]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70]: /images/20230209/b50d492bae574adabbed5893c105d596.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 1]: /images/20230209/a07960e4431f4cf78673ddfcb4bfdc25.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 2]: /images/20230209/162b234bd79c4be7895d00bf7bfcc07e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200708181651281.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200708181540130.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200708183938451.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw==,size_16,color_FFFFFF,t_70
[20200708181929193.png]: https://img-blog.csdnimg.cn/20200708181929193.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200708182004259.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmdodWFuMDgyNw==,size_16,color_FFFFFF,t_70
[vimrc]: https://blog.csdn.net/tanghuan0827/article/details/105037416
[https_blog.csdn.net_weixin_30879169_article_details_95108244]: https://blog.csdn.net/weixin_30879169/article/details/95108244
[https_blog.csdn.net_Aggressive_snail_article_details_53396432]: https://blog.csdn.net/Aggressive_snail/article/details/53396432
[https_www.cnblogs.com_juandx_p_5630837.html]: https://www.cnblogs.com/juandx/p/5630837.html
[https_blog.csdn.net_grape875499765_article_details_49304559]: https://blog.csdn.net/grape875499765/article/details/49304559