Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Library
Product
Contents
Index

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 261 of 452

DBMS_ALERT_INFO

DBMS_ALERT_INFO describes registered alerts.

Column  Datatype  NULL  Description 

NAME 

VARCHAR2(30) 

NOT NULL 

Name of the alert 

SID 

VARCHAR2(30) 

NOT NULL 

Session ID of a session waiting for this alert 

CHANGED 

VARCHAR2(1) 

 

Boolean flag to indicate that an alert has been signaled. Y: Alert signaled N: No alert. 

MESSAGE 

VARCHAR2(1800) 

 

Optional message passed by signaler 

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index