Top "Oracle" questions

What is a TNS:listener in the Context of Oracle?

Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm …

oracle connection-string tnsnames tns

PLS-00103: Encountered the symbol "end-of-file" in simple update block

The following Oracle statement: DECLARE ID NUMBER; BEGIN UPDATE myusername.terrainMap SET playerID = :playerID,tileLayout = :tileLayout WHERE ID = :ID END; …

sql oracle plsql ora-00933 ora-06550

How to stop Oracle dbms_job

My dbms_job has been running for nearly thirty days. The number of total time keeps rising, but I can't …

database oracle dbms-job

What is the difference between "AS" and "IS" in an Oracle stored procedure?

I see Oracle procedures sometimes written with "AS", and sometimes with "IS" keyword. CREATE OR REPLACE Procedure TESTUSER.KILLINSTANCE (INSTANCEID …

oracle stored-procedures keyword

find the elapsed time between two dates in oracle sql

i need to find the difference between the time in the format hh:mm:ss select msglog.id,max(msglog.…

sql oracle date-arithmetic

Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' could not be found

Hi I've just installed Pentaho Data Integration v. 5.01 and I'm trying to connect to a database. However, I'm unable to …

java oracle jdbc oracle11g pentaho

How can I generate (or get) a ddl script on an existing table in oracle? I have to re-create them in Hive

How can I generate a DDL script on an existing table in oracle? I am working on a project where …

sql oracle ddl database-metadata

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

Sqlplus login error when using bash variables: SP2-0306: Invalid option

I have a bash script that connects to an oracle 10g database. In a first step it takes some variables …

oracle bash sqlplus ora-01017

Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?

We have our JBoss and Oracle on separate servers. The connections seem to be dropped and is causing issues with …

oracle jboss connection-pooling reconnect