Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that returns first characters of each word in
Oracel/Sql pl sql
- 5 Answers
- 9689 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
How do I use google cloud in sql?
How is indexing done in search engines?
What is blind sql injection?
how to convert numeric values to character strings? : Sql dba
Define implicit and explicit cursors.
What is tuple in sql?
Which certification is best for sql?
What is the order of sql select?
What steps server process has to take to execute an update statement?
What is the difference between the conventional and direct path loader? : aql loader
what is top in tsql? : Transact sql
What is sqlerrm?
What is trigger price?
What is use of term?
Does normalization improve performance?
