Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can define HOSTNAME in package spec?
Hi,
I faced with a problem in T-SQL to PL/SQL in a project.
scenario:
There is a function called hostname() in T-SQL which returns an obviouse
thing! I implemented this with:
Code:
select userenv('Terminal') from dual;
but they have used many many times from this in T-SQL so I want to ask Isn't
better to create a package and declare a type in that to point to this select
statement?Is it possible?
-Any help is so appreciated.
--
Message posted via http://www.dbmonster.com
Received on Mon Jul 18 2005 - 05:05:23 CDT