From saurabhs@fcsltd.com Fri, 25 May 2001 04:48:53 -0700
From: "Saurabh Sharma" <saurabhs@fcsltd.com>
Date: Fri, 25 May 2001 04:48:53 -0700
Subject: Re: QUERRY DOUBT..
Message-ID: <F001.0030ECB5.20010525045030@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



THANKS A LOT, Seley 
 
the querry works absolutely fine. 
instead i've created a view. which can be easier to querry. and it also let me 
able to devise way for finding each individuals' report.
 
thanks again.
 
saurabh sharma
<BLOCKQUOTE 
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Seley, 
  Linda 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Friday, May 25, 2001 1:51 PM
  Subject: RE: QUERRY DOUBT..
  
  Try 
  this:
  <SPAN 
  class=819191807-25052001> 
  <SPAN 
  class=819191807-25052001>select d.owner, 
  d.table_name,b.constraint_name,b.constraint_type,d.column_namefrom 
  all_tables a,all_constraints b,all_cons_columns c, all_tab_columns dwhere 
  d.owner = c.owner (+)and d.table_name = c.table_name (+)and 
  d.column_name = c.column_name (+)and c.table_name = a.table_name 
  (+)and c.table_name = b.table_name (+)and c.constraint_name = 
  b.constraint_name(+)and c.owner = a.owner (+)and c.owner = b.owner 
  (+)order by d.owner, d.table_name, d.column_id;
  <SPAN 
  class=819191807-25052001> 
  <SPAN 
  class=819191807-25052001>HTH
  <SPAN 
  class=819191807-25052001> 
  <SPAN 
  class=819191807-25052001>Linda
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: Saurabh Sharma 
    [mailto:saurabhs@fcsltd.com]Sent: Friday, May 25, 2001 12:46 
    AMTo: Multiple recipients of list ORACLE-LSubject: 
    QUERRY DOUBT..
    hi all,
     
    i've a querry that is to find 
    out what all columns have constraints applied on them. giving the 
    table_name,column_name,constraint name and constraint type.
     
    the querry goes 
    like..
     
    select 
    a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom 
    user_tables a,user_constraints b,user_cons_columns cwhere 
    a.table_name=b.table_name 
    andb.constraint_name=c.constraint_name/
     
    now i need to make a report 
    which gives out in the same result all the tables' columns which have 
    constraints and which have not, both.
    leaving the constraint_type and 
    constraint name columns null in the same querry.
    is it possible, or do we have 
    other alternative to do that.
     
    pls suggest.
    thanks
     
    saurabh