Top "Oracle10g" questions

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

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

What's the difference between pls_integer and binary_integer?

I've inherited some code which is going to be the base for some additional work. Looking at the stored procs, …

oracle plsql oracle10g associative-array

BETWEEN clause versus <= AND >=

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons? i.e. these two …

sql performance oracle oracle10g oracle11g

How to add a UTF-8 BOM in Java?

I have a Java stored procedure which fetches record from the table using Resultset object and creates a CS Vfile. …

java character-encoding oracle10g byte-order-mark

How to split array list into equal parts?

Is there anyway to split ArrayList into different parts without knowing size of it until runtime? I know there is …

java plsql oracle10g

Changing the data type of a column in Oracle

I created the following table CREATE TABLE PLACE( POSTCODE VARCHAR(10) PRIMARY KEY, STREET_NAME VARCHAR(10), COUNTY VARCHAR(10), CITY VARCHAR(10)); I …

oracle oracle10g oracle11g

Oracle: how to "group by" over a range?

If I have a table like this: pkey age ---- --- 1 8 2 5 3 12 4 12 5 22 I can "group by" to get a count of …

sql oracle plsql oracle10g

EXCEPT keyword in Oracle

I'm trying to use the EXCEPT keyword in Oracle 10.1.0.2.0, but kept getting error 'Unknown Command'. I've tried googling around and …

sql oracle oracle10g sql-except

Difference Between Drop And Drop Purge In Oracle

I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me …

sql oracle oracle10g