Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

SQL state [99999]; error code [17004]; Invalid column type: 1111 With Spring SimpleJdbcCall

Hi All I am using spring simple JDBC template to call the oracle procedure the below are my code. The …

java oracle spring jdbctemplate
When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

I have a main database and a report database, and I need to sync a table from main into report. …

sql oracle sql-merge
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
Finding last index of a string in Oracle

I need to find the last index of a string (e.g. -) within another string (e.g. JD-EQ-0001 in …

oracle string
ORA-06508: PL/SQL: could not find program unit being called

I am using oracle 10g and toad 11.5. I am trying to call an api from an anonymous block. If I …

oracle plsql anonymous
Oracle Partition - Error ORA14400 - inserted partition key does not map to any partition

I'm trying to insert information in a partition table, but I don't know what I'm doing wrong! Show me this …

oracle database-partitioning
Oracle query execution time

I would like to get the query execution time in Oracle. I don't want the time Oracle needs to print …

oracle sqlplus execution
libaio.so.1: cannot open shared object file

I have a simple test program that when I run I get: ./hello: error while loading shared libraries: libaio.so.1: …

linux oracle oracle-call-interface
Oracle: how to INSERT if a row doesn't exist

What is the easiest way to INSERT a row if it doesn't exist, in PL/SQL (oracle)? I want something …

oracle plsql
Can the "IN" operator use LIKE-wildcards (%) in Oracle?

I have searched this question, and found an answer in MySQL but this is one of those incidents where the …

sql oracle where wildcard