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 another piece of software running the same query/db gives: CREATION_TIME ——————- 2012-09-27 14:44:46 2012-09-27 14:44:27 2012-09-27 14:43:53 How do I get SQL Developer to return the time too? 8 Answers 8
In Oracle SQL Developer, if I’m viewing the information on a table, I can view the constraints, which let me see the foreign keys (and thus which tables are referenced by this table), and I can view the dependencies to see what packages and such reference the table. But I’m not sure how to find … Read more
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 a way to configure this within Oracle SQL Developer? 9 Answers 9
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 clicking on the query results window doesn’t give me any export options. 6 Answers 6
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd the problem is that we often really need to view more than one table at once, then we need more than … Read more
I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer? 9 Answers 9
