Top "Oracle" questions

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

Oracle 10g express home page is not coming up

I installed Oracle 10g express. Installation went well, But the home page is not coming up. I can connect using …

Read More
sql oracle oracle-xe
oracle blob text search

Is it possible to search through blob text using sql statement? I can do select * from $table where f1 like …

Read More
oracle search blob
Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to …

Read More
.net oracle entity-framework ado.net-entity-data-model odac
Grant all privileges to user on Oracle schema

Is there a way to grant all privileges to a user on Oracle schema? I tried the following command but …

Read More
oracle database-schema grant
Counting number of joined rows in left join

I'm trying to write an aggregate query in SQL which returns the count of all records joined to a given …

Read More
sql oracle join count left-join
ORA-01654: unable to extend index

Calling all Oracle Gurus! I am in the process of clustering a well tested application on WebSphere. The application in …

Read More
java oracle cluster-computing
Oracle: What does `(+)` do in a WHERE clause?

Found the following in an Oracle-based application that we're migrating (generalized): SELECT Table1.Category1, Table1.Category2, count(*) as Total, count(…

Read More
sql oracle operators
Exporting a CLOB to a text file using Oracle SQL Developer

I am using Oracle SQL Developer and trying to export a table to a CSV file. Some of the fields …

Read More
sql oracle clob oracle-sqldeveloper
Extracting the total number of seconds from an interval data-type

When subtracting timestamps the return value is an interval data-type. Is there an elegant way to convert this value into …

Read More
sql oracle plsql
I can't understand the reason behind ORA-01722: invalid number

I have an issue that is generated randomly (one time between thousandth of calls). The error ORA-01722: invalid number is …

Read More
java oracle jdbc prepared-statement ora-01722