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

Explain the order of sql statement execution?

1045

---

how to delete an existing column in a table? : Sql dba

1005

---

How to prepare for oracle pl sql certification?

1065

---

Which is better stored procedure or query?

957

---

What is the difference between join and natural join?

927

---

What is difference between sql function and stored procedure?

1004

---

what is user defined functions? : Sql dba

1032

---

Explain the insert into statements in sql?

1006

---

How to select all records from the table?

1136

---

Is record in pl sql?

972

---

Is sqlite thread safe?

1049

---

Which join condition can be specified using on clause?

952

---

What will you get by the cursor attribute sql%found?

963

---

what is the difference between delete and truncate statement in sql? : Sql dba

1245

---

Can a foreign key be a duplicate?

911

---