Posts

Showing posts from July, 2014

Oracle vim config

This page gives a pretty good overview of tweaks you can do, so I just want to re-gurgitate what I have done (from that site). Syntax Highlighting Grab the file:  http://www.datacraft.com/plnet/files/vim/syntax/plsql.vim , and save this in: ~/.vim/syntax/ Then edit your .vimrc file and add the following line (to auto detect the filetype based on the extension): au BufNewFile,BufRead *.fun,*.pks,*.pkb,*.sql,*.pls,*.plsql    set filetype=plsql Auto Indentation Grab the file:  http://www.datacraft.com/plnet/files/vim/indent/plsql.vim , and save this in ~/.vim/indent/ Then edit your .vimrc file and add the following line runtime! indent.vim .. Though, I prefer just to use auto indent - there are some special situations where it wont calculate the indentation correctly using the indentation file above. So this gives me the following in my .vimrc file: au BufNewFile,BufRead *.fun,*.pks,*.pkb,*.sql,*.pls,*.plsql set filetype=plsql au BufNewFile,BufRead *.fun,*.pks

Accessing Google data, part 2

Intro Back in Novemeber 2012, I blogged about accessing Google data from APEX - and provided some sample code to getting started. You can find this post here: http://apextips.blogspot.com.au/2012/11/accessing-google-data.html . Over the past little while, I have been (slowly) working on a more modularised API, that can be easily built upon to add support for additional Google services. I have called it PL/GAPI ( G oogle API ). It can be found on github:  https://github.com/trent-/pl-gapi . I hope the wiki on github is straightforward enough to follow in setting this up in your local environment:  https://github.com/trent-/pl-gapi/wiki Services I've started with the following services: Drive Calendar Usage Without going into too much detail (since it's all on the wiki linked earlier), you link to an authorization URL with:  &OWNER..GAPI_AUTH.BEGIN_AUTH?p_scope=&P0_SCOPE.&p_return_app=&APP_ID.&p_return_page=&APP_PAGE_ID.&p_sessi