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.

What is the difference among union, minus and intersect?

1001

---

what is csv? : Sql dba

999

---

what are numeric data types? : Sql dba

1064

---

How do I make my sql query run faster?

942

---

What is sql injection owasp?

1066

---

List different type of expressions with the example.

935

---

How to get each name only once from an employee table?

1116

---

Define sql delete statement.

1016

---

How do I create a sql database?

1003

---

What is procedure in pl sql?

1046

---

What is the difference between execution of triggers and stored procedures?

1116

---

How to run sql statements through the web interface?

1042

---

Can you upgrade sql express to full sql?

1070

---

What is offset in sql query?

1121

---

How are functions and procedures called in PL/SQL?

1231

---