oracle 查看服务器操作系统版本

SELECT parameter, value FROM v$parameter WHERE name = 'os_name';

DECLARE
  os_version VARCHAR2(100);
BEGIN
  DBMS_OUTPUT.PUT_LINE('Operating System Version:');
  EXECUTE IMMEDIATE 'SELECT utl_inaddr.get_host_name FROM dual' INTO os_version;
  DBMS_OUTPUT.PUT_LINE(os_version);
END;
/

DECLARE
  file_content UTL_FILE.FILE_TYPE;
  line VARCHAR2(1024);
BEGIN
  file_content := UTL_FILE.FOPEN('/etc', 'os-release', 'R');
  LOOP
    UTL_FILE.GET_LINE(file_content, line);
    DBMS_OUTPUT.PUT_LINE(line);
  END LOOP;
  UTL_FILE.FCLOSE(file_content);
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    UTL_FILE.FCLOSE(file_content);
END;
/

CREATE TABLE os_release (
  line VARCHAR2(1024)
) ORGANIZATION EXTERNAL (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY data_dir
  ACCESS PARAMETERS (
    RECORDS DELIMITED BY NEWLINE
    FIELDS TERMINATED BY WHITESPACE
  )
  LOCATION ('os-release')
);

SELECT * FROM os_release;