write a query that returns first characters of each word in Oracel/Sql pl sql

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

write a query that returns first characters of each word in
Oracel/Sql pl sql

Question Posted / mohapatra.rk6

5 Answers
9688 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query that returns first characters of each word in Oracel/Sql pl sql..

Answer / priya

select substr(ename,1,1) from emp;

Is This Answer Correct ?

18 Yes

2 No

write a query that returns first characters of each word in Oracel/Sql pl sql..

Answer / murali

Answers given above are correct except one

For PL-SQL:-

DECLARE
CURSOR ECUR IS SELECT SUBSTR(ENAME,1,1) as sub_name FROM EMP;
BEGIN
FOR V_ECUR IN ECUR LOOP
DBMS_OUTPUT.PUT_LINE(V_ECUR.sub_name);
END LOOP;
END;

Note: column alias name must be given.

Is This Answer Correct ?

6 Yes

1 No

write a query that returns first characters of each word in Oracel/Sql pl sql..

Answer / rajesh venati

For SQL:-

SELECT SUBSTR(ENAME,1,1) FROM EMP;
--------------------------------------------------------------
For PL-SQL:-

DECLARE
CURSOR ECUR IS SELECT SUBSTR(ENAME,1,1) FROM EMP;
BEGIN
FOR V_ECUR IN ECUR LOOP
DBMS_OUTPUT.PUT_LINE(V_ECUR.ENAME);
END LOOP;
END;

Is This Answer Correct ?

5 Yes

3 No

write a query that returns first characters of each word in Oracel/Sql pl sql..

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

write a query that returns first characters of each word in Oracel/Sql pl sql..

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