tag:blogger.com,1999:blog-1271763227002553835.post3431658840735728633..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: 5 minutes: Grant Role to PackageAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1271763227002553835.post-77072781640405909662022-01-20T15:22:05.293+01:002022-01-20T15:22:05.293+01:00What system catalog views show the roles granted t...What system catalog views show the roles granted to a package?<br />i.e. how can I check to see if these role grants are already in place?<br />I do not see them in DBA_ROLE_PRIVS or DBA_TAB_PRIVS.Anonymoushttps://www.blogger.com/profile/06415971675678627093noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-7740487685021986612015-01-08T13:55:39.750+01:002015-01-08T13:55:39.750+01:00and what does this have to do with Granting Roles ...and what does this have to do with Granting Roles to Packages? Answer: Nothing... and No, I will not do your homework.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-84648529865771087362015-01-08T13:45:29.108+01:002015-01-08T13:45:29.108+01:00Write a PL/SQL function that returns the list of d...Write a PL/SQL function that returns the list of dates between two dates (say start_date and end_date) return the list of dates but with the date as index of the type and holiday_name or 'Working Day' as the value of the element. The output should be as follows:<br />dates_array('01-Jan-2015') => 'New Year'<br />dates_array('02-Jan-2015') => 'Working Day'<br />dates_array('03-Jan-2015') => 'Saturday'<br />dates_array('04-Jan-2015') => 'Sunday'<br />dates_array('05-Jan-2015') => 'Working Day'<br />dates_array('06-Jan-2015') => 'Working Day'<br />dates_array('07-Jan-2015') => 'Working Day'<br />dates_array('08-Jan-2015') => 'Working Day'<br />dates_array('09-Jan-2015') => 'Working Day'<br />dates_array('10-Jan-2015') => 'Saturday'<br />dates_array('11-Jan-2015') => 'Sunday'<br />dates_array('12-Jan-2015') => 'Working Day'<br />dates_array('13-Jan-2015') => 'Working Day'<br />dates_array('14-Jan-2015') => 'Working Day'<br />dates_array('15-Jan-2015') => 'Pongal'<br />dates_array('16-Jan-2015') => 'Working Day'<br />dates_array('17-Jan-2015') => 'Saturday'<br />dates_array('18-Jan-2015') => 'Sunday'<br />dates_array('19-Jan-2015') => 'Working Day'<br />dates_array('20-Jan-2015') => 'Working Day'<br />dates_array('21-Jan-2015') => 'Working Day'<br />dates_array('22-Jan-2015') => 'Working Day'<br />dates_array('23-Jan-2015') => 'Working Day'<br />dates_array('24-Jan-2015') => 'Saturday'Anonymoushttps://www.blogger.com/profile/10853894511238807119noreply@blogger.com