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
- 10102 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the plv (pl/vision) package offers?
What is update query?
Is sql a programming?
What are pl/sql packages?
What is graph sql?
What is function and procedure in pl sql?
How do I run a sql script?
what is heap table? : Sql dba
What is delimiter in pl sql?
Which is the correct statement about truncate and delete?
What do you mean by dbms? What are its different types?
What are the types of triggers in sql?
does sql support programming? : Sql dba
what is sub-query? : Transact sql
what is the difference between join and union? : Sql dba
