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 the source code of a program?

1060

---

Can a trigger call a stored procedure?

1060

---

How does cross join work in sql?

1007

---

What is the starting oracle error number? What is meant by forward declaration in functions?

983

---

What is the difference between sql, mysql and sql server?

1085

---

how would you enter characters as hex numbers? : Sql dba

973

---

What are different types of queries in sql?

1109

---

When to use inner join and left join?

949

---

How do you sort in sql?

1001

---

what are the 'mysql' command line options? : Sql dba

1067

---

what are the differences between binary and varbinary? : Sql dba

1033

---

What is sql entity?

1086

---

How many functions are there in sql?

1002

---

What is union?

1152

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

992

---