Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Get env from oracle.md

Last active October 19, 2022 11:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/9781dd9b8970fb07e29928d8385e3f99 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/9781dd9b8970fb07e29928d8385e3f99 to your computer and use it in GitHub Desktop.
Download ZIP
Get env from oracle #oracle #sql
Raw
Get env from oracle.md 
1 DECLARE
2 RetVal VARCHAR2(100);
3 BEGIN
4 dbms_system.get_env('ORACLE_HOME', RetVal);
5 dbms_output.put_line(RetVal);
6* END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment