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

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

Question Posted / rajesh venati

5 Answers
9954 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the plv (pl/vision) package offers?

1054

Explain the significance of the & and && operators in pl sql.

1009

What is raid? How does it help storage of databases?

1087

what is sql? : Sql dba

1030

Can we rollback delete command?

990

What is sql procedures and functions?

1012

Does sql profiler affect performance?

998

What is pl/sql language case sensitive?

1131

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

What is a sql driver?

1004

how do you tune the slow running queries in oracle db , explain the methodology

2812

What is the use of <> sql?

980

What is the difference between pl and sql?

1096

Which table is left in left join?

1017

What are triggers and its uses?

1049