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
- 9911 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 use of pl/sql table?
what is the bond code in materialized view?
Why select is used in sql?
Can we use joins in subquery?
What is sqlca in db2?
What is scope and visibility in PL/SQL?
What are the uses of merge?
What is asqueryable?
Can sql function call stored procedure?
How sql query is executed?
How to convert comma separated string to array in pl/sql?
What if we write return in procedure?
What does := mean in pl sql?
Why cross join is used?
what is an index? : Sql dba
