Tools to migrate stored procedures and queries

Your question does not provide enough detail about what it is you are doing so I will assume that you must migrate stored procedures from an existing Oracle 8i database to an existing Oracle 9i database, and not that you are attempting to upgrade a database to 9i.

You can either grab the code from the stored procedures through SQL*Plus by querying views such as DBA_SOURCE, or you can also do this via a GUI tool such as Oracle's Enterprise Manager or Toad. Once you have the 'create or replace …' statements for the stored procedures you wish to migrate from the Oracle8i database, you would simply log into the Oracle9i database as the proper schema owner and run them via SQL*Plus. This would create the necessary stored procedures in the 9i database.

SQL queries are not stored within the Oracle database so they are not migrated, per se. SQL queries are either run via an application, or some other interface such as reporting tools, or the SQL*Plus command line by users and DBAs.