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

Why we use joins in sql?

1032

---

Name three sql operations that perform a sort.

1056

---

What is normalisation and its types?

1040

---

What is delete command in sql?

1164

---

how to create a table index in mysql? : Sql dba

1116

---

What is data control language (dcl)?

1202

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1102

---

what is oltp (online transaction processing)? : Sql dba

1122

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2231

---

How do you declare a variable in pl sql?

1064

---

Which sql statement is used to delete data from a database?

1000

---

What are predefined functions in sql?

1099

---

How do you explain an index?

1327

---

What is the difference between rollback and rollback to statements?

1097

---

What is java sql drivermanager?

1157

---