Declare
All_Depts Varchar2 (50) := '';
Cursor c_Loc Is
-----------------------------------
-- don't put ',' in front of 1st
-----------------------------------
Select Case When Rownum <> 1 Then ',' End
||
Loc
As
Loc
From Dept;
Begin
For c_Each In c_Loc
Loop
All_Depts := All_Depts || c_Each.Loc;
End Loop;
Dbms_Output.Put_Line (All_Depts);
End;
/
"BlogSpot" Blogs Cannot Be Shared, Using "www"
-
We're seeing a number of reports from blog owners, claiming their blogs are
now subject to security alerts - and blocked when sharing.
Frequently, the repo...
5 years ago
Thank you for this wonderful example!
ReplyDelete