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 blob? : Sql dba

1219

---

What does joining a thread mean?

1074

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1016

---

How do you modify a trigger?

981

---

What is trigger and how to use it in sql?

1066

---

What is the basic structure of an sql?

1155

---

Can we use loop in sql?

1010

---

Can a key be both primary and foreign?

1053

---

Why is pl sql used?

1028

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1641

---

Why are aggregate functions called so?

1012

---

What is a relationship and what are they?

1225

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1017

---

What is a system versioned table?

1040

---

How many types of keys are there in sql?

1084

---