Tags » SQL Developer

SQL Developer: Viewing Trace Files

Just a quick plug for looking at raw sql trace files via SQL Developer.

There is a nice Tree View:

Which can be expanded:

Also summary view of statistics, filterable: 21 more words

Oracle

SQL-Developer: Activate logging

In case you want to activate logging in SQL-Developer – here is how:

  1. Close all open SQL-Developer instances.
  2. Find the “sqldeveloper.conf” file
    1. Windows:
      1. goto the directory where the SQL-Developer program is installed.
  3. 77 more words
Oracle

Configure SQL Developer in Windows 8/8.1 [WORKING]

Steps:

  1. Install Oracle 11g database software (download).
  2. Install SQL developer software (download).
  3. Now┬árun sql command line and insert following code: …
  4. 90 more words
Tips And Tricks

SQL-Developer: How to prevent the "Java Heap Space" error

When you are working with a lot of worksheets and reports or try to open large SQL files, you may run into “Java Heap Space” errors. 95 more words

Oracle

SQL Developer providing incorrect query results than TOAD/sql*plus

Some days before I came across very weird issue with SQL Developer. One of the developer in my company was complaining that, she is getting “no rows selected” after executing some select query. 241 more words

Administration

How to solve ORA-01017: Invalid username/password; logon denied

I was trying to connect to a database today when I found this:

I think there could be a lot of reasons for this, but the easiest approach is to reset the user’s password, that is if the user exists of course. 120 more words

How To

Select an XML tag or node using Oracle PL SQL

Hi guys,

I’ve been using this trick for a while and it’s quite useful when querying Oracle Service Bus logs. I found myself trying to explain this one to a colleague and thought it made a nice post :-) 274 more words

Tips