Answer / Kajal

In Oracle PL/SQL, you can declare a local variable using the `VARIABLE` keyword followed by the name and data type of the variable. Here's an example:nn```sqlnDECLAREn my_variable VARCHAR2(50);nBEGINn ...nEND;n``

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 Answers  

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

What is difference between a formal and an actual parameter?

1 Answers  

---

Explain what are the uses of rollback segment?

1 Answers  

---

What is a oracle database?

1 Answers  

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1 Answers  

---

a query to select maxmun 3 salaries of employee table

12 Answers   IBM, Polaris,

---

How to connect to the server with user account: sys?

1 Answers  

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

Explain integrity constraints?

1 Answers  

---

How to do a full database export?

1 Answers  

---