Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Question Unanswered: select into 2 variables

    Hi,

    Is it possible in Oracle 9i to select into two variables in one sql statement. I tried this pl/sql code - but does not compile: -

    select sum(a), sum(b)
    into varA, varB
    from myTbl

    Is it possible to do this in one single sql or do I need to split it into 2 bits of code?

    cheers

  2. #2
    Join Date
    Mar 2002
    Posts
    20
    No worries I got my field names wrong, syntax is fine

Posting Permissions

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