empire-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele <doeb...@esteam.de>
Subject re: Building DBCommand
Date Wed, 18 Jun 2014 08:00:30 GMT
Hi Nhuyen,

this is Oracle Syntax and it is already implemented for the Oracle driver.

All you need to to is the following:

1. Make sure you are using de DBDatabaseDriverOracle.

2. Use cmd. limitRows(...) and cmd. skipRows(...)

then it should generate the desired statement for you.

There is no need to wrap the command inside another command.

Best regards

Rainer

 

 

Von: Nguyen, Chieu X [mailto:chieu.nguyen@verizon.com] 
Gesendet: Dienstag, 17. Juni 2014 22:43
An: user@empire-db.apache.org
Betreff: Building DBCommand

 

Hi Rainer,

 

I was wondering how would I write the following SQL using EmpireDB.

 

select * from (

  select a.*, ROWNUM rnum from (

    <select statemenet with order by clause> // I know how to write this query.

  ) a where rownum <= MAX_ROW

) where rnum >= MIN_ROW

 

I would appreciate any suggestions.

 

Thank You,

 

 

 

Chieu Nguyen

Chieu.nguyen@verizon.com

 


Mime
View raw message