Top "Oracle" questions

GROUP BY with MAX(DATE)

I'm trying to list the latest destination (MAX departure time) for each train in a table, for example: Train Dest …

sql oracle group-by greatest-n-per-group ora-00979

Using Oracle to_date function for date string with milliseconds

I have to perform some inserts into an Oracle DB. I have some dates in the following format '23.12.2011 13:01:001' …

oracle to-date

Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I …

sql oracle escaping sqlplus

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.…

sql oracle tnsnames oracle-sqldeveloper

No more data to read from socket error

We are using Oracle as the database for our Web application. The application runs well most of the time, but …

oracle hibernate spring jdbc

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

I am getting an ORA-01000 SQL exception. So I have some queries related to it. Are maximum open cursors exactly …

java oracle jdbc

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can anyone explain how to implement one-to-one, one-to-many and many-to-many relationships while designing tables with some examples?

sql oracle database-design

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider …

c# asp.net oracle odp.net oracleclient

Number of rows affected by an UPDATE in PL/SQL

I have a PL/SQL function (running on Oracle 10g) in which I update some rows. Is there a way …

oracle plsql sql-update

Difference between BYTE and CHAR in column datatypes

In Oracle, what is the difference between : CREATE TABLE CLIENT ( NAME VARCHAR2(11 BYTE), ID_CLIENT NUMBER ) and CREATE TABLE CLIENT ( …

sql oracle unicode varchar