search

kristijanhusak / vim-dadbod-ui

Simple UI for https://github.com/tpope/vim-dadbod
MIT License
1.54k stars 94 forks source link

Oracle Schemas ORA-00904 "COMMON" Error #248

Open ParkJaeSeong opened 5 months ago

ParkJaeSeong commented 5 months ago

Thanks for making such a good plugin.

The common column in Oracle's all_users was added in Oracle Database 12c Release 1 (12.1). In earlier versions of Oracle Database (11g and earlier), the common column does not exist in the all_users view. In my case, it does.

autoload/db_ui/schemas.vim 119 line Modify it like below.

Delete line 126 \ AND U.common = 'NO' Delete line 137 \ WHERE U.common = 'NO' Modify line 150 \ 'schemes_query': printf(s:oracle_args, "SELECT /*csv*/ username FROM all_users ORDER BY username"),

Hope this helps someone.

ParkJaeSeong commented 5 months ago

I'm not comfortable modifying the query every update, so I reopened it.

I'm using lazyvim. I would like the above changed QUERY to be reflected in the plugin.

Please tell me how to set it up.