Answer Posted / hari k

set serveroutput on;
declare
cursor c1 is select substr(name1,1,1) from tab1;
v_string tab1.name1%type;
begin
open c1;
loop
fetch c1 into v_string ;
exit when c1%notfound;
dbms_output.put_line(v_string);
end loop;
end;

Can %notfound return null after a fetch?

1040

---

Why procedure is used in sql?

1025

---

Write a sql select query that only returns each name only once from a table?

994

---

Is inner join faster than left join?

1172

---

Write a sql query to convert all character to uppercase after hypen.

1416

---

Is it possible for a table to have more than one foreign key?

1017

---

How can use stored procedures in sql?

1116

---

what is the difference between nested subquery and correlated subquery?

1028

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1107

---

What are the ddl commands?

990

---

Explain what is an index?

1034

---

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

1054

---

Why do we use cursors?

976

---

How do you pronounce sql?

988

---

What is a behavioral trigger?

961

---