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
- 10123 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari k
set serveroutput on;
declare
cursor c1 is select substr(name1,1,1) from tab1;
v_string tab1.name1%type;
begin
open c1;
loop
fetch c1 into v_string ;
exit when c1%notfound;
dbms_output.put_line(v_string);
end loop;
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use partitions in sql?
how can we know the count/number of elements of an array? : Sql dba
What is sqlerrd?
What is the sql case statement?
What are the types of functions in sql?
How do I run a query in pl sql developer?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how to calculate expressions with sql statements? : Sql dba
What is dcl in sql?
Why we use sql profiler?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the dml statements?
does sql support programming? : Sql dba
Define tables and fields in a database
How many postgresql users are there, worldwide?
