Answer Posted / 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.

Which version of sql do I have?

747

---

What are procedures used for?

700

---

When are we going to use truncate and delete?

716

---

how to create a new view in mysql? : Sql dba

685

---

Does truncate release storage space?

769

---

---

how to get help information from the server? : Sql dba

677

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

733

---

how to convert character strings to dates? : Sql dba

718

---

how would concatenate strings in mysql? : Sql dba

740

---

How to run pl sql program in mysql?

681

---

How to install oracle sql developer?

770

---

Is left join and outer join same?

765

---

Why do we use subquery?

703

---

what is error ora-03113: end-of-file on communication channel?

818

---

How many postgresql users are there, worldwide?

779

---