Answer Posted / amit basu

Types of Cursor :

I) Implicit

II) Explicit (Explicit cursor has three sub-types)

1) Simple Cursor

2) Parameterised Cursor

3) Reference Cursor

EXPLANATION OF

I) Implicit--- SINGLE USER ONLY

II) Explicit ----- MULTI USER ONLY

How to run create database statement again?

1150

---

Explain cascading triggers.

1068

---

Explain the use of online redo log files in oracle.

1036

---

What is not equal to in oracle?

995

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2199

---

Explain what are synonyms used for?

1033

---

Which environment variables are absolutely critical in order to run the OUI?

2114

---

Explain oracle insert into command?

1108

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1010

---

what is the use of system.effective.date variable in oracle?

1109

---

Difference between varchar and varchar2 data types?

1178

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1072

---

What are privileges and grants?

1063

---

List out the types of joins.

1151

---

How to define an explicit cursor in oracle?

1031

---