Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
28 views

ORA-28040: No matching authentication protocol in Eclipse project

I recently tried to connect my java program to my Sql data base made on SQLDevlopper, but after downloading & installing in my Eclipse project the ojdbc6 driver I still have the "ORA-28040: No ...
1
vote
1answer
34 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 ...
-1
votes
0answers
45 views

Is their way to automate and schedule an SQL query output to CSV file with timestamp in oracle sql developer [closed]

Is their way to automate and schedule an SQL query output to CSV file with timestamp in oracle sql developer? SELECT * FROM bag_summaries WHERE register_tt between trunc(SYSDATE - 1, 'ddd'...
0
votes
0answers
18 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 ...
-2
votes
0answers
31 views

sql query for previous day data only [closed]

i am using a simple sql query to extract data from previous day. select * from bg_summaries where register_tt like '05-MAY-19%' order by ID; So instead of changing the date, is their an ...
0
votes
1answer
11 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 ...
-1
votes
0answers
38 views

Adding a surrogate key in SQL Developer

I am new to "SQL Developer" and I am creating a logical model. I have a relation that I want to add a surrogate key to. But I couldn't find the method to do that. Could someone walk me through the ...
0
votes
1answer
42 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
82 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
35 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
24 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
15 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
19 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
131 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
28 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
480 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
77 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
30 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
104 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
286 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
1answer
718 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
0answers
47 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
47 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
553 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
175 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
104 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
36 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
53 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
496 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
135 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 ...
0
votes
1answer
192 views

How to create a trigger in oracle to prevent insert dates

I'm learning Oracle and I had a problem. Chat table: CREATE TABLE training ( id_training NUMBER, id_user NUMBER, start_training DATE, end_training DATE ); I want to ...
1
vote
1answer
106 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
288 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
74 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
495 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
348 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
106 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
37 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
136 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
331 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
294 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
483 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
293 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
112 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 (...
0
votes
1answer
576 views

Connect Oracle Database 12c via SQL Developer when it is in restricted mode

I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked. Kindly help ! Added (UR=A) in tnsname....
1
vote
1answer
639 views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
0
votes
1answer
20 views

Padding in info given a types table

Suppose I have the following schema for professions: id, type, likelihood. id is the id of the person in question, and I have info regarding the likelihood that that person will read a certain type of ...