Top "Oracle" questions

pooled connection timed out

On the production server sometimes randomly the connection fails to the ORacle database. I get a lot of Oracle.DataAccess.…

database oracle connection data-access

What is the minimal setup required to deploy a .NET application with Oracle client 11?

What is the minimal setup required to be able to deploy a .NET application that talks to an Oracle database?

oracle odp.net

Alter table after keyword in Oracle

ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL AFTER column2; Why can't I use mySql syntax in Oracle too? …

oracle oracle11g ddl alter-table

Select earliest hired employee from employee table

I have an employee table where the fields are: first_name, last_name, hire_date, salary, department_id, department_name, …

sql oracle ora-00937

PL/SQL Package invalidated

I have a script that makes use of a package (PKG_MY_PACKAGE). I will change some of the fields …

oracle plsql

check if clob contains string oracle

currently i have query with this code to_char(CLOB_COLUM) like %s but the following wont work for very …

sql oracle clob

Link one page to another in oracle apex

this is supposed to be simple i have two pages A and B what i want to do is add …

oracle oracle-apex

PreparedStatement and setTimestamp in oracle jdbc

I am using PreparedStatement with Timestamp in where clause: PreparedStatement s=c.prepareStatement("select value,utctimestamp from t where utctimestamp&…

java oracle jdbc timestamp prepared-statement

When should database synonyms be used?

I've got the syntax down but I'm wondering if somebody can provide an illustrative use case where database synonyms are …

sql oracle database-design plsql synonym

how to make sql developer display non-English character correctly instread of displaying squares?

in sql developer--preference Environment--encoding is already set to 'UTF-8' Code Editor--fonts was set to 'Verdana' Database--NLS--Language was set to …

oracle encoding utf-8 oracle-sqldeveloper non-english