Answer / Nitesh Nayal

In Oracle PL/SQL, you can define a variable of a specific record type using the following syntax: `<record_type_name> := new <record_type_name> (...);`

How to do paging with oracle?

1 Answers  

---

What is a user role in oracle?

1 Answers  

---

Are truncate and delete commands same? If so why?

1 Answers  

---

What is a SNAPSHOT ?

1 Answers  

---

Explain the use of full option in exp command.

1 Answers  

---

What is a server parameter file in oracle?

1 Answers  

---

How to set up autotrace for a user account?

1 Answers  

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1 Answers   MCN Solutions,

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1 Answers   Oracle,

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1 Answers   Oracle,

---

What are the benefits of ordbms?

1 Answers  

---

what is the difference between sql& oracle?

11 Answers   Oracle,

---