2263: -- Usage:
2264: -- Get_RDBMS_Header;
2265: --
2266: -- Returns:
2267: -- Version of the Database from v$version
2268: --
2269: -- Examples:
2270: -- declare
2271: -- RDBMS_Ver := v$version.banner%type;
2267: -- Version of the Database from v$version
2268: --
2269: -- Examples:
2270: -- declare
2271: -- RDBMS_Ver := v$version.banner%type;
2272: -- begin
2273: -- RDBMS_Ver := Get_RDBMS_Header;
2274: -- end;
2275: --
2274: -- end;
2275: --
2276: Function Get_RDBMS_Header_html return varchar2 is
2277: l_hold_name v$database.name%type;
2278: l_DB_Ver v$version.banner%type;
2279: begin
2280: begin
2281: select name
2282: into l_hold_name
2287: end;
2288: begin
2289: select banner
2290: into l_DB_Ver
2291: from v$version
2292: where banner like 'Oracle%';
2293: exception
2294: when others then
2295: l_DB_Ver := 'Not Available';
4433: -- Function Name: Get_RDBMS_Header
4434: -- Usage:
4435: -- Get_RDBMS_Header;
4436: -- Returns:
4437: -- Version of the Database from v$version
4438: -- Examples:
4439: -- declare
4440: -- RDBMS_Ver := v$version.banner%type;
4441: -- begin
4436: -- Returns:
4437: -- Version of the Database from v$version
4438: -- Examples:
4439: -- declare
4440: -- RDBMS_Ver := v$version.banner%type;
4441: -- begin
4442: -- RDBMS_Ver := Get_RDBMS_Header;
4443: -- end;
4444:
4443: -- end;
4444:
4445: Function Get_RDBMS_Header_text return varchar2 is
4446: l_hold_name v$database.name%type;
4447: l_DB_Ver v$version.banner%type;
4448: begin
4449: begin
4450: select name
4451: into l_hold_name
4456: end;
4457: begin
4458: select banner
4459: into l_DB_Ver
4460: from v$version
4461: where banner like 'Oracle%';
4462: exception
4463: when others then
4464: l_DB_Ver := 'Not Available';