Re: newbie-desc command

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 ****.

: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 :)

Oh! when I e-mail you you _will_ get my address. any way if you are interested:
http://www.geocities.com/ppratik85/ Received on Mon May 19 2003 - 14:12:14 CDT