2 Replies Latest reply: Nov 12, 2012 2:11 PM by SomeoneElse RSS

    Need a query

    967148
      hi all


      query to list the child tables dependent on a column named serialno....
        • 1. Re: Need a query
          Frank Kulash
          Hi,

          You can query the data dictionary views ALL_CONTRAINTS and ALL_CONS_COLUMNS.


           

          I hope this answers your question.
          If not, post your best attempt, along with a little sample data (CREATE TABLE and INSERT statements, relevant columns only) for all the tables involved, and the results you want from that data.
          Explain, using specific examples, how you get those results from that data.
          Always say what version of Oracle you're using (e.g. 11.2.0.2.0).
          See the forum FAQ {message:id=9360002}
          • 2. Re: Need a query
            SomeoneElse
            query to list the child tables dependent on a column named serialno....
            Are you asking us a question or giving us a demo?