Does a user_objects view have an entry for a trigger?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is the use of triggers?

0 Answers  


how to get a list of indexes of an existing table? : Sql dba

0 Answers  


How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,


What is implicit cursor in pl sql?

0 Answers  


What is nvarchar in sql?

0 Answers  


declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,


What is rank dense_rank and partition in sql?

0 Answers  


what is a stored procedure? : Sql dba

0 Answers  


Can instead of triggers be used to fire once for each statement on a view?

0 Answers  


what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,


What does inner join mean?

0 Answers  


What is difference between ms sql and mysql?

0 Answers  


Categories