Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Multiple queries

    Hi,

    I need to run multiple queries from a VB application accessing oracle.
    How do I separate 2 queries. Both the queries are running independently, but, together, it throws an error saying "sql command not ended properly"
    Please help!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Either run them separately, or combine them (if possible) into a single UNION or UNION ALL query:

    SELECT ... FROM ... WHERE ...
    UNION
    SELECT ... FROM ... WHERE ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •