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;

What is the difference between a procedure and a function?

1108

---

Which one is better subquery or joins?

1060

---

What is the process of debugging?

1068

---

Is left join same as inner join?

1126

---

how can we repair a mysql table? : Sql dba

979

---

define sql update statement ? : Sql dba

1118

---

How do I find duplicates in sql?

929

---

What is varchar data type in sql?

1082

---

Which command is used to call a stored procedure?

1000

---

What packages are available to pl/sql developers?

1057

---

Is it possible to read/write files to-and-from PL/SQL?

1101

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

---

what is isam? : Sql dba

1003

---

What is the difference between sql and isql*plus?

1094

---

What are the different type of joins in sql?

954

---