SQL and Banner Systems (Orical 10g)

• DBCOORD

  Valued Member

  Points: 51

  More actions

  June 24, 2009 at 6:18 am

  #207461

  I am relatively new to the Banner/Orical 10g platform and I am working on doing specialized queries of the the Banner data bases where there is a predefined set of data that I need to pull information on individually. In the past I know the array issues was not available in SQL, does anyone have a way that a large list can be used as a selection filer (WHERE statement.

  The example of what I would like to do is

  SELECT SPIDEN_ID

  FROM SPRIDEN

  WHERE SPRIDEN_ID = ( THIS IS WHERE IN NEED TO USE THE LISTING OF OVER 200 IDS)

  Any assistance would be greatly appreciated

• Steve Brett

  Mr or Mrs. 500

  Points: 589

  More actions

  June 25, 2009 at 5:07 am

  #1015202

  you could try something along the lines of:

  SELECT SPIDEN_ID

  FROM SPRIDEN

  WHERE SPRIDEN_ID IN ( SELECT ID FROM IDTABLE)

  the inner select is the list of IDs and can be in the form of a sleect or in the form (1,2,3,4,5,6,7,8)

  HTH

  Steve