I am preparing a migration from Oracle DB to a SQLite DB.
I would like to know all used datatypes in the Oracle DB so I can check out the equal datatypes in SQLite.
I am sure using Information_Schema seems to be the right way but I don't know how to start.
The used version of the Oracle DB is 10g (10.2).
I am thanking in advance.
Best Answer
Here is an example to find the number and type of columns in a schema: