Questions tagged [oracle-sql-developer]

Oracle SQL Developer is a free tool for SQL & PL/SQL development and reporting similar to Quest's Toad or Allround Automations' PL/SQL Developer.

Filter by
Sorted by
Tagged with
1
vote
0answers
13 views

Is there a way to pass tnsname.ora while launching the oracle sql developer Client via command prompt

Is there a way to pass tnsname.ora while launching the oracle sql developer Client via command prompt? Or is there a way to overwrite the usr directory location where the connection.xml folder is ...
-1
votes
0answers
12 views

Unable to connect to database in SQLDeveloper the “Connect” and “Save” button do nothing [closed]

I am running SQLDeveloper on a MacBook Pro macOS version 10.14.6. I add a connection via the 'plus' button. After entering my server credentials the 'save' button does nothing. If I press the 'connect'...
0
votes
0answers
49 views

Exporting SQL query very slow in Oracle SQL Developer

I have written a query and I'm able to run it successfully. When I try to export it, its exporting speed is very slow i.e. 50 rows per 10-15 mins. I managed to export it around 50k data in 10 hours....
1
vote
1answer
50 views

Disable autocommit for DB2 connection in Oracle SQL Developer

I am connecting to the DB2 database using oracle SQL developer, but automatically it is committing, i checked in the advanced menu the auto commit feature is turned off. I am confused now, can someone ...
1
vote
0answers
27 views

Missing CALLs on identifiers_all using PL/SCOPE

Posted this on StackOverflow, but maybe this is the right place for it: I'm trying to use the view all_identifiers from PL/SCOPE to find out calls to procedures and functions but it's not showing all ...
0
votes
1answer
313 views

Connection Error while connecting SQL Developer with DB2

I am trying to connect Oracle SQL Developer with DB2 Database. I have added db2jcc4.jar, db2jcc.jar and db2jcc_license_cu.jar Libraries in "Third Party JDBC Driver" DB2 tabs appears Entered Username ...
0
votes
1answer
165 views

Can't connect through sqldeveloper because locale not recognized even though my language/regional settings are English/US

On a certain machine I consistently cannot connect to an oracle db due to the locale not being recognized: Other people have noted the locale or language settings may not be compatible with the ...
0
votes
1answer
35 views

write SQL query that takes its own output as input

In a table that displays how trades are related to each other, starting from one trade, I want to find all other trades that relate to the first trade: 713613 PostPTETradeIDs 718478 713613 ...
0
votes
1answer
36 views

I didn't get listener file get installed

I have downloaded oracle sql developer to access Remote database. After downloading i couldn't connect to the database. I don't have tns.ora file installed in my system neither do i have oracle_home. ...
-1
votes
2answers
1k views

How to check sql query execution time in sql developer

I need to check any sql Statment exact execution time (how much time it will take to complete that sql Statment without running this query) in Oracle sql developer tools without running that sql ...
0
votes
1answer
78 views

How to view databases and tables after 'imp' import using Oracle SQL developer

Maybe that's a wrong form of answer... The problem is: I've got an Oracle database dump file (very old, created with imp utility) At last, I've imported it. The command was imp file=E:\Downloads\...
0
votes
1answer
112 views

See other schema's tables in SqlDeveloper

When I connect to an Oracle DB with user XXX I see the tables, packages, etc. in schema XXX. Is there a way so that I can connect with user XXX and see things in another schema YYY? When I browse ...
0
votes
1answer
53 views

How to build a query that gets its values from a file

I'm trying to build a query that uses the values in a file select Epm,Emp_num,Emp_Addr From Dir_Rimco_Table where Emp in (Dir_Emp_Rsed.txt) Constraints -I can't create a new table -I can't modify ...
0
votes
0answers
32 views

How to set a specific time for a query to run?

I created a table in Oracle sql developer, then I wrote an INSERT statement to insert data into the table from an existing table. How can I make the INSERT query run automatically on a daily basis to ...
1
vote
0answers
34 views

Is it possible to execute “begin transaction” when connected to MS SQL server with Oracle's SQL Developer?

I am using Oracle's SQL Developer to execute SQL statements on an MS SQL Server instance. Apparently, SQL Developer recognizes specific Oracle related keywords such as begin. Thus, when I try to ...
0
votes
0answers
21 views

Remove Leading and Trailing Spaces in an Entire Column in Excel

account number is 16 digit when we are downloading excel template account number is truncated and showing 1933E+0037 so we have given to_char(account_number)||' ' its working when we are downloading ...
2
votes
1answer
59 views

Oracle isn't restoring correctly a backup

First of all I'll say I'm using: Oracle Database 11g Express Edition Oracle SQL developer What I'm trying to achieve Create a backup and restore it, so for example I can delete a table after a ...
2
votes
1answer
257 views

Missing right parenthesis after (or before) default 0, Oracle

I am trying to create a table with Oracle SQL where two columns of the table should have a default value and should not be NULL. I am getting the error you can see below, but i am not able to ...
0
votes
0answers
83 views

Can SQL Developer be used with the Athena JDBC Driver

I'm trying to connect to Athena using the JDBC drivers provided by Amazon, and using SQL Developer as the client. So far, I haven't had any luck with Java 1.8.181 and AthenaJDBC42-2.0.7.jar Has anyone ...
0
votes
1answer
210 views

SQL Developer export/import SSH hosts

Is it possible to export/import ssh hosts from SQL Developer? The hosts are listed under C:\Users\name\AppData\Roaming\SQL Developer\system17.4.0.355.2349\o.sqldeveloper.ssh but I don't find a way to ...
0
votes
1answer
961 views

How to force SQL developer to use imp/exp command while import/export

While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp ...
0
votes
1answer
1k views

Not all variables bound ORA-01008: not all variables bound error

I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, ...
0
votes
1answer
283 views

How to rearrange columns in Oracle SQL Developer script output

maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet. So I have created a table in Oracle and when running the SELECT ...
1
vote
1answer
747 views

“New query window” shortcut for Oracle SQL Developer

I'm used to Ctrl-N to give me a new query window in SSMS. How do I do it in Oracle?
0
votes
0answers
94 views

sql developer pop up is not responsive

I use SQL Developer version 17.3.1.279. I try to save a file with File > Save. When the 'save' window opens, it is unresponsive, meaning that: the 'location' combo is not clickable icons such as ...
0
votes
0answers
26 views

Extra tables automatically created [duplicate]

I'm seeing a lot of extra tables in oracle db. I'm wondering what or who created these tables. If anyone has any idea please share with me. Anyway to know from which ip address it got created? Also ...
0
votes
0answers
711 views

Help with Connecting to SQL Server using Oracle SQL Developer

I am trying to connect to SQL Server using Oracle SQL Developer. I was able to get the SQL Server JDBC installed on SQL Developer and am able to see the SQL server Tab on the Connections page. I have ...
0
votes
1answer
101 views

Migration from MySQL to Oracle generates empty tables

I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I ...
1
vote
1answer
2k views

ORA-01017 Invalid Username/Password in SQL Developer

I installed Oracle 18c XE and SQL Developer 18.4, both are the latest. Logged in with SYSTEM and created a user vbk in SQL Developer. I see the user running select * from dba_users, but when I try ...
0
votes
2answers
133 views

Welcome message for oracle schema

I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only
0
votes
0answers
67 views

Restrict Oracle database schema to login using Toad/PLSQL [duplicate]

I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
0
votes
1answer
682 views

configure sql developer for oracle using IPC fails with network adapter error

I have oracle 11 XE installed locally. I can connect on the same machine using sqlplus with sqlplus user/pass. I can also connect using sqlplus user/pass@XE (XE is defined in tnsnames.ora and this ...
0
votes
2answers
51 views

Long query causes problems

I have a huge sql query which causes problems: select distinct subjectnr from proces where (produkttypenr = 1 or produkttypenr = 3 or produkttypenr = 4 or produkttypenr = 5 or produkttypenr = 9 or ...
0
votes
0answers
365 views

Critical error and failing to parse data returned by server

I am currently running Oracle 12c, but unfortunately I am getting this critical error message: Fail to parse data returned by server I have never seen this error before and every attempt at ...
0
votes
3answers
3k views

sqlplus SP2-0341 (line overflow during variable substitution)

I want to export an Oracle database to a file and i'm using SQLDeveloper on Windows for that (the resulting SQL text file is about 35MB). This results in very long lines. I hit a snag when importing ...
0
votes
1answer
385 views

sqldeveloper file open dialog freeze

When I try to open a file using the file open dialog, sqldeveloper freezes for almost a minute. After that the dialog opens at the user temp folder. I think it is trying to access some unavailable ...
1
vote
1answer
50 views

Get last ID of repeated values based on type and most recent sequence

As I am learning sql I am stuck on this one: I have this table: I am trying to get to this table: The criteria is pick any ID that has Type A and its grade based on the most recent seq.
2
votes
1answer
2k views

TimeZone problem with Oracle SQL Developer for Windows on MySQL server

I am trying to connect to a MySQL database using Oracle SQL Developer, but I get this error: Status: fail, test failed: Estado: Fallo:Fallo de la prueba: The server time zone value 'PDT' is ...
0
votes
1answer
997 views

Unable to connect to oracle database. Getting ORA12505 error

I am newbie to ORCALE I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help An error was encountered ...
2
votes
2answers
113 views

How can I insert records in a table that are dependent on other tables?

I have 3 tables: table1: Employee_class(PK), Executive_lounge, Executive_washroom, Supply_closet, Employee_lounge, Server_room, Server_closet table2: Emp_id(PK), LName, Years_of_service, ...
0
votes
2answers
46 views

SQL Developer: choose the tablespace where a new table will be stored [closed]

When creating a new table, is it possible to specify the tablespace where the table is going to be stored?
0
votes
1answer
201 views

Oracle SQL Developer: 'All Source Lines' in 'Find Database Object'

What's in 'Find Database Object' the difference between Search for %pattern% AND All Source Lines In which area's does Search for %pattern% search for, if not in All Source Lines ...?
0
votes
1answer
1k views

SQL Developer code 'Advanced Format' versus 'Custom Format'

Preferences -> Code Editor -> Format -> Advanced Format versus Preferences -> Code Editor -> Format -> Advanced Format -> Custom Format As I understand, both are alternative options to (re)format ...
0
votes
1answer
238 views

Creating an insert trigger on views

My table definitions look like this: I've created a view as: users_questions(qid,username,question) I want to create an instead of trigger on the view which puts the data going to be inserted on ...
1
vote
1answer
614 views

Can't connect to local database

Today I created a local database on my computer. Then I installed SQL Developer. But I can't connect. It gives me this error: "Status : Failure -Test failed: Locale not recognized" My database ...
0
votes
1answer
686 views

Oracle SQL Developer equivalent of “SELECT TOP xxx ROWS” in SQL Server

In SQL Server, we have the functionality of "SELECT TOP xxx ROWS" when we right click a table: This will generate a SELECT statement with all the columns in selected table written in the new SQL ...
0
votes
1answer
209 views

Oracle SQL: How to give user the permissions to SELECT from a table?

I'm not very familiar with Oracle SQL at all, but using our admin account I ran the following query on our Oracle database server: GRANT SELECT ON Table1 TO OtherUser. I then committed this change (...
1
vote
1answer
671 views

how to connect SQL server from oracle in SQL developer

I have two connections in SQL developer that one of them is SQL server (A) and the other one is oracle (B). how can I make a database link between this two connections from (B) to (A) to select ...
0
votes
1answer
597 views

How to create lots of SQL-Developer Connections quickly?

I wonder if there is a way to create lots of SQL-Developer connections in "one shot" ? Eg: By modifying a config file or password file.
1
vote
1answer
140 views

“Error while processing statement” running a query finding unique values with multiple values in other rows

Is there anything wrong in the syntax of this query finding unique values with multiple values in other rows? Select Distinct Ss.`cd`, Ss.`cd` From nit.assrr As Ss Join ( Select `cd` ...