Top "Oracle" questions

Cannot use a LIKE query in a JDBC PreparedStatement?

The query code and query: ps = conn.prepareStatement("select instance_id, ? from eam_measurement where resource_id in (select RESOURCE_…

java oracle jdbc sql-like

ORA-12704: character set mismatch

Hell when I do: select COALESCE (CORP_ID, 0) from crmuser.accounts; The CORP_ID records which are Null returns 0 but …

oracle oracle11g coalesce

Comparing dates in Oracle using the decode function

I need to compare two dates using the Oracle decode function to see if one is less than or equal …

sql oracle date decode date-arithmetic

Add column in Oracle table

I'm trying to add an XMLType column into a table, but it returns an error. Why? This is the query: …

sql oracle xmltype

Query a Table's Foreign Key relationships

For a given table 'foo', I need a query to generate a set of tables that have foreign keys that …

sql database oracle oracle10g

create synonym for table in a database hosted in a different server

In oracle, if the other database is within the same server, I did the following to create a synonym CREATE …

oracle synonym netezza

SQL Group By - counting records per month/year, error on insert - NOT A VALID MONTH

I have this example data: Country | Members | Joined USA | 250 | 1/1/2012 USA | 100 | 1/8/2012 Russia | 75 | 1/20/2012 USA | 150 | 2/10/2012 When I query this data I would like …

sql oracle group-by pivot

Installing GCC on Oracle Solaris 11

i recently got Oracle Solaris on my VM to test some code on it, i was unable to install gcc …

oracle gcc solaris

Determine if Oracle date is on a weekend?

Is this the best way to determine if an Oracle date is on a weekend? select * from mytable where TO_…

oracle date plsql weekend

ORA-04082: NEW or OLD references not allowed in table level triggers

itI have table named per. In the per table, I have a field named "fl1" and another field named "fl2". …

oracle triggers