Stack Exchange Network

Stack Exchange network consists of 174 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

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
40 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
93 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
0answers
19 views

Using a git hook to format SQL on a commit?

TL;DR - Could I use Oracle SQL Developer's code formatting tool in a Git commit hook? Me and some team members are working on project involving a lot of SQL. There's unfortunately no agreed upon ...
0
votes
2answers
33 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
0answers
18 views

SQL Server 2012 to Oracle 12c migration

I am very new to Oracle world and I am trying to migrate a SQL Server 2012 database to Oracle 12 using SQL Developer. Looks like I am able to migrate the database successfully as I got a popup saying "...
0
votes
1answer
17 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
98 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
119 views

Oracle SQL Developer Run Statement Bind Variable

I am trying to run the following query using the Run Statement VAR foo VARCHAR2(100); EXEC :foo := 'bar'; SELECT :foo FROM dual; And nothing happened. I can only see the result if I'm using Run ...
0
votes
1answer
34 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
68 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
42 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
88 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
37 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
274 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
81 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
67 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
34 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
17 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
47 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
22 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
887 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
55 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, ...
1
vote
0answers
162 views

How to do Transparent data encryption in sql developer? [closed]

I am using oracle sql developer version 17.2 only and I am trying to encrypt and decrypt a column (credit card number) in my table by using (TDE). I have created the table. I do not know how to do ...
0
votes
1answer
150 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
141 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
223 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
205 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
229 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
83 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
338 views

Problem when inserting Chinese characters in Oracle database

When we insert chinese characters in the table through Oracle SQL Developer, there is no problem. We also can view the Chinese characters as it is, when we do a select statement. But when we insert ...
0
votes
0answers
41 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
0answers
187 views

How to create subtypes/supertypes in ER Diagrams using Oracle SQL Developer?

I am trying to create ER Diagrams using Oracle SQL Developer's Data Modeler. I have an entity super type named HOLDING and I have four other subtypes: BOOK, DVD, AUDIO BOOK, and SOFTWARE... I am ...
0
votes
1answer
329 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
400 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 ...
0
votes
1answer
68 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
687 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
121 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?
-1
votes
1answer
635 views

How to write a function to display the information of employees from a particular department in PL/SQL? [closed]

These are the list of tables I have created and inserted values for the created tables: CREATE TABLE DEPARTMENT (DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR(30) NOT NULL ); CREATE ...
0
votes
1answer
680 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 ...
-2
votes
1answer
59 views

Adding date related constraints on table columns with specific conditions [closed]

I'm using Oracle SQL Developer. Below is the following table I have created: CREATE Screening_Plan ( plan_id NUMBER (4) PRIMARY KEY, movie_id NUMBER (4) NOT NULL, plan_start_date DATE NOT NULL, ...
0
votes
1answer
122 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, ...
0
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 ...
0
votes
0answers
384 views

Oracle cpu usage 100% on windows server 2008R2

I have Oracle Standard Edition 11.2.0.1.0 single instance on Windows Server 2008R2. Today we realized Windows CPU usage was 100% and nobody could connect to database and work until we restarted the ...
1
vote
1answer
374 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
150 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
278 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
2k 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 ...