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 |
Write a unique difference between a function and a stored procedure.
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Which function is used to return remainder in a division operator in sql?
Explain autonomous transaction.
Explain the purpose of %type and %rowtype data types?
how to see the create table statement of an existing table? : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?
Explain constraints in sql?
why should required for Indexed by table in pl/sql
What is use of term?
What is an escape character in sql?
what are date and time data types? : Sql dba