This content has been marked as final. Show 1 reply
Welcome to the forum!1 person found this helpful
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
PL/SQL and 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
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 custIntroducerName = 'myNameToFind'
Mark this question ANSWERED. If you need more help post in the correct forum.
SELECT custName, custId from customer where UPPER(custIntroducerName) LIKE '%MYNAMETOFIND%'