Top "Oracle" questions

Do I need to create indexes on foreign keys on Oracle?

I have a table A and a table B. A has a foreign key to B on B's primary key, …

sql oracle indexing

Oracle: Insert rowtype data into another table

I have one table called event, and created another global temp table tmp_event with the same columns and definition …

oracle plsql insert rowtype

Can Foreign Key be null?

In our database project we have a table Sale that has an primary key and two exclusive foreign keys: Vehicle_…

sql oracle database-design foreign-keys data-integrity

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

Oracle doesn't remove cursors after closing result set

Note: we reuse single connection. ************************************************ public Connection connection() { try { if ((connection == null) || (connection.isClosed())) { if (connection!=null) log.severe("Connection …

java oracle jdbc cursor resultset

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

How to populate a timestamp field with current timestamp using Oracle Sql Loader

I'm reading a pipe delimited file with SQL Loader and want to populate a LAST_UPDATED field in the table …

oracle sql-loader

PL/SQL exception handling: do nothing (ignore exception)

This is a question I am asked very frequently. Since I couldn't find any exact duplicate on stackoverflow, I thought …

oracle exception plsql exception-handling

Oracle - Number to varchar

I have a table containing a column of type Number create table tmp ( /*other fields*/ some_field Number ) and in …

oracle plsql to-char

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