Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Return ROWID in Java
ReplyToGroups wrote:
> use sequence_name.nextval
>
> If u want the primarkey value to be returned to the client
Quite frankly that is a terrible idea. In a relational database one does not jump on a surrogate key just for convenience. And one certainly does not change a design to suit a front-end tool.
There is not a single bit of difficulty in returning the existing primary key. I can't imagine why anyone would give or take this advice.
And my apology if the above seems harsh. It is not intended as such.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Feb 17 2004 - 18:16:19 CST