Answer / revathy

create or replace function f1(
iip in varchar2,iip2 in char)
Return number
is
tot number;
Begin
select (length(iip)-length(replace(iip,iip2))) into tot
from dual;
return tot;
end;

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

What is the difference between numeric and autonumber?

0 Answers  

---

Give me some examples of predefined exceptions.

3 Answers  

---

What are triggers and its types?

0 Answers  

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

What is compound trigger?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---