Posts

Showing posts from May 24, 2013

Oracle 10g:Get Archives details in Mail

Image
1.Create the stored procedure generate mail. CREATE OR REPLACE PROCEDURE USP_Daily_Generated_Logs AS vmsg varchar2(10000); i int; begin vmsg:='<html><table border=1 align="center"><tr bgcolor="#8B6161"><td align="center" colspan=26><b>Daily Genereated Archive Logs</b></td></tr>' ; vmsg:= vmsg||'<tr><td>day</td><td>00</td><td>01</td><td>02</td><td>03</td><td>04</td><td>05</td><td>06</td><td>07</td><td>08</td><td>09</td><td>10</td><td>11</td><td>12</td><td>14</td><td>13</td><td>15</td><td>16</td><td>17</td><td>18</td><td>19</td><td>20</td><td>21</td><td>22</td><td>23</td><td>TOT</td