Butch Wesley bitwes

bitwes / test.sql

Created October 27, 2011 20:25 — forked from anonymous/test.sql

butch test

	declare
	dbversion number;
	l_num number := 12;
	l_version varchar2(200);
	begin
	select to_number(substr(version, 1, instr(version, '.') - 1)),
	version
	into dbversion, l_version
	from v$instance;
	dbms_output.put_line(dbversion\|\|' from '\|\|l_version);