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
111 views
Exporting 30 million rows to CSV
I have a query that hits multiple tables in an Oracle database (11g). I don't have access to the server itself. I use SQL Developer or SQL*Plus to connect.
There are about 31 million rows, and 7 ...
1
vote
0answers
109 views
Registry error while trying to install Oracle 11g on Win 2008 R2
I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time...
It gives me error when updating registry key ...
-1
votes
2answers
72 views
Combine two SQL statements to a single statement [closed]
My question is related to SQL. I need to pull values from two different tables. I am not successful in doing that. I am able to join the two tables with only a single condition but not many values ...
3
votes
1answer
79 views
Where's my Network Alias list in Oracle?
I can't select any Network Alias from the Network Alias Drop-down.
My TNSNames.ora file is in C:\Oracle
My other machine that is a fresh install doesn't have this problem.
I get an error when I ...
0
votes
1answer
79 views
can not execute LIMIT on sql Developer
I am trying to execute following on sqlDeveloper
SELECT salary FROM emp ORDER BY salary DESC LIMIT 4, 1;
But it is throwing following error:
ORA-00933: SQL command not properly ended
00933. 00000 ...
2
votes
1answer
217 views
Can't return data from SQL/Plus and Toad but can from SQL Developer
This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select ...
0
votes
1answer
170 views
How to connect to a Database made by Oracle SQL Database?
So I am fairly new at this, so if you could keep that in mind in your answers, it would be much appreciated. I installed Oracle SQL Database on my Windows PC. It came in two zip files. I installed it ...
1
vote
0answers
107 views
PeopleSoft or Oracle App Designer Tool Alternative
We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
0
votes
1answer
17 views
viewing Original Object under synonyms
I have certain synonyms in my schema which represent views from another schema. Now in oracle sqldeveloper, I am unable to see the actual SQL for those views but I see only an SQL like:
CREATE OR ...
3
votes
1answer
238 views
SQL developer: Setup debugger for plsql
I'm trying to debug remotely pl/sql. But I can't - database returns me an error. What should I do to fix this and start debugging ?
ORA-30683: failure establishing connection to debugger
...
3
votes
1answer
357 views
halt on error in a sqlplus script
I am deploying pl/sql code using several sql files that are called with @@file.
If a package got a compilation error the script continues to the end.
Is there a way to stop on every compilation ...
0
votes
3answers
363 views
ORA-00905: missing keyword when trying to create a synonym
I have a problem when I try to create a synonym like this:
CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET
FOR [email protected];
Why does this happen and how can ...
0
votes
1answer
420 views
Need to count records and group count by date on Oracle
I have a table like the following
ID created sent type
-----------------------------------------------------
0001463583000051783 31-JUL-12 1 270
0081289563000051788 ...
2
votes
0answers
254 views
Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?
Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...
2
votes
1answer
941 views
Oracle not available error with Oracle XE 11.2.0-1.0
I have downloaded Oracle XE 11.2.0-1.0 and installed it on a CentOS 6.3 virtual machine with 1.5GB memory and 3GB of swap.
SYS and SYSTEM set to have password 123456. I have set ...
2
votes
0answers
117 views
Oracle sqldeveloper Database Diff - not seeing indexes/sequences
I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
1
vote
1answer
315 views
How can I import Create Table Statement from SQL Developer into Visio to create an Entity Relationship Diagram?
I have the following Create table statement from SQL Developer and I am trying to generate an ERD Diagram using 2003 Visio. I was wondering what I need to do to convert the Create Table from SQL ...
3
votes
1answer
1k views
Disable autocommit for SQL Server connection in Oracle SQL Developer
I am using Oracle's SQL Developer to execute queries against my SQL Server 2008 database as I simply can't work with SSMS as long as it doesn't support Ctrl + Return to execute statements...
Anyway, ...
-4
votes
1answer
1k views
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]
EMPLOYEES TABLE
COLUMN NAMES:
EMPLOYEE_ID
EMPLOYEE_NAME
EMPLOYEE_LASTNAME
JOB
EMPLOYEE_BUSINESS_PHONE
EMPLOYEE_GSM
SALARY
HIRE_DATE
E_MAIL
DEPARTMAN_NO
NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
2
votes
0answers
207 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
1
vote
0answers
98 views
Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x
I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message:
...
0
votes
1answer
540 views
ORA-01031 Insufficient Privileges Raised From Within Function
When I run a CREATE USER statement within Sql Developer, the user is created just fine. When I try to call a function which performs CREATE USER (followed by a bunch of other statements) I get the ...
2
votes
1answer
4k views
SQL Developer cannot connect to Oracle database, yet sqlplus can!
I am having a problem connecting sql developer to my Oracle 10g database. sqlplus is able to connect fine, but when I try to open the connection in sql developer, I get 'ORA-12514 TNS does not know ...
3
votes
1answer
5k views
Create dump file using Oracle SQL Developer
I think I'm missing a simple point, but I couldn't find a way to use Oracle export (exp/expdp) and Oracle import (ipm/impdp) with Oracle SQL Developer (version 1.5.5)? Is there a way for it?
If ...
8
votes
3answers
427 views
How does Oracle know who I am?
Slightly unimportant but it's piqued my curiousity.
I've just logged into an Oracle 10g database for the first time using the Oracle SQL Developer Tools.
I used a generic user login which isn't my ...
1
vote
1answer
2k views
Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper
I have following example query.
variable pStartDateBegin VARCHAR2(10);
variable pEndDateFinish VARCHAR2(10);
begin
select '01-01-2000', '30-11-2011'
into ...
8
votes
2answers
1k views
Script out Oracle DDL in an automated fashion
Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention.
I know of DBMS_METADATA.get_ddl(), but have found that the ...
1
vote
2answers
3k views
How to connect to a local server in Oracle SQL Developer like SQL*Plus with no TNSlistener?
How can I use SQL Developer to connect to a local Oracle 11g server? I didn't enable TNS Listener, but SQL*Plus works well.
@update1:
I copied all *.jars from ...
4
votes
2answers
3k views
Oracle - Automate Export/Unload of Data
Oracle SQL Developer has an option to export the contents of a query result to various formats (CSV/fixed width/Excel/XML). Is there any way to automate it?
If not, what free tools are available ...
1
vote
1answer
115 views
Can SQL profiles be deployed to other Oracle Databases?
When using The SQL Tuning Advisor in SQL-Developer. I get often some recommendations to accept a SQL-Profil. I guess it is a good idea to do so.
But is this similar to proposed indexes, which I can ...
5
votes
2answers
943 views
I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
When trying to use the SQL Tuning Advisor from SQL Developer I get this error.
Tuning advisor was working some days before.
