Top "Oracle10g" questions

Getting "Invalid column type" excecption, while using NamedParameterJDBCTemplate for insertion

I am using below code while inserting a row into database(oracle 10g xe,jar: ojdbc14.jar) String sql = "INSERT …

spring spring-mvc oracle10g jdbctemplate spring-jdbc

Ugly formatting in SQL*Plus

It is really annoying that when I run a select command in SQL*Plus such as: SELECT * FROM books; The …

sql oracle plsql oracle10g sqlplus

DISTINCT results in ORA-01791: not a SELECTed expression

select DISTINCT a.FNAME||' '||a.LNAME from AUTHOR a, books B, BOOKAUTHOR ba, customers C, orders where C.…

oracle10g

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

Run 2 queries at the same time on Oracle SQL Developer?

I need to retrieve quite a bit of data from our oracle DB and to do so I need to …

oracle oracle10g oracle-sqldeveloper

Relation between Oracle session and connection pool

Let me explain the set up first. We have an oracle server running on a 2GB RAM machine. The Db …

oracle oracle10g connection websphere

to_date function with sysdate

select TO_CHAR(to_date(sysdate, 'DD-MON-YYYY'), 'DAY') FROM DUAL; When I run this query the output was : SUNDAY. But …

oracle oracle10g oracle11g sysdate

Using 'case expression column' in where clause

SELECT ename , job , CASE deptno WHEN 10 THEN 'ACCOUNTS' WHEN 20 THEN 'SALES' ELSE 'UNKNOWN' END AS department FROM emp /* !!! */ WHERE department = …

sql oracle oracle10g ora-00904

How to create copy of full schema on same database in oracle

I want to create full copy of the schema on the same database. What is the best technique to do …

oracle oracle11g oracle10g database-administration

Testing DB Link - ORA-12154: TNS:could not resolve the connect identifier specified

I know there is a load of times this question has been asked but I can't quite figure out how …

database oracle oracle10g toad dblink