SQLDeveloper
Oracle SQL Developer 1.5 - enable debug information
when I use SQL Developer, there 're several times when a screen just disappear without any pop-up error window and I don't know why. SQL Developer do not output any debug information by default.
There is difference between different version for setting up debug mode for SQL Developer. The debug mode for version 1.5 is much more easy to setup.
Steps to for debug mode setupRead more
SQL Developer 1.5 excel import - Date Format problem
When I use SQL Developer to import Excel with date format column into Oracle database. Error from the date column stop the import.
In the preview window, The date column indicate there is date format problem (Date in native language).
SQL Developer import data from Excel to Oracle problem - remove the invisible space from Excel
Today I have to import last year 's sales data into database for sales analytics. the sales data is in excel format. I have to work out a way to import the excel data into Oracle database.
Fortunetly Oracle 's free tools SQL Developer provide an easy way for importing excel data. So I download and setup the Oracle SQL Developer in my laptop.
SQL Developer is very easy to use. I thought I could easily import the data into Oracle database, just right-click at the table and select the menu 'import data', It is wizard guided process that is easy to follow.Read more