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
2answers
42 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
154 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
191 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
30 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
38 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
225 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
65 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
100 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
35 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
35 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
288 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
73 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
143 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
51 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
165 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
50 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
414 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
192 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
90 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
35 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
0answers
17 views

Does having multiple PostgreSQL drivers interfere with an Oracle connection to a PostgreSQL database?

I was having trouble exporting data from a PostgreSQL database using Oracle SQL Developer, exporting was slow and would often fail. A colleague suggested changing the PostgreSQL JDBC driver I was ...
0
votes
0answers
24 views

Oracle sql saved my logical model as separate xml files. I want to recover the original logical model

after hours of hard work I saved my logical model using ORACLE sql developer. However, when trying to load up the files i discovered each entity had been saved as a separate xml file. I want to know ...
0
votes
2answers
71 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 | ...
0
votes
0answers
25 views

How to view coordinates instead of geometry object in geometry column in Oracle SQL Developer

I've once found a setting in Oracle SQL Developer, allowing to display the geometry column as coordinates, instead of the generic geometry object name (e.g. MDSYS.SDO_GEOMETRY). I cannot find it ...
-1
votes
1answer
1k 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
173 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
232 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
288 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
267 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
0answers
298 views

Oracle SQl Developer crashed when I double click on the server name

Java(TN) Platform: 1.8.0_144 Oracle SQL Developer version: 17.2.0.188.1159 //////////////////////// When I double click on the server name, it said loading ... the software freezes up. About 15 ...
0
votes
0answers
300 views

Unable to export connections from SQL Developer

I am unable to export existing connection from SQL Developer and while doing that I am getting below error. java.lang.IllegalArgumentException: URI has an authority component at java.io.File.&...
0
votes
3answers
96 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
0answers
43 views

How to make user and access to database in Oracle SQL Developer

I tried to make new user to enter database. But there's an error. Please tell me how can I solve this problem. (Red letters are about the error)
0
votes
1answer
2k 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
458 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
533 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 ...
-1
votes
2answers
80 views

A date column in a table won't save the value after a correct date was entered

I have a table with a column named Shipped Date. It is declared as a column of type DATE and retains NULL marks by default. When I "edited" other columns in the table it worked, but when I entered in ...
0
votes
0answers
840 views

Exporting Bulk or Large data set in SQL Developer

I am using SQL Developer, Oracle 11g client I need to export result of below query into a csv or excel file, issues is when I execute the query and do right click export, then if I select as excel, ...
-3
votes
1answer
179 views

begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end; [closed]

begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end; What does this mean?
0
votes
1answer
816 views

ORA-02436: date or system variable wrongly specified in CHECK constraint

This is the table I have created: CREATE TABLE Ticket_Type ( t_type_id NUMBER(1) PRIMARY KEY, CONSTRAINT check_t_type_id CHECK(t_type_id > 0), t_type VARCHAR(20) NOT NULL, t_type_price ...
0
votes
1answer
147 views

How to translate SQL Server stored procedure into Oracle stored procedure?

This is my SQL Server stored procedure which is below: CREATE PROCEDURE flight_details AS BEGIN SELECT Airline.Airline_No, Airline_Name, Airplane.Airplane_No, Airplane_Name, Flight.Flight_No, ...
-2
votes
0answers
1k views

SQLdeveloper stopped connecting to database after last windows update

After the last update of windows the sqldeveloper application cannot connect to any database, although sqlplus can. The applications can also connect to the database... The output below is for one ...
1
vote
1answer
443 views

Cannot execute job that runs a shell script

I have the following pl/sql script that should execute the shell script script.sh. When I runt the code below In SQLDeveloper I get: Error report - ORA-27370: job slave failed to launch a job of ...
-1
votes
1answer
180 views

Datapump export

I'm trying to export the full database using the datapump API, I tried to use this following code: DECLARE handle NUMBER; nom_job varchar(25) := to_char(SYSDATE,'YYYYMMDD_HH24MISS'); nom_dump ...
0
votes
1answer
338 views

Assignment of dbms_metadata.get_ddl to pl/sql variable fails

I have the followig script declare v_tmp CLOB; begin v_tmp := dbms_metadata.get_ddl('TABLE', 'FOO', 'BAR'); end; Where FOO is the table's name and BAR is the name of the current user. When I ...
0
votes
1answer
3k views

Oracle SQL Developer - Database Diff tables & constraints without table data

I know I can compare two Oracle schemas by using Tools -> Database Diff in Oracle SQL Develop. It will open the following wizard: Which will compare everything you've checked. The problem I'm ...
0
votes
2answers
168 views

Using dynamic date filter causes data not to return

Sorry for the cryptic title, as I'm not sure how to state this question simply. The problem is this, I have a date column, called DTDATE, the data stored in it is of DATE type. When I filter against ...
1
vote
1answer
58 views

One column in a join needs to be unique

I am new to SQL. I have a join which uses three lookup tables. It is a bit complicated so I will publish the code here. Create View TEST As select BDP_INSTITUTION_NAME, BIC, ...
3
votes
1answer
2k views

Oracle SQL Developer: Set the <null> value when exporting to CSV

When exporting to CSV in Oracle SQL Developer, null values are replaced with "". I want them to be exported as the string null. Is this configurable anywhere? Example of what is wished: "STARTDATE"...