DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: username and service name

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai

    inside the pl/sql procedure,

    i need to find schemaowner name and the service name

    of the oracle server




  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    This could help you:
    Code:
    declare
      dbname global_name.global_name%type;
    begin
      select global_name into dbname from global_name;
      dbms_output.put_line(user);
      dbms_output.put_line(dbname);
    end;
    Ales

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width