Answer Posted / muhammad faisal

/*
using PL SQL code*/

declare
CURSOR emp_sub IS SELECT substr(last_name,1,1)
from employees;
name employees.last_name%type;
begin
open emp_sub;
loop
fetch emp_sub into name;
/*select last_name into name from employees;*/
dbms_output.put_line(name);
exit when emp_sub%notfound;
end loop;
close emp_sub;
end;
/

What are the built in functions of sql?

1092

---

explain advantages of myisam over innodb? : Sql dba

1111

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1115

---

What is the use of sql trace?

1003

---

How exception is different from error?

1065

---

What is embedded sql with example?

1096

---

How many databases can sql express handle?

1029

---

What are different types of queries in sql?

1172

---

Which constraints we can use while creating database in sql?

1120

---

What is crud sql?

1026

---

Why join is faster than subquery?

1159

---

What does := mean in pl sql?

1090

---

What is data abstraction in sql?

1064

---

how to fetch alternate records from a table? : Sql dba

1165

---

What is crud diagram?

993

---