search

squirrel-sql-client / squirrel-sql-code

Share of the SQuirreL SQL source code originating from SourceForge, see https://squirrelsql.org
GNU Lesser General Public License v2.1
65 stars 12 forks source link

Create Table Script Uses DECIMAL instead of NUMBER for Datatypes that are NUMBER #1

Closed jreed-cartago closed 2 years ago

jreed-cartago commented 2 years ago

So I created a SQL Create Table Script to get the structure of a table into the editor, the table is so structured

image

but the SQL generation looks like this

image

gerdwagner commented 2 years ago

Could you please give some details on you database and JDBC driver. Product name and version of both would help to reproduce your problem.

jreed-cartago commented 2 years ago

Hello yes. The database to which I am connecting is an Oracle 18c Express. I'm currently using the the oracle.jdbc.OracleDriver version 6 from what I can tell, using the ojdbc6.jar file. This would be using the Oracle Thin Driver.

gerdwagner commented 2 years ago

Fixed in our GIT repositories. Will be available in future snapshots ans versions.

Excerpt from change log: https://github.com/squirrel-sql-client/squirrel-sql-code/issues/1 Table scripts for Oracle RDBMS: For Oracle databases right mouse click on table in Object tree --> Scripts --> Create Table Script scripted columns of type number as decimal.