Top "Oracle-sqldeveloper" questions

Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.

Rudimentary issue: basic PL/SQL console output?

I am using SQL Developer and want to output the contents of a variable to the console using DBMS_OUTPUT.…

sql oracle plsql oracle-sqldeveloper dbms-output
ORA-01799: a column may not be outer-joined to a subquery

Here is my query SELECT COUNT(C.SETID) FROM MYCUSTOMER C LEFT OUTER JOIN MYCUSTOPTION CO ON (C.SETID = CO.…

oracle oracle-sqldeveloper
The full pathname of a JDK installation for Oracle SQL Developer

I want to run Oracle SQL Devloper on Ubuntu with this command: sh sqldeveloper/sqldeveloper.sh Then I got this …

java linux oracle ubuntu oracle-sqldeveloper
How can I run Oracle SQL Developer on JDK 1.6 and everything else on 1.7?

How can I run Oracle SQL Developer on a version of Java it supports (1.6) while running Java 1.7 for everything else? …

java sql oracle oracle-sqldeveloper
Exporting a CLOB to a text file using Oracle SQL Developer

I am using Oracle SQL Developer and trying to export a table to a CSV file. Some of the fields …

sql oracle clob oracle-sqldeveloper
Recover unsaved SQL query Scripts in Oracle SQL Developer

I know how to do this in SQL Server thanks to this clever bit of code Use <database> …

sql oracle oracle-sqldeveloper
Add a Column that Represents a Concatenation of Two Other Varchar Columns

I have an employees table and I want to add a third column valued as the concatenation of the first …

sql oracle concatenation oracle-sqldeveloper
Run 2 queries at the same time on Oracle SQL Developer?

I need to retrieve quite a bit of data from our oracle DB and to do so I need to …

oracle oracle10g oracle-sqldeveloper
How to align query in sqldeveloper 4.0?

I have query written in sqldeveloper but I don't know how to align or format the query in neat order. …

oracle-sqldeveloper
How to filter a column in Oracle Sql Developer

Let's say I have some timestamp fields in a column that look like this "02-JUL-14 10.36.07.713000000 PM". Is there a way …

sql oracle-sqldeveloper