Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get the max key.data?

779829Jun 17 2010 — edited Jul 22 2010
My application is transfered from sqlite3, I don'n know how to get the max key.data and the sql like below:
SELECT * FROM t1 WHERE key1>=%d ORDER BY pkey;

The orginal sqlite3 table is like below:
create table t1 (pkey INTEGER PRIMARY KEY, key1 INTEGER, data1 INTEGER, data2 BLOB);
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2010
Added on Jun 17 2010
1 comment
1,282 views