SQL Developer is returning only the date, not the time. How do I fix this?
Here’s what SQL Develoepr is giving me, both in the results window and when I export: CREATION_TIME ——————- 27-SEP-12 27-SEP-12 27-SEP-12 Here’s what … Read more
oracle-sqldeveloper
How can I find which tables reference a given table in Oracle SQL Developer?
In Oracle SQL Developer, if I’m viewing the information on a table, I can view the constraints, which let me see the foreign … Read more
How can I set a custom date time format in Oracle SQL Developer?
By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/second) by default. Is there … Read more
How to export query result to csv in Oracle SQL Developer?
I’m using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right … Read more
Oracle SQL Developer multiple table views
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can … Read more
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and … Read more