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.
-3
votes
0answers
11 views
oracle db 12c and java db and postgreSQL are they the same? [on hold]
This a question for the sake of my personal knowledge. In order to utilize database connectivity for java EE applications which of the 3 three databases are useful and more popular or are 3 of them ...
0
votes
0answers
18 views
toad and sql developer
I am having a problem logging in in SQL Developer..
I tried to log as HR then my password in SQL Developer but authentication fails.
But when I try to log in Toad for Oracle, it works.
Any ideas?
0
votes
1answer
29 views
Is it best practice to install client tools (like Oracle SQL Developer) on the database server or another machine?
A company doing a code review asked for credentials to an Oracle database server. They logged in but soon came back asking where SQL Developer was located, stating that they couldn't find it in the "...
1
vote
1answer
47 views
Keystroke duplicating in data grid
The issue that I am experiencing is easy to reproduce.
When attempting to update the data of a row using the data tab of SQL Developer the cell will receive the first letter twice.
This happens "...
3
votes
3answers
80 views
Oracle 12c: textual search over all PL/SQL code
I want to do a text search over all PL/SQL functions/procedures in my DB to see which code is calling a particular function. Is there a tool in SQL Developer for that, or a meta-table under the system ...
-1
votes
1answer
88 views
Unable to see list of tables in Oracle SQL Developer
I am using SQL Developer and now I can SELECT but viewing those tables in the list is not available. Is there some configuration I need to do in order to see the tables? User has select all tables ...
0
votes
1answer
52 views
show con_name not working in SQLDevelopper
I typed show con_name; in sqlDeveloper but the result is the following error : SP2-0158: unknown SHOW option "con_name" ... Other commands like Show user; work perfectly. I tried in sqlplus and no ...
2
votes
1answer
104 views
Migrate Sql Server 2014 to Oracle 12c: best options
I need to migrate an Sql Server 2014 database across to Oracle. The best option is to use SQL Developer which comes with the migration tool.
Having gone through the steps described it fails due to ...
0
votes
0answers
63 views
Error while opening SQL worksheet in SQL Developer
I am facing the following issue while opening SQL worksheet in SQL developer
Popup with Error Message --> "An error occurred while opening ide.worksheet.file:/C:/users/%USERNAME%/Appdata/Local/Temp/...
0
votes
1answer
74 views
How can I (re-)create the Entity Relationship Diagram (ERD) of an existing hidden Oracle database?
More precisely, I wan't to re-create the database model / schematics / the Entity Relationship Diagram (ERD) showing all the links between the tables of this existing hidden Oracle Database.
In my ...
1
vote
1answer
70 views
Oracle SQL Developer: Copy paste tables, with 2 different instances, with different table structure
Here I have 2 difference instances, one is called DEV and one is called SIT2. I created a public database link, called DBLINKSIT2(Basically just to create a bridge between DEV and SIT2) and I need to ...
0
votes
1answer
613 views
ORA-01017: invalid username/password; logon denied from sql developer but sqlplus logins
I've a strange behaviour of Sql Developer with OS Authentication, 4.1.3 32/64bit, gives ORA-01017 while sqlplus is logging in without any problem.
This is the example answer sqlplus gives me:
~ ...
0
votes
1answer
24 views
cant access both phone numbers in my nested table type
Im using Oracle Developer and I have a customers table where each customer has 1 home-phone number beginning with 0131 and either 1 or 2 mobile numbers. I am trying to display the customers name and ...
0
votes
1answer
31 views
Cannot create a database connection SQL Developer
I will try to explain the current situation in the best possible way.
Well, I got a VM with SQL Developer already installed but could not run properly. After some reasearch, I solve the problem ...
1
vote
0answers
121 views
Can't run procedure on Oracle SQL Developer [closed]
Since yesterday, I have not been unable to run procedure on Oracle SQL Developer. When I click on Run button, progress bar with "Launching" text appears on the right bottom corner of the SQL Developer,...
0
votes
1answer
55 views
SQL Developer auto trace does not show cascading deletes
I'm trying to understand the performance characteristics of SQL statement that does DELETE cascade on 4 linked tables.
When I do the auto tracing of the statement it only shows me the DELETE ...
0
votes
1answer
511 views
How to configure sql developer with oracle 12c?
I'm trying to connect sql developer to a fresh installation of oracle:
I can connect to sys user via sqlplus
I can connect to sys user via sql developer when I select Connection Type "Local\Bequeath"....
2
votes
1answer
143 views
Oracle Triggers - before any UPDATE or DELETE or INSERT
I am trying to create a database trigger in Oracle SQL Developer that would fire before any UPDATE, DELETE, or INSERT statement occurs on the sessions table.
My sessions table:
CREATE TABLE sessions ...
0
votes
1answer
35 views
Return output of Oracle query
How to change below query to see results of my_sql (now I see only query, not it results) in SQL Developer?
DECLARE
my_sql VARCHAR(1000);
BEGIN
FOR t IN (SELECT t.table_name, t.owner FROM ...
1
vote
1answer
476 views
Importing .dmp file into SQL developer: Do I need to import seperately for each table?
I have a large .dmp file which I would like to import into SQL developer. This contains all the data I want to import across several Schemas.
Do I need to split this up into each separate table in ...
1
vote
1answer
192 views
no more data read from socket error with triggers
I have created one trigger that calls one procedure, using oracle sql developper. Here is the code for trigger :
CREATE OR REPLACE TRIGGER noteTrigger
BEFORE
INSERT OR
UPDATE OF valoare OR
...
0
votes
0answers
52 views
Sql developer how to copy to another tablespace [duplicate]
When copying database using SQL Developer it complaints that the source tablespace does not exist on destination database.
How can I copy schema and data from Database A tablespace t1 into Database B ...
0
votes
0answers
73 views
Oracle SQL Developer 3.2.09 is consuming lot of memory on windows 7
Oracle SQL Developer Version 3.2.09 is consuming lot of memory on windows 7.
I can see, after 1/2 days of usage and without closing the this application, the memory consumption is going upto 700 MB. ...
0
votes
1answer
535 views
ORA-00942: table or view does not exist- Can it be solved by granting privileges to user?
I am creating a Java application that connects to an Oracle Database.
In the application I connect to the DB as User A, which works as intended.
I then try to access tables in Schema 1 and Schema 2....
0
votes
1answer
40 views
Can't get update one prompt for same variable over multiple tables
I've tried using the following:
select * from TABLE1 where COLUMN= :VAR
union
select * from TABLE2 where COLUMN= :VAR;
I'm getting the following error message back:
[Teradata Database] [TeraJDBC 14....
-1
votes
1answer
919 views
Does PL/SQL code run differently in sql plus vs sql developer?
Today, I stumbled upon a question someone posted about the / character and ; character. The Answer doesn't seem to be down-voted, so I questioned it a little more as to why it wasn't down-voted. ...
0
votes
1answer
183 views
What is the name of the default schema in Oracle?
When you create an object in Oracle, and do not specify a schema (object prefix), is there a name for that default schema? I see in Oracle SQL Developer, that a newly created object shows up in the ...
1
vote
1answer
2k views
ORA-29913 and ORA-30653 error selecting an external table
I created an external table using a .tbl file and now Im trying to select all rows from that table, using:
select * from users_load;
But Im getting this error:
ORA-29913: error in executing ...
0
votes
1answer
455 views
Load data from flat file into oracle table [closed]
I created a new database, then created a table "users". Now, I'm trying to load data to this table from a flat file called 'users.tbl', that has some records with the following format:
1|john|email@...
0
votes
1answer
341 views
How do I kill a non-running impdp job?
I am trying to run an import operation into an Oracle 11G R2 database from a .dmp file using SQL Developer 4.1's Data Pump Import Wizard. I set everything up with IMMEDIATE start, but then the job ...
0
votes
0answers
680 views
How do I open Data Pump Import Wizard in SQL Developer 4.1?
How do I find and open the Data Pump Import Wizard in SQL Developer 4.1?
I opened the Help search tool in SQL Developer 4.1 and searched for Data Pump, and found directions that include:
1.) ...
3
votes
1answer
116 views
Global command to destroy all disconnected data files in Oracle 11g
Is there a global command to delete/purge all disconnected .bdf files in an Oracle 11g R2 database?
Here is the scenario:
Every user-defined user and user-defined tablespace was deleted from an ...
0
votes
1answer
321 views
How can I launch SQL Developer?
I recently installed Oracle 11g R2 on a Windows 8.1 machine, but for some reason SQL Developer does not seem to launch easily. What specific steps do I need to take in order to launch a working SQL ...
1
vote
1answer
68 views
Need help to construct query/pl-sql block to get DB table column name and query result as key-value pairs
I have a DB table has more than 50 columns.
I am querying this table, it should return only one row any time. as below image from sqldeveloper.
here I need to construct query/pl-sql block, to find ...
-1
votes
1answer
38 views
function execution related question
Create or replace function funleap(a number)
return varchar2
is
b2 number(5);
b3 number(5);
b4 number(5);
begin
b2:=mod(a,4);
b3:=mod(a,100);
b4:=mod(a,400);
if ((b2=0 and b3&...
1
vote
1answer
52 views
/ Character in a stored procedure
I am trying to recompile/update a stored procedure in SQL Developer that uses a few division operations to populate tables.
A sample section looks like this:
Insert Into Production(A, B, C)
...
-2
votes
1answer
76 views
plsql block not executing
I am unable to execute this block. it just compiles. what statement I have togive to see output. where I am doing error ? I clicked on output button also
-1
votes
0answers
32 views
Get the sum of Total Churn_MTD(Current+2015+<2015) [duplicate]
how to declare 8 variables and get the total Sum,as you can see from the picture i created the 3 store procedures but dont know how to do the rest(Churn_MTD_Current_Year+Churn_MTD_Previous_Year+...
0
votes
2answers
210 views
unable to connect to oracle in linux terminal in oracle VM ,TNS listner not connected
i installed oracle VM , new to oracle vm.
Can some help me in connecting to oracle in Linux termial and TNS listner is not responding with IO failure on sql developer when pressing test button ....
6
votes
2answers
227 views
Precision of NVARCHAR2 column is 1.5 times lower than displayed by desc command
I wanted to update precision of an nvarchar2 column and came across an interesting case. I have tried to replicate it below:
create table test_table1
(col1 nvarchar2(100));
table TEST_TABLE1 ...
3
votes
1answer
132 views
In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable:
In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable:
define my_schema_name = 'schema_1';
CREATE OR REPLACE PROCEDURE my_schema_name....
2
votes
1answer
79 views
I need to update a Oracle procedure via a .sql script
I need to update a Oracle procedure via a .sql script. I know the procedure works because it is currently running on our server, but I need to update the procedure on a client's box.
I need to be ...
1
vote
1answer
112 views
Set uncommitted read as default in Oracle SQL Developer with DB2 database
I am using SQL Developer with a IBM DB2 database. I am only querying the data for analytical purposes - never making any updates, additions or deletions. I was wondering if there is a way to ensure ...
1
vote
1answer
328 views
SqlDeveloper: ora-12505 TNS listener does not currently know of SID given in connect descriptor
Info
connection name: ziv
username:sys
password: xxxxxxx
connection type: basic
role: sysdba
host name : localhost.localdomain
port: 1522
sid: ziv
The QUAST is to connect to the database ...
0
votes
1answer
2k views
Oracle 11g: SQLDeveloper |status: failure-test failed: IO error. connection reset|
part 1
new / select database connection
info
connection name: ziv
username:oracle
password: xxxxxxx
connection type: basic role: sysdba
host name : localhost.localdomain
port: 1158
sid: ...
1
vote
2answers
104 views
Fetching recent/historical queries run on a database from an application
I'm getting some database errors from an application related to unique constraints however none of the records have any duplicate values so I want to check what query was run that produced the error.
...
0
votes
1answer
2k views
How to call an oracle stored procedure in sql developer tool
I have written an Oracle procedure like below:
create or replace procedure Sp_emp(cv_results out sys_refcursor)
is
begin
open cv_results for
select *
from employee;
end;
/
...
1
vote
1answer
29 views
Find out where length semantics gets changed
I've code to create tables that doesn't specify length semantics:
CREATE TABLE CHAR_TEST (
CHAR_TEST_ID NUMBER(*,0) NOT NULL,
FOO VARCHAR2(6) NOT NULL,
BAR VARCHAR2(6) NOT NULL,
...
0
votes
0answers
780 views
PL/SQL to find Special Characters in multiple columns and tables
I am trying to come up with a script that we can use to locate any special characters that may exist in a column of data except for period, dash or underscore, and using variables.
My Data - ...
3
votes
2answers
14k views
sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor
There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each.
I have installed oracle 12c in ...
