By default, SQL Developer does not display the Time with the date for date columns when running a select statement.
You can change this in the Tools / Preferences dialog of SQL developer:
-
Select Database / NLS Parameters in the tree view on the left.
-
Then put dd/mm/yyyy hh24:mi:ss
into the Date Format field.
-
Press OK to close the dialog.
Enjoy!
This is how to query an Oracle database for Table and Column information. Obviously, you can change these statements to work for what you need.
SELECT TABLE_NAME
FROM USER_TABLES
ORDER BY TABLE_NAME;
SELECT U.TABLE_NAME,
U.COLUMN_NAME,
U.DATA_TYPE
FROM USER_TAB_COLUMNS U
WHERE U.TABLE_NAME = '<Table Name>'
ORDER BY U.COLUMN_ID;