Re: newbie-desc command

Me wrote:
> On Sat, 17 May 2003 22:17:20 +0200, Sybrand Bakker wrote:
>
> :
> :"Me" <me_at_privacy.net> wrote in message
> :news:b1vccvgbffv5ro9n7qso72n8ilrhjfjdrm_at_4ax.com...
> :> In Oracle SQL* Plus desc command give the information of a table but
> :> how does one know which is the primary key?
> :>
> :> I am sorry if this has been already asked and answered here.
> :>
> :> Thanks in advance.
> :>
> :
> :
> :By querying
> :select constraint_name from user_constraints where table_name = '<your
> :table>' and constraint_type = 'P'
> :
> :There is a reference manual with a full break down of all the dictionary
> :views. Please use it, before you come boring and will be ignored.
>
> Thanks to you and Rauf Sarwar
> sorry for asking this.
>
> Can I ask such questions by mail if you don't mind?
>

1 What do you have against reading the Fine Manuals?

2 why should you feel invited to email to us when you do not post a valid email address? (I tried to email this and I'll be very surpised if me_at_privacy.net is a valid address.)

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost