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 is sql in java?

543

---

What is identity column in sql server?

527

---

how many sql dml commands are supported by 'mysql'? : Sql dba

567

---

what are rollup and cube in t-sql? : Transact sql

657

---

What is having clause in sql?

527

---

---

How do you update a sql procedure?

521

---

What does data normalization mean?

526

---

What is inner join in sql?

584

---

explain what is mysql? : Sql dba

598

---

what are string data types? : Sql dba

510

---

Can we use insert statement in function?

515

---

how do you know if your mysql server is alive? : Sql dba

593

---

How to make a copy values from one column to another in sql?

572

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1556

---

how is exception handling handled in mysql? : Sql dba

549

---