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 pls_integer in pl sql?

1091

---

what is the difference between char and varchar data types? : Sql dba

1076

---

what are the different functions in sorting an array? : Sql dba

1010

---

What is pl sql code?

1042

---

What is a table in a database?

1041

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1008

---

what are enums used for in mysql? : Sql dba

1163

---

How does index help in query performance?

1022

---

Mention what plvcmt and plvrb does in pl/sql?

1130

---

What are tables and fields?

1027

---

Can a commit statement be executed as part of a trigger?

1044

---

How to find 3rd highest salary of an employee from the employee table in sql?

1075

---

what is row? : Sql dba

1219

---

How do I count rows in sql?

995

---

What is delimiter in pl sql?

1050

---