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 recursive stored procedure?

1082

---

How many subqueries can be nested in a statement?

971

---

What is the difference between partitioning and sharding?

989

---

What are the packages in pl sql?

997

---

how to rename an existing table in mysql? : Sql dba

1044

---

How delete all data from table in sql?

1003

---

Why do we use view in sql?

932

---

Is merge a dml statement?

952

---

What is character functions?

1044

---

how can you create an empty table from an existing table? : Sql dba

1133

---

Explain some predefined exceptions.

1018

---

How many parts of a pl sql block are optional?

1099

---

What will you get by the cursor attribute sql%notfound?

1040

---

What is left join in sql?

1039

---

Is sql harder than python?

1076

---