Skip to content

Instantly share code, notes, and snippets.

@bitwes

bitwes/test.sql

Forked from anonymous/test.sql
Created October 27, 2011 20:25
Show Gist options
  • Save bitwes/1320773 to your computer and use it in GitHub Desktop.
Save bitwes/1320773 to your computer and use it in GitHub Desktop.
Download ZIP
butch test
Raw
test.sql
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);
if dbversion >= l_num then
dbms_output.put_line(dbversion||' >= '||l_num);
end if;
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment