1 Reply Latest reply: Oct 28, 2012 2:31 PM by rp0428 RSS

    How do i found customer details  based on costomer name

    971085
      hi all
      i hav a table calleed customer that contains cloumns like "customer name "and "customer id" and customer "introducer name" and "customer introducer id" if give customer introder name as input i want the details of customer name and customer id of the customers introdeced by that customer (which i given name as input)

      Edited by: 968082 on Oct 28, 2012 10:18 AM
        • 1. Re: How do i found customer details  based on costomer name
          rp0428
          Welcome to the forum!

          Unfortunately you've posted to the wrong forum. This forum is for SQL Developer questions only. If your question is about an Oracle database you need to repost it in the SQL and PL/SQL forum
          SQL and PL/SQL
          >
          i hav a table calleed customer that contains cloumns like "customer name "and "customer id" and customer "introducer name" and "customer introducer id" if give customer introder name as input i want the details of customer name and customer id of the customers introdeced by that customer (which i given name as input)
          >
          If you know the exact name (including case) you want you can use
          SELECT custName, custId from customer where custIntroducerName = 'myNameToFind'
          If you don't know the entire name or the exact case you will need to use UPPER and LIKE instead of =
          SELECT custName, custId from customer where UPPER(custIntroducerName) LIKE '%MYNAMETOFIND%'
          Mark this question ANSWERED. If you need more help post in the correct forum.