Top "Oracle" questions

Oracle listener not running and won't start

I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64…

oracle oracle11g tns

Find duplicate entries in a column

I am writing this query to find duplicate CTN Records in table1. So my thinking is if the CTN_NO …

sql oracle subquery

CLEAR SCREEN - Oracle SQL Developer shortcut?

With the aim of reducing mouse activity I was wondering if there was such a command shortcut (eg cls or …

oracle sqlplus oracle-sqldeveloper

Paging with Oracle

I am not as familiar with Oracle as I would like to be. I have some 250k records, and I …

sql oracle stored-procedures

What does a (+) sign mean in an Oracle SQL WHERE clause?

Possible Duplicate: Oracle: What does (+) do in a WHERE clause? Consider the simplified SQL query below, in an Oracle database …

sql oracle

ORA-00984: column not allowed here

I am doing a simple Oracle INSERT and I keep getting this error: [Err] ORA-00984: column not allowed here INSERT …

oracle oracle10g

Is java.sql.Timestamp timezone specific?

I have to store UTC dateTime in DB. I have converted the dateTime given in specific timezone to UTC. for …

java oracle date datetime jdbc

Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it

When I do... Select TO_CHAR (date_field, 'Month DD, YYYY') from... I get the following: July 01, 2011 April 01, 2011 January 01, 2011 Why …

sql oracle oracle10g

Oracle 11g SQL to get unique values in one column of a multi-column query

Given a table A of people, their native language, and other columns C3 .. C10 represented by ... Table A PERSON LANGUAGE ... …

sql oracle distinct

Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?

I'm developing a very simple application which I intend to use to troubleshoot an issue I am having on a …

c# oracle tnsnames