write a query that returns first characters of each word in
Oracel/Sql pl sql
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / hari k
set serveroutput on;
declare
cursor c1 is select substr(name1,1,1) from tab1;
v_string tab1.name1%type;
begin
open c1;
loop
fetch c1 into v_string ;
exit when c1%notfound;
dbms_output.put_line(v_string);
end loop;
end;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / muhammad faisal
/*
using PL SQL code*/
declare
CURSOR emp_sub IS SELECT substr(last_name,1,1)
from employees;
name employees.last_name%type;
begin
open emp_sub;
loop
fetch emp_sub into name;
/*select last_name into name from employees;*/
dbms_output.put_line(name);
exit when emp_sub%notfound;
end loop;
close emp_sub;
end;
/
Is This Answer Correct ? | 1 Yes | 3 No |
What is sql profiler in oracle?
what is d diff between grant,commit,rollback n savepoint
Does sql*plus have a pl/sql engine?
What is indexing oracle sql?
How many types of index are there?
What are sql queries used for?
what is bcp? When does it used? : Sql dba
table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What does the hierarchical profiler does?
Mention what is the plv (pl/vision) package offers?
How do I find duplicates in a single column in sql?