Top "Oracle-sqldeveloper" questions

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

Extract number from string with Oracle function

I need to create an Oracle DB function that takes a string as parameter. The string contains letters and numbers. …

sql oracle oracle11g oracle-sqldeveloper sqltools
insert if not exists oracle

I need to be able to run an Oracle query which goes to insert a number of rows, but it …

sql oracle oracle-sqldeveloper
Oracle SQL Developer and PostgreSQL

I'm trying to connect to a PostgreSQL 9.1 database using Oracle SQL Developer 3.0.04, but I'm not having any success so far. …

postgresql oracle-sqldeveloper
org.hibernate.QueryException: could not resolve property: filename

I am using Hibernate Criteria to get values from column filename in my table contaque_recording_log. But when I'm …

java hibernate oracle-sqldeveloper hibernate-criteria hibernateexception
copy from one database to another using oracle sql developer - connection failed

I am trying to copy a table from one database to another using oracle sql developer. I have the username, …

sql database oracle oracle11g oracle-sqldeveloper
CLEAR SCREEN - Oracle SQL Developer shortcut?

With the aim of reducing mouse activity I was wondering if there was such a command shortcut (eg cls or …

oracle sqlplus oracle-sqldeveloper
How can I insert into a BLOB column from an insert statement in sqldeveloper?

Is it possible to insert into a BLOB column in oracle using sqldeveloper? i.e. something like: insert into mytable(…

oracle blob oracle-sqldeveloper
NLS_NUMERIC_CHARACTERS setting for decimal

I have one db setup in a test machine and second in production machine. When I run: select to_number(…

oracle oracle11g oracle-sqldeveloper
Directly export a query to CSV using SQL Developer

Using SQL Developer to run queries works good, but I would save a lot of time if I instead of …

oracle-sqldeveloper
How to check compiler log in sql developer?

I get this error: Errors: check compiler log How can I see compiler log in Oracle SQL Developer?

logging oracle-sqldeveloper