write a query that returns first characters of each word in
Oracel/Sql pl sql
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 are different sql data types?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is sap sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How do I run a script in sql developer?
What is a recursive join sql?
How to start oracle sql developer?
What is dynamic sql in pl sql?
How many clustered indexes can you have?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How does cross join work?
What is numeric function sql?
Why is sql better than hql?
What is recursive stored procedure?
What are the two types of exceptions in pl/sql?