Local Instance Name

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  July 22, 2008 at 5:47 am

  #381863

  Hi , I am new to oracle. How can i get the local instance name for oracle server. i hvae oracle server installed on my machine.

  Abhijit - http://abhijitmore.wordpress.com

• Mohammad Mazharuddin Ehsan

  SSCarpal Tunnel

  Points: 4552

  More actions

  July 22, 2008 at 7:31 am

  #846401

  Try select INSTANCE_NAME from v$instance

  -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]