Stack Overflow
Stack Overflow

Questions tagged [oracle-sqldeveloper]

Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.

Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

6220 questions
392
votes
8 answers

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 this tool. What is the process for creating an ER diagram in SQL Developer?
Breezescut
  • 4,021
  • 3
  • 12
  • 4
250
votes
3 answers

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 add, delete, edit or just viewing records of table currently viewd the problem is that we often really need to view more than one…
user232627
  • 2,501
  • 2
  • 14
  • 4
248
votes
6 answers

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 clicking on the query results window doesn't give me any export options.
Ken Liu
  • 21,056
  • 17
  • 71
  • 96
213
votes
10 answers

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 keys (and thus which tables are referenced by this table), and I can view the dependencies to see what packages and such…
Rudd Zwolinski
  • 23,948
  • 17
  • 54
  • 60
210
votes
9 answers

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 a way to configure this within Oracle SQL Developer?
ComfortablyNumb
  • 3,101
  • 2
  • 12
  • 15
182
votes
8 answers

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 another piece of software running the same query/db gives: CREATION_TIME …
Xonatron
  • 14,362
  • 28
  • 65
  • 83
156
votes
10 answers

How to Execute SQL Server Stored Procedure in SQL Developer?

I've been given a user account to a SQL Server database that only has privileges to execute a stored procedure. I added the JTDS SQL Server JDBC jar file to SQL Developer and added it as a Third Party JDBC driver. I can successfully log in to the…
sdoca
  • 7,402
  • 21
  • 65
  • 119
145
votes
14 answers

Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command error When I hit run script,…
Bob
  • 2,418
  • 4
  • 21
  • 18
140
votes
5 answers

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have…
Peter Lang
  • 50,721
  • 26
  • 139
  • 153
135
votes
7 answers

How can I change the language (to english) in Oracle SQL Developer?

I am running a non-english Windows 7 system, and apparently Oracle SQL Developer (version 3.0.04.34, 64-bit) tries to auto-guess my preferred language based on the OS. Is there any way to change the language to english? I've tried the tip found at…
simon
  • 11,971
  • 24
  • 73
  • 108
117
votes
5 answers

How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert…
Zo72
  • 13,193
  • 16
  • 65
  • 98
117
votes
4 answers

How to avoid variable substitution in Oracle SQL Developer with 'trinidad & tobago'

When I try to execute this statement in Oracle SQL Developer 2.1 a dialog box "Enter Substitution Variable" pops up asking for a replacement value for TOBAGO, update t set country = 'Trinidad and Tobago' where country = 'trinidad & tobago'; How can…
Janek Bogucki
  • 4,642
  • 2
  • 26
  • 38
106
votes
8 answers

Printing the value of a variable in SQL Developer

I wanted to print the value of a particular variable which is inside an anonymous block. I am using Oracle SQL Developer. I tried using dbms_output.put_line. But it is not working. The code which I am using is shown below. SET SERVEROUTPUT…
988875
  • 1,387
  • 3
  • 10
  • 12
93
votes
7 answers

Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin I'm using the following format in tnsnames.ora: dev = …
Americus
  • 1,147
  • 2
  • 9
  • 13
91
votes
8 answers

Print text in Oracle SQL Developer SQL Worksheet window

I am using Oracle SQL (in SQLDeveloper, using the SQL Worksheet). I would like to print a statement before my select, such as PRINT 'Querying Table1'; SELECT * from Table1; What do I use to Print / show text output? It's not Print, because that…
thursdaysgeek
  • 7,260
  • 18
  • 72
  • 104
1
2 3
…
99 100