Questions tagged [sqldeveloper]
Oracle SQL Developer is a popular development environment for database architects.
40
questions
0
votes
0
answers
47
views
Sql developer: How do I open more than one tab on the same table
I can pin a tab and open other table in a different tab but selecting the same table always highlights the pinned tab. I want to have two different filters on the same table in two different tabs
0
votes
0
answers
213
views
OneDrive variable in Oracle SQL Developer
We are storing SQL scripts in a shared Onedrive.
Since colleagues have personal and a shared OneDrive I want to use the %OneDriveCommercial% variable.
This one works fine (I run this in Oracle SQL ...
1
vote
0
answers
235
views
How to run a GUI software from terminal, in a non-GUI supported Linux distro?
I have installed CentOS 8 with no GUI support in a virtual machine.
Now I have sqldeveloper and java jdk properly installed on the same virtual machine. Env variables for java have already been set as ...
1
vote
2
answers
2k
views
SSL certificate error when connecting to PostgreSQL database with Oracle SQL Developer on Fedora 30
I have a postgresql 9.3 database running in a RHEL 6.2 kvm virtual machine. It's part of the application I support for work, and I cannot make any configuration changes to the contents of the VM ...
0
votes
1
answer
63
views
SQL Developer - how to assess change to data model
I'm working with a schema I'm not familiar with and am trying to find out if there is a way to do a diff between the state of the data in the schema instance between transactions - does anyone know if ...
0
votes
0
answers
5k
views
Why does Oracle SQL Developer freezes (unresponsive) once I create a new connection?
I have only installed Oracle XE (the latest version 18g) and SQL Developer.
1
vote
0
answers
137
views
Illegal mix of collations error when attempting to view MYSQL table data in Sql Developer using connector/j 8.0.16
In SQL Developer 18.1, I'm trying to view table data in a third party mysql database, but receive the following error for all tables in all 8 schemas on the database.
Illegal mix of collations (...
0
votes
1
answer
643
views
How to change SQLDeveloper's language to Chinese?
I've seen many posts on how to change SQLDeveloper's language to English, by using the following method:
sqldeveloper.exe --AddVMOption=-Duser.language=en
I have tried this method with both English (...
1
vote
1
answer
1k
views
Oracle user - read only to any tables
I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on ...
0
votes
0
answers
677
views
Oracle SQL Developer - load Excel file into sql server
I am trying to import Excel data into a table in SQL Developer.
I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table.
The problem comes when ...
5
votes
2
answers
17k
views
Why can't I open SQL Developer when I have Java 10 installed?
In my Mac terminal:
$ javac -version
javac 10.0.1
I open SQL Developer and get this dialog:
SQL Developer requires a minimum of Java 8. Java 8 can be downloaded
from: http://www.oracle.com/...
0
votes
0
answers
23
views
Is there a way to Store a Query in View/Procedures?
I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer.
It has 2 parameters; start and end date/time.
Is there a way to store this query in a view or procedures and run it ...
5
votes
2
answers
6k
views
Improve SQL developer performance at query builder
I use Oracle SQL Developer (version 17.3.1.279) in Windows 10 64 bit.
It's connected to an Oracle database in the network through TNS.
Whenever I open "query builder" first time for a query, or after ...
6
votes
2
answers
7k
views
no Theme Selector on SQL Developer 17.3
I have been trying to change the theme of SQL Developer, and I am unable to find the theme selector under Environment in the preferences.
has it been removed?
Normally this is where it would be ...
5
votes
1
answer
2k
views
Prevent SQL Developer opening table design on click
I'm using SQL Developer 4.1.5.21 (under Windows 7 Professional 64 bit).
(I've just downloaded latest version (17.3) and the issue is still the same.)
Whenever I click or select a table name in the ...