1. What
are the various types of database triggers ?
Answer: There are 12 types of triggers they are combination of:
Insert,
delete and update triggers.
Before
and after triggers .
Row
and statement triggers
2.What
is advantage of a stored procedure over a database trigger?
3. What
is the use of control files ?
Answer:
contains...
Thursday, August 27, 2015
Tuesday, August 18, 2015
freelancer hire Html
freelancer hire Html
Looking for Project html Workers
Need help with Project html? Hire a freelancer today! Do you specialise in Project html? Use your Project html skills and start making money online today! Freelancer is the largest marketplace for jobs in the world.
Contact :- Email hemalatamm@gmail.co...
Monday, August 10, 2015
What is Boolean datatype in PLSQL Block.
What is Boolean datatype in PLSQL Block.
A boolean datatype enables you to
declare
v_sal number;
v_flag boolean;
begin
select salary into v_sal from employees
where employee_id=&empno;
if v_sal >=10000 then
v_flag :=true;
else
v_flag :=false;
end if;
if v_flag = true then
dbms_output.put_line('High Grade');
else
dbms_output.put_line('Low Grade');
end...