[FEATURE] Oracle driver

[sschneider-ihre-pvs]

I would like to have support for oracle databases go_ora maybe?

[danvergara]

Yeah, why not. We recently added support for sqlite. But first, we need to do a massive refactor, to add more drivers, in fact.

[sschneider-ihre-pvs]

Greate @danvergara when will the release with oracle support be available?

[danvergara]

@sschneider-ihre-pvs v0.24.0 is already available!!

[sschneider-ihre-pvs]

great

[sschneider-ihre-pvs]

:( is there a db version restriction?

[sschneider-ihre-pvs]

or windows

[danvergara]

@sschneider-ihre-pvs I think it has to do with the syntax of your query. Is your query using JOINs or ending with semicolons. I got the same error because I wasn't aware of the changes of the Oracle syntax.

[sschneider-ihre-pvs]

@sschneider-ihre-pvs I think it has to do with the syntax of your query. Is your query using JOINs or ending with semicolons. I got the same error because I wasn't aware of the changes of the Oracle syntax.

I tried to select a table to see the data so ctrl+h navigate to table and hitting enter

[danvergara]

I tried to select a table to see the data so ctrl+h navigate to table and hitting enter

This is the query I use to fetch the content of the table:

https://github.com/danvergara/dblab/blob/c7126e786bd224939d418db6e7d26a660e25bd8b/pkg/client/client.go#L336

Can you spot something wrong?

[danvergara]

This is the container image I use for testing:

[sschneider-ihre-pvs]

Ah yes, I have an older db that does not support things like TAKE FETCH NEXT OFFSET and so on, so that would explain it. So I guess you need at least v12c