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
62 views
SQLDeveloper.exe itself is getting access denied
Installed Oracle 11g and the 11g client. Everytime I start SQLDeveloper it prompts for the java.exe and again which files to associate. It must be trying to save this in registry (or maybe disk). ...
0
votes
1answer
2k views
Can't connect to a Oracle db instance via SQLDeveloper
When I set the connecting information on the GUI in SQLDeveloper I get the following error (everytime!)
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the ...
2
votes
0answers
56 views
Data not showing in English, unless you click on it - In sqldeveloper
I have installed OracleXE and imported data into it. From SQLPLUS, I can query the data and it all shows up in English.
However, in SQLDEVELOPER, if I look at the data, it's in a nonsense format, ...
2
votes
0answers
712 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
270 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
515 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
46 views
ORA-01861 - Input seems ok and FX/FM modifiers not used
Using SQL Developer 4, I am getting an ORA-01861 exception when I do the following (and BTW, I ticked 'Ignore NLS Definitions'):
alter session set nls_date_format = 'DD-MON-YY';
alter session set ...
1
vote
0answers
58 views
Oracle sql developer tree shaped represantation of Explain_Plan
I want to ask what exactly happens to the following Explain_Plan table :
It firsts Joins the two tables Products & Order_Items then the output is joined with Orders and then with the ...
1
vote
0answers
174 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
0answers
23 views
How to import to UNIX the results from a select query?
After a select query i get around 14k records.Rather than exporting them as insert statements into a file and then executing from UNIX, i want to import them to UNIX directly and insert so as to save ...
0
votes
0answers
162 views
Not able to create or modify tables using Oracle SQL Developer with psql driver
So I would like to use the Oracle SQL Developer for managing my postgresql database.
Connecting to that database works fine with SQL developer 4.0.3. I am using this psql driver: JDBC41 Postgresql ...
0
votes
0answers
72 views
Insert a Date or Timestamp into the Editor of SQL Developer
In my Textmate texteditor I can type isoD and hit TAB which results in having the current Date inserted into the carrets current position. I use it a lot when commenting code like
// ...
0
votes
0answers
157 views
Tablespace used on a create table statement
In Oracle SQLPLUS - If I create a table using the statement below via sqlplus logged on as user 'Fred'
CREATE TABLE joe.tablename
(tablename_columnname CHAR(1)) ;
Which tablespace will the table ...
0
votes
0answers
45 views
Debugging long Oracle queries and identifying offending data for 'Expression type does not match a required type' error
I have a long running query with a large number of complex XQueries. This queries used to work but more recently it is giving me
Expression type does not match a required type
error. I suspect ...
0
votes
0answers
56 views
Oracle DB automatic backups
I want to apologize because i believe that this question is already consumed, but please give it a chance. I've started practicing on a Oracle DB 11g XE.
I'm following the tutorial from Oracle Docs ...
