OraFAQ Forum: Server Administration » can I read in an sql record key only?

Home » RDBMS Server » Server Administration » can I read in an sql record key only?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can I read in an sql record key only? [message #372577]

Fri, 23 February 2001 18:11

joe miller
Messages: 2
Registered: February 2001

Junior Member

how do I read in just the record key in SQL?

Report message to a moderator

Re: can I read in an sql record key only? [message #372587 is a reply to message #372577]

Mon, 26 February 2001 10:13

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

I'm not sure what you mean by record key. If you mean the primary key, then it's simply the PK column(s) on that table.

If you mean Oracle's ROWID, then try:
select rowidtochar(rowid) from my_table;

Report message to a moderator

Re: can I read in an sql record key only? [message #372615 is a reply to message #372577]

Wed, 28 February 2001 08:50

joe miller
Messages: 2
Registered: February 2001

Junior Member

Thanks for the reply, much appreciated.
*IN ONE SQL STATEMENT* can I create (or add) a record and get the value of the auto increment field returned to me?
I am unfamiliar with the mechanics of this messageboard so am going to post this now as a new question also.

Report message to a moderator

Previous Topic:	Re: search for '%' or '_' patterns
Next Topic:	I want to join two tables by row number, how do I do this?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 02:43:22 CDT 2024