Saturday, September 26, 2009

information about current database

SET termout off
store SET store rep
SET head off
SET pause off
SET termout ON

SELECT 'User: '|| USER || ' on database ' || global_name,
' (term='||USERENV('TERMINAL')||
', audsid='||USERENV('SESSIONID')||')' AS MYCONTEXT
FROM global_name;

@store
SET termout ON

No comments: