Top "Ora-00932" questions

Oracle 10g: Extract data (select) from XML (CLOB Type)

I'm new in Oracle and I've - maybe trivial - a problem in a select. (I'm using Oracle 10g Express …

xml oracle oracle10g ora-00932

What is the best way to search the Long datatype within an Oracle database?

I am working with an Oracle database that stores HTML as a Long datatype. I would like to query the …

sql oracle sql-like ora-00932

SELECT DISTINCT CLOB_COLUMN FROM TABLE;

I would like to find the distinct CLOB values that can assume the column called CLOB_COLUMN (of type CLOB) …

oracle plsql ora-00932

ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I …

oracle plsql toad database-cursor ora-00932

Get the LENGTH of a LONG RAW

I have a table with a column of data type LONG RAW. How do I determine the size (in bytes) …

oracle ora-00932 ora-00997

Error "ORA-00932: inconsistent datatypes: expected - got BLOB" in Join Statement

I have problem executing below stored procedure. I am getting error of ORA-00932: inconsistent datatypes: expected - got BLOB when …

sql database oracle join ora-00932

Filter "text" column on all_views

Is there any way I could filter the text column on oracle's all_views table? For example: SELECT * FROM ALL_…

sql oracle views oracle9i ora-00932

How to include the column USER_VIEWS.TEXT in a where clause

This seems like it should have been an easy thing to figure out but I am struggling to find any …

sql oracle oracle10g ora-00932 ora-00997

How to make CLOB column in group by expression? Any work around?

I have a below query: SELECT Test_Case_Name, Test_Case_Description, Test_Case_Status, CASE WHEN Test_Case_Status = …

sql oracle11g ora-00932

Unhelpful Oracle error message: expected %s, got %s using to_date

Here is a simple query: SELECT COUNT(*) FROM m_bug_t WHERE date_submitted BETWEEN TO_DATE('2011-08-22…

oracle ora-00932