Top "Oracle" questions

can not load oci8 -> Fatal error: Call to undefined function oci_connect()

I want to connect to my oracle database, but i have a problem with function oci_connect. i have tried …

php oracle oracle-call-interface oci8

How to increase the TEMP TABLE Space value in Oracle?

Currently my Oracle 11g temp TABLESPACE value is 34GB. I need to increase the table space value to a large …

oracle oracle11g redhat tablespace

ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file

Overview I want to replace Oracle.DataAccess with Orcale.ManagedDataAccess, but opening a connection with the latter throws an ORA-12537 …

c# oracle oracle11g odp.net

Close modal dialog page and refresh the page Oracle APEX

I am trying to close a modal dialog page after changes have been made and then refresh the edit form …

oracle oracle-apex

SQLDeveloper displays no tables under connections where it says tables

I am not sure why but I just installed SQLdeveloper 32 bit (3.0.0.4). When I click to expand the tables/views/indexes …

oracle oracle-sqldeveloper

Intentionally Cause ORA-00600 exception in Oracle

For testing purposes I need a couple of SQL scripts that will cause an ORA-00600 error in Oracle, version 11.1.0.7. The …

sql oracle plsql ora-00600

GO_BLOCK in WHEN_VALIDATE Trigger

I'm working with oracle forms. I've a procedure I have to run whenever a specific field's value is modified. The …

sql oracle plsql oracleforms

How to use Oracle's decode function in where clause

I have a query with few filter criteria, one of them is get to the query as integer parameter. I …

sql oracle decode nvl

.nextval JDBC insert problem

I try to insert into table with sequence .nextval as primary key, the sql in Java is sql = "INSERT INTO …

java sql oracle jdbc ora-01722

Show column name and data type in Teradata?

Is there a way to get column name and data type in a Teradata SQL Assistant 15.0view? In Oracle 11g …

sql oracle oracle11g teradata