Hi,Can somebody please answer couple of my questions ASAP?1) How do you call a trigger on a table?2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?Much thanks!!

  • Interview Candidate
  • 2
  • 2197

Showing Answers 1 - 2 of 2 Answers

gchandra_sekar

  • Feb 7th, 2007
 

Hi!) Trigger cannot be called as it automatically gets activated once u touch the table.2) Prior 10g user SQL> set serveroutput on size 1000000 or if it is 10gORA10GR2> set serveroutput on size unlimited

  Was this answer useful?  Yes

madhuk17

  • Feb 7th, 2007
 

Hi,I think trigger is not called.The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place.I think maximum number of data strings that can be returned through DBMS_OUTPUT is 255 bytes.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions