Answer / chandrakant agrawal

To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:

Alter Table <table_name> disable(enable) all trigger;

Answer / mk

Usually the trigger code is in a file e.g. trigger_name.sql

To create/replace the trigger object, at the SQL Plus prompt
type

@<folder>/trigger_name.sql

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What are functions in sql?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

What is sqlite used for?

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

What is pls integer?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---