write a query that returns first characters of each word in
Oracel/Sql pl sql
- 5 Answers
- 8902 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
What is string data type in sql?
What is pragma in sql?
What is clustered index sql?
Explain character-manipulation functions?
What is data control language (dcl)?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the cause of mutating table error and how can we solve it?
Can we group by two columns in sql?
What is sql injection vulnerability?
What is the mutating table and constraining table?
What is sql profiling in oracle?
What is graph sql?
What is a pl/sql block?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
