What is difference between hql and native sql?

0 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

Is join and inner join the same?

0 Answers  

---

---

What is the execution plan in sql?

0 Answers  

---

What are the different ways to optimize a sql query?

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

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,

---

What is pl sql quora?

0 Answers  

---

Can we create table inside stored procedure?

0 Answers  

---