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
Explain the steps needed to create the scheduled job?
What is difference between mysql and postgresql?
what is the use of friend function? : Sql dba
What is sqlcontext?
What are the operators in sql?
Why do we need unique key in a table?
What is the difference between microsoft access and sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is the current version of postgresql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
what is cross join? : Sql dba
How do you use join?
What is an inconsistent dependency?
What is a design view?
What is example of database?