Oracle cursor for simple use

Source: Internet
Author: User
Code
Create   Or   Replace   Function Getroleuser
(
Proleid admin_list.roles_id % Type
)
Return   Varchar2   -- Function return type
Is
Userlists Varchar2 ( 4000 );
Cursor Mycur Is
Select Admin_list.admin_name Into Userlists From Admin_list Where Admin_list.roles_id = Proleid;
Ccrec mycur % Rowtype;
Begin
Begin
-- Open cursor
Open Mycur;
-- Loop
Loop
-- Extract a row of data to ccrec
Fetch Mycur Into Ccrec;
-- Determine whether to extract the value. Exit if the value is not obtained.
-- The value CC % notfound is false.
-- CC % notfound cannot be obtained. The value is true.
Exit   When Mycur % Notfound;
Userlists: = Userlists | Ccrec. admin_name | ' , ' ;
End Loop;
-- Close cursor
Close Mycur;
End ;

ReturnUserlists;
EndGetroleuser;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.