Answer Posted / 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;
/

What normalization means?

915

---

How much does sql certification cost?

1026

---

How do you go back in sql?

944

---

define sql delete statement ? : Sql dba

977

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

902

---

What is clustered index sql?

952

---

Why is stored procedure faster than query?

913

---

Is ms sql traffic encrypted?

881

---

what is user defined functions? : Sql dba

987

---

What is crud stand for?

944

---

What are the different types of dbms?

965

---

What do you mean by stored procedures? How do we use it?

941

---

how to do backup entire database? : Transact sql

1081

---

What are the features of pl sql?

1021

---

Which sql most popular?

948

---