Top "Oracle10g" questions

Connect to an Oracle 10g database with Microsoft ODBC for Oracle

I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want …

.net oracle oracle10g odbc ora-12514

How to change column varchar to clob in oracle

I have a column details designed as varchar in oracle DB, this DB is being used now for customers and …

sql oracle oracle10g

Can't initialize OCI. Error -1. Toad for Oracle 10 and Oracle 10g

I am trying to connect Oracle 10g database server from my client PC using toad 10 Commercial. I have Oracle 10g …

oracle10g toad

Need to count records and group count by date on oracle db using sql developer

I have a table like the following ID created sent type ----------------------------------------------------- 0001463583000051783 31-JUL-12 1 270 0081289563000051788 01-AUG-12 1 270 0081289563000051792 01-AUG-12 1 270 0081289563000051791 01-AUG-12 1 270 0081289563000051806 01-AUG-12 1 270 0001421999000051824 06-AUG-12 1 270 0001421999000051826 06-AUG-12 1 270 0001464485000051828 06-AUG-12 1 270 0082162128000051862 09…

oracle count oracle10g group-by oracle-sqldeveloper

Script to disable all jobs in Oracle (DBMS_JOB package)?

I'm looking for a script which disables all the jobs. Right now I highlight them all in Toad, click the …

oracle plsql oracle10g dbms-job

ORA-01855: AM/A.M. or PM/P.M. required

I get the error: ORA-01855: AM/A.M. or PM/P.M. required when I try to execute following query. …

oracle date oracle10g nls-lang

Function return sys_refcursor call from sql with specific columns

This may find little silly, but I would like to know whether this is possible. I have a function which …

sql function plsql oracle10g sys-refcursor

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

Preamble Of late, I see too many geeks commenting on Oracle questions saying that "Do not use (+) operator, rather use …

sql oracle oracle11g oracle10g oracle12c

Cannot call oracle stored procedure and function

Might be too simple question to ask, but I do need help. I am creating a stored procedure in Oracle 10…

oracle function stored-procedures oracle10g

Oracle - connection Pooling with spring framework

We are trying to implement Oracle connection pooling with the help of Spring Framework. We are using DBCP connection pooling …

java spring tomcat oracle10g ibatis