Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie-desc command
Me wrote:
> On Mon, 19 May 2003 19:05:33 GMT, Ed Prochak wrote:
>
> :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?
>
> Sometimes it is very _big_ and hard to understand.
> Sometimes the word fine is replaced with ****.
All we ask is that you try to read them. The answer to your posted question was simple and in the fine manual.
>
> :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.)
>
> It is a very well known anti spam address! Try sending a mail you will
> be suprised :)
No big surprise.
>
> Oh! when I e-mail you you _will_ get my address.
> any way if you are interested:
> http://www.geocities.com/ppratik85/
>
No thanks.
I do offer to help some folks on occasion via email, even when they obfuscate their address. For now, I suggest you go back to the manuals. They really are fine. (I do like Oracle's documentation. Their Tech Writers do good work.)
-- 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 frostReceived on Tue May 20 2003 - 07:15:41 CDT