Tags » SQL Developer

Can not connect to Virtualbox Guest Oracle Database 12c Developer Day Database VM due to Oracle Linux firewall

It seems there’s a firewall present on the latest Developer Days Database image which I’ve just downloaded from Oracle.

Description:

I enjoy using these images because it is a complete reference install of Oracle Linux, Oracle Database and Oracle SQL Developer (among others). 256 more words

SQL

Oracle SQL Developer 4 does not run on Oracle Java 7 on Ubuntu 14.04

Wow, ain’t this awkward :-). I cannot run Oracle SQL Developer 4 (4.0.2) on Ubuntu with Oracle JDK 7..

To be complete: when running SQL Developer with JDK 7 from Oracle itself, displays the following error; 253 more words

Tips

Control OraSASH Repository with SQL Developer

SQL Developer and OraSASH are great tools. That is why I made up my mind to add some reports to SQL Developer to facilitate usage of OraSASH. 186 more words

Reports

Import Report Definition in SQL Developer

Once you have an xml file containing a report definition, this file can be imported in SQL Developer.

Make sure that the view “Report” is displayed. 37 more words

Reports

SQL Developer Report Table Info

SQL Developer is one of my favourite tools for database administration. It is easy to customize and runs on nearly any system. Of course Grid Control is not bad either, but I use SQL Developer more often to analyse a database than Grid Control. 154 more words

Reports

SQL Developer oddity on Windows

Recently, I have come across a bit of a strange behaviour in SQL Developer when verifying the correctness of the data entered into a database from various clients (Linux / Windows / Solaris) -> think of client characterset in NLS_LANG. 194 more words

Characterset

Flow Control: CASE WHEN error using RODBC

I encountered an issue while attempting to read a SQL query using RODBC. In the interest of speed, I wanted to perform a simple calculation from within the SQL statement, something to the effect of “If variable1=0, then 0, else variable1/variable2”. 107 more words

R Notes