write a query that returns first characters of each word in
Oracel/Sql pl sql
- 5 Answers
- 8900 Views
- I also Faced
- E-Mail Answers
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;
/
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is inner join in sql?
What is the sql case statement?
Which join is default?
What is date functions?
Why is stored procedure faster than query?
What is secondary key?
What are the topics in pl sql?
What is procedure explain with program?
How do you update f as m and m as f from the below table testtable?
What is pl sql and why it is used for?
What are the main features of cursor?
What version is sql?
Which is better varchar or nvarchar?
what is a control file ? : Sql dba
What are types of exception?
