Top "Oracle" questions

Why would you use Oracle database?

I'm curious for technical reasons why you choose Oracle database versus the latest flavors of: 1) Microsoft SQL Server 2) MySQL 3) PostgreSQL …

database oracle comparison

Which .NET data type is best for mapping the NUMBER Oracle data type in NHibernate?

I've seen some examples in which decimal is used in NHibernate projects for mapping to whole number columns in Oracle. …

c# oracle nhibernate oracle10g nhibernate-mapping

How to install tnsping?

How do I have to install tnsping? I tried to install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm and I'm able to …

oracle tnsping

How do I select all the columns from a table, plus additional columns like ROWNUM?

In Oracle, it's possible to do a SELECT statement that returns the row number as a column in your result …

sql oracle select

Oracle - How to grant to a user the rights to another user's objects

I need to give to user TARGETUSER the rights to select/insert/update to all tables of user SOURCEUSER (I …

oracle permissions grant

Convert timestamp/date time from UTC to EST Oracle SQL

I have a field with a date/time value like this: 2009-11-17 18:40:05 It's in UTC. In the query how …

sql oracle datetime-format

SQL Inner join on select statements

I am trying to make an inner join on a select statement like this: select * from (select* from bars where …

sql oracle ora-00933

Working with very large text data and CLOB column

According to documentation CLOB and NCLOB datatype columns, can store up to 8 terabytes of character data. I have text, which …

oracle oracle11g lob

Hibernate on Oracle: mapping String property to CLOB column

WARNING: see my own answer below. The problem is caused by old Oracle drivers that were present on the classpath …

java oracle hibernate jpa clob

When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

oracle stored-procedures oracle11g oracle10g cursor