Re: newbie-desc command

On Sun, 18 May 2003 15:23:19 +0530, Me <me_at_privacy.net> 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?

NOOOOOOOOOOOOOOOO

I will definitely ignore them

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun May 18 2003 - 05:50:24 CDT