Selecting columns from a MYSQL routine result
Posted by:
Mike Berg
Date: June 11, 2012 06:00PM
I have a routine called sp_getalldata and I want to select only 2 columns col1 and col2 from the resultset of the routine.
I've tried
SELECT col1, col2 FROM (CALL sp_getalldata())
but it is invalid. What are my options?
Subject
Written By
Posted
Selecting columns from a MYSQL routine result
June 11, 2012 06:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.