How do you handle exceptions. Give the syntax for it?
Answer / guest
declare
khali exception;
a number(8);
b number(8);
begin
select count(*) into b from &table_name;
dbms_output.put_line('value of b is '||b);
if b = 0 then
raise khali;
end if;
exception
when khali then
dbms_output.put_line('are ye table to khali
nikali');
when others then
select NUM into a from furzi2;
dbms_output.put_line('Others');
end;
/
Is This Answer Correct ? | 10 Yes | 0 No |
Can we create a trigger on view?
use of IN/ANY/ALL
what is Complex index. how to create it?
What is meant by temporal data?
How can get second highest salary in sql?
What is flag in sql?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
What is sql partition function?
Can we use two order by clause in query?
How can you load microsoft excel data into oracle? : aql loader
What are all ddl commands?
Which is faster view or stored procedure?