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
0
votes
1answer
27 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 ...
-2
votes
2answers
38 views

Select data based on XML attributes

My table contain two columns: Branch and data Here's an example: Branch having value finance Data having value xml packet i.e. ...
0
votes
1answer
30 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
28 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
124 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
42 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
18 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
24 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
30 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
16 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
42 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
119 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
59 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
84 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
240 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
364 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
120 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 ...
0
votes
0answers
190 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
37 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
24 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
435 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
55 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
1k 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
103 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
42 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
297 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
50 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
320 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
2answers
2k 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 ...
1
vote
1answer
212 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
49 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
1k 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
427 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
108 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
39 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
118 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
814 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
183 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
287 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
448 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
100 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
578 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
472 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
118 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` ...
0
votes
1answer
38 views

How can I create a trigger that prevents column delete, data deletion and table truncate in the same time?

Having written this trigger create: CREATE OR REPLACE TRIGGER PROTECT_DB BEFORE DROP OR TRUNCATE ON X.SCHEMA How can I "add" a DELETE in the trigger definition ? (the DELETE should prevent data ...
0
votes
2answers
221 views

How to fetch last two year annual data in oracle

There is table named sales_data which I used for my project. The table structure is below: +------+------+------+--------+ | ID | Name | Year | Sales | +------+------+------+--------+ | 1000 | ...
-1
votes
1answer
3k views

Cause of ORA-00902: invalid datatype in my code is?

Here is the code that is throwing the ORA-00902 error: CREATE OR REPLACE PACKAGE collegeManagement IS TYPE ScholarshipHistoryVarray IS VARRAY(10) OF NUMBER; PROCEDURE advancedStudentsTable; END ...
1
vote
1answer
433 views

wrong number or types of arguments in call to X?

Here is the code for which I am getting the error mentioned in the question: CREATE OR REPLACE PACKAGE collegeManagement IS TYPE studId_scholarshipModification IS RECORD(studentID studenti.id%TYPE, ...
0
votes
1answer
360 views

Finding Columns causing errors in SQL Developer

I'm relatively new to Oracle SQL and trying to import CSVs using SQL Developer. I've been getting errors such as Insert failed for rows 1351 through 1400 ORA-01438: value larger than ...