ارجو المساعدة ضرورى هل يوجد triger يسمى level او كلمة شبيهة وما هى وظيفته ومثال ان امكن :blink: :blink:

وضّح سؤالك بتفاصيل اكثر كي نحاول اجابتك

السلام عليكم

هذه أنواع الـ Triggers:

 

1. Before Trigger

2. After Trigger

3. Row level trigger

4. Schema Trigger

5. Instead of Trigger

6. Database Trigger

7. Statement level Trigger

 

ما المطلوب تحديدا ؟

Hi Nahdy

These's only trigger that contain a "Level" word in Oracle triggers

 

SYSTEM.MESSAGE_LEVEL

 

*  Represents one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The value is always a character string.  During a Run form session, Oracle Forms suppresses all messages with a severity level that is the same or lower (less severe) than the indicated severity level.  Assign a value to the SYSTEM.MESSAGE_LEVEL system variable with standard PL/SQL syntax:  :System.Message_Level := value;  The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20, and 25.  Oracle Forms does not suppress prompts or vital error messages, no matter what severity level you select.  

Hi Nahdy

These's only trigger that contain a "Level" word in Oracle triggers

 

SYSTEM.MESSAGE_LEVEL

 

*  Represents one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The value is always a character string.  During a Run form session, Oracle Forms suppresses all messages with a severity level that is the same or lower (less severe) than the indicated severity level.  Assign a value to the SYSTEM.MESSAGE_LEVEL system variable with standard PL/SQL syntax:  :System.Message_Level := value;  The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20, and 25.  Oracle Forms does not suppress prompts or vital error messages, no matter what severity level you select.  

شكرا للرد

 

السلام عليكم

هذه أنواع الـ Triggers:

 

1. Before Trigger

2. After Trigger

3. Row level trigger

4. Schema Trigger

5. Instead of Trigger

6. Database Trigger

7. Statement level Trigger

 

ما المطلوب تحديدا ؟

شكرا جزلا للرد فهمت القصد من level