Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. malini0905

    sql help

    I have SQL statement select * from tableA,but to this SQL statement i need to add the functionality of 3 functions. Function1 Create or Replace Function1() RETURM object1 IS CURSOR c1 IS SELECT * from tableA where (c1='A' or c2='Y'); --- --- RETURN object1; END Function1 Function2...
  2. malini0905

    SQL help needed

    yes,but this question does not depend on the database. I need the logic for the SQL statement. can you please help me.Thanks in advance.
  3. malini0905

    SQL help needed

    I have SQL statement select * from tableA,but to this SQL statement i need to add the functionality of 3 functions. Function1 Create or Replace Function1() RETURM object1 IS CURSOR c1 IS SELECT * from tableA where (c1='A' or c2='Y'); --- --- RETURN object1; END Function1 Function2...
  4. malini0905

    SQL help needed

    Thanks, rac this solution is working fine with more where conditions which i need. Thanks for the quick reply.
  5. malini0905

    SQL help needed

    I have data which has 13 periods per year and ineach period there will be 4 weeks.Reports are generated for each week with some amount fields corresponding to each week. we also have week numbers which are integers from (1,2--52) This amount field is for 1st week in each period is fine,for next...
  6. malini0905

    DB2 Sql help needed

    I have data which has 13 periods per year and ineach period there will be 4 weeks.Reports are generated for each week with some amount fields corresponding to each week. we also have week numbers which are integers from (1,2--52) This amount field is for 1st week in each period is fine,for next...

Part and Inventory Search

Back
Top