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
1answer
246 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
...
0
votes
1answer
187 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 ...
2
votes
0answers
261 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
0answers
118 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 ...
2
votes
0answers
210 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
123 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
vote
0answers
111 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 ...
1
vote
0answers
100 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:
...
