Top "Oracle" questions

Oracle EXECUTE IMMEDIATE into a cursor

I have a stored procedure which used the EXECUTE IMMEDIATE command to execute a very long string. How do I …

sql oracle stored-procedures dynamic-sql sys-refcursor

java.sql.SQLException: Io exception: Broken pipe how to recover without restart?

In my application I use connection to Oracle, when connection lost and I try to re-connect I receive exception: java.…

java oracle connection recover disconnected

Oracle.DataAccess.Client Dependencies

First of all, I want to use the Oracle.DataAccess.dll to use OracleBulkCopy. I want to know all the …

c# .net oracle dll odp.net

Oracle show all employees with greater than average salary of their department

I am writing a query to find employees who earn greater than the average salary within their department. I need …

sql oracle plsql ora-00904

Oracle Apex 5.0 - Display static image

I'm new to Oracle Apex and I'm really struggling how to display static images on a desktop application. I uploaded …

oracle oracle-apex oracle-apex-5

no privileges on tablespace 'USERS'

i have many tables that i can insert rows, but i get this error only for one table; Error starting …

database oracle privileges tablespace

How to insert & in oracle using toad?

Possible Duplicate: select * from table_name where column like '&nbsp' How do you insert the & symbol as …

sql oracle toad

Oracle's dbms_metadata.get_ddl for object_type JOB

I'd like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of …

oracle oracle10g jobs ora-06512 dbms-metadata

How to check the timezone of oracle pl/sql developer

Where do I check the timezone of oracle pl/sql developer.Can someone help please

sql oracle plsql plsqldeveloper

SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword

Asking for your help on this Oracle query. It's giving me the error 2 "ORA-00905: missing keyword". It was working fine …

sql oracle subquery left-join ora-00905