EBS : Important Oracle Database related SQL Query

  Important Oracle Database related SQL Query

• Query to get the name of the instance

select INSTANCE_NAME from v$instance;

• Query to get the User name of theDatabase

select USER_ID from ALL_USERS Order by 1

=========================================================================

#Oracle SQL#Oracle Apps#Oracle Database#SQL #Query #v$instance #ALL_USERS