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;

Where the sql database files are stored?

1069

---

What is the order of sql select?

1085

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1220

---

what are the drivers in mysql? : Sql dba

1055

---

Is oracel sql developer written in java?

1161

---

What is the meaning of disabling a trigger?

1231

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1058

---

Which is better trigger or stored procedure?

1011

---

What is the purpose of primary key?

1068

---

how is exception handling handled in mysql? : Sql dba

1122

---

What is sql and explain its components?

1111

---

What is an index in sql with example?

1018

---

How do I access sql anywhere database?

1019

---

What is duration in sql profiler trace?

1135

---

How does postgresql compare to "nosql"?

1076

---