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
votes
2answers
37 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
39 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
17 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
19 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
26 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
14 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
40 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
66 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
36 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
27 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
69 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
166 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
68 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
59 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
20 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
22 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
294 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
38 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 ...
0
votes
1answer
911 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
85 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
37 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
182 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
295 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
1k 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
90 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
48 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
872 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
306 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
105 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
37 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
72 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
637 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
157 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
181 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
363 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
87 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
541 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
411 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
112 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
168 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
2k 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
390 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
329 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 ...
1
vote
1answer
607 views

Cannot list tables (views, packages etc) from Oracle 11 database using sql explorer, but can see them using PL/SQL Developer

I am connecting to oracle 11 DB. When I connect with PL/SQL, I can explore all the objects : However when accessing this same DB using Oracle SQL Developer, expanding the different objects results ...
0
votes
1answer
305 views

Oracle - Query to join fact table to bridge table and show bridge group rows in one row?

I have a data warehouse with a One-To-Many relationship: "Fact" table contains: Product_Group_ID "Product_Bridge" table contains: Product_Group_ID, Product_ID "Product" table contains: Product_ID, ...
0
votes
3answers
129 views

Connect to oracle 11 on a corporate network via oracle developer 17

Sorry for this absolute oracle noob question: I am in an environment that uses integrated / active directory authentication, for developer to access the oracle databases via an old version 9 PL/SQL ...
0
votes
1answer
3k views

ORA-02292: integrity constraint violated - child record found while creating procedures in ORACLE SQL Developer?

I have written a procedure that has as input the CUSTOMER_ID. Then the procedure deletes the corresponding customer from the table CUSTOMERS. CREATE OR REPlACE PROCEDURE DELETE_CUSTOMER (...