HomeНаука и техникаRelated VideosMore From: Tech Query Pond

Oracle SQL Tutorial : How to return multiple values from the Function in Oracle PL/SQL

44 ratings | 7754 views
Oracle SQL Tutorial Oracle tutorial : How to return multiple values from the Function in Oracle PLSQL pl sql function This video tutorial tell you How to return multiple rows from the Function in Oracle PLSQL Using the TYPE object you can able return multiple rows from the function.Here object concept of oracle is used. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond
Html code for embedding videos on your blog
Text Comments (2)
soulami mukherjee (1 year ago)
Hello. Just a doubt. So in order to return multiple column values e.g. Ename, Empid,Deptname, I need to return all these. Then object type and its table needs to be created? Can we use multiple out parameters to return multiple column values? Or object type creation is the only option?
Tech Query Pond (1 year ago)
If you are returning limited numbers of columns then you can use multiple out parameters. But for faster processing object type is good option. If you want to return large number of data with good performance then you can use sys_refcursor . Find below link for sys_refcursor : https://www.youtube.com/watch?v=riWRJYMaMFg

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.