Answer / Hariom

The Data Manipulation Language (DML) statements in SQL and PL/SQL are used to retrieve, insert, update, and delete data from a database. The main DML statements include SELECT (retrieves data), INSERT (inserts new data), UPDATE (updates existing data), DELETE (deletes data), MERGE (performs conditional updates or inserts), and TRUNCATE (removes all records from a table).

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How much does sql cost?

1 Answers  

---

Does sql*plus also have a pl/sql engine?

1 Answers  

---

Is primary key is clustered index?

1 Answers  

---

What are the three forms of normalization?

1 Answers  

---

how to install mysql? : Sql dba

1 Answers  

---

Mention what pl/sql package consists of?

1 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

Are stored procedures compiled?

1 Answers  

---

What is user defined functions?

1 Answers  

---

Why do we go for stored procedures?

1 Answers  

---

Difference between truncate, delete and drop commands?

1 Answers  

---