Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie-desc command

Re: newbie-desc command

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Tue, 20 May 2003 12:15:41 GMT
Message-ID: <3ECA20A3.9000205@adelphia.net>


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 frost
Received on Tue May 20 2003 - 07:15:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US